In an Oracle Ebiz 12.1.3 database, selecting an object of the type "AOL Registered Tables" works fine, but when fetching an Archive Set, Stat shows the following error:
'ERROR: Exception encountered while processing event 1247'
In the log file, the error message appears after running the following statement:
select A.APPLICATION_SHORT_NAME,
B.BUILDING_BLOCK_NAME,
T.TABLE_NAME,
T.USER_TABLE_NAME,
T.TABLE_TYPE,
T.DESCRIPTION,
T.AUTO_SIZE,
T.INITIAL_EXTENT,
T.NEXT_EXTENT,
T.MIN_EXTENTS,
T.MAX_EXTENTS,
T.INI_TRANS,
T.MAX_TRANS,
T.PCT_FREE,
T.PCT_INCREASE,
T.PCT_USED,
T.HOSTED_SUPPORT_STYLE,
fnd_load_util.owner_name(T.LAST_UPDATED_BY) OWNER,
to_char(T.LAST_UPDATE_DATE, 'YYYY/MM/DD') LAST_UPDATE_DATE
from FND_TABLES T,
FND_APPLICATION A,
FND_BUILDING_BLOCKS B,
FND_BUILDING_BLOCK_OBJECTS BO
where A.APPLICATION_ID = T.APPLICATION_ID
and (:APPLICATION_SHORT_NAME is null or
(:APPLICATION_SHORT_NAME is not null
and A.APPLICATION_SHORT_NAME like upper(:APPLICATION_SHORT_NAME)))
and A.APPLICATION_ID = B.APPLICATION_ID
and (:BUILDING_BLOCK_NAME is null or
(:BUILDING_BLOCK_NAME is not null
and upper(B.BUILDING_BLOCK_NAME) like upper(:BUILDING_BLOCK_NAME)))
and BO.APPLICATION_ID = B.APPLICATION_ID
and BO.BUILDING_BLOCK_ID = B.BUILDING_BLOCK_ID
and BO.OBJECT_TYPE= 'T'
and BO.OBJECT_APPLICATION_ID = T.APPLICATION_ID
and BO.OBJECT_ID = T.TABLE_ID
and (:TABLE_NAME is null or
(:TABLE_NAME is not null and T.TABLE_NAME like upper(:TABLE_NAME)))
order by 1, 2
These selects also give an error, because the tables are not there.
select * from FND_BUILDING_BLOCKS B
select * from FND_BUILDING_BLOCK_OBJECTS BO
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center