Error While Trying To View ECO Attachments Under Item Simple Search Page - 'You have encountered an unexpected error. Please contact your System Administrator for assistance.' (Doc ID 2909946.1)

[52]:UNEXPECTED:[fnd.framework.webui.OAPageErrorHandler]:oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: select * from ( SELECT * FROM (SELECT a.ATTACHED_DOCUMENT_ID,
      a.DOCUMENT_ID,
      a.CREATION_DATE,
      a.CREATED_BY,
  decode(a.CREATED_BY,-1, (select message_text from fnd_new_messages where message_name = 'FND_ANONYMOUS_USER_NAME' and application_id = 0 and language_code = userenv('LANG')),
       (select distinct party_name from ego_user_v where user_id=a.CREATED_BY)) CREATED_BY_NAME,
      a.LAST_UPDATE_DATE,
      a.LAST_UPDATED_BY,
   decode(a.last_updated_by,-10000,(select message_text from fnd_new_messages where message_name = 'FND_WORKFLOW_USER_NAME' and application_id = 0 and language_code = userenv('LANG')), decode(a.last_updated_by,-1, (select message_text from fnd_new_messages where message_name = 'FND_ANONYMOUS_USER_NAME' and application_id = 0 and language_code = userenv('LANG')),
       (select distinct party_name from ego_user_v where user_id=a.last_updated_by))) LAST_UPDATED_BY_NAME,
      a.ENTITY_NAME,
      a.PK1_VALUE,
      a.PK2_VALUE,
      a.PK3_VALUE,
      a.PK4_VALUE,
      a.PK5_VALUE,
      nvl(a.CATEGORY_ID, d.CATEGORY_ID) AS CATEGORY_ID,
      ct.USER_NAME AS CATEGORY_NAME,
  decode (d.datatype_id,8,file_ext.status,a.STATUS) status,
      d.DOCUMENT_ID AS DOCUMENT_ID1,
      d.DESCRIPTION,
      d.FILE_NAME FILE_NAME,
      d.DATATYPE_ID,
      d.MEDIA_ID,
      nvl(d.DM_NODE,0) DM_NODE,
decode(d.dm_node, null, 'EBS', n.SHORT_NAME) REPOSITORY_NAME,
      d.DM_TYPE,
      d.DM_FOLDER_PATH,
      d.DM_DOCUMENT_ID,
      d.DM_VERSION_NUMBER,
      n.SERVICE_URL ,
      'ADMIN' AS SESSION_TYPE,
d.url URL,
d.USAGE_TYPE,
   (select MEANING from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'DOM_ATTACHED_DOC_STATUS' and LOOKUP_CODE=nvl(decode (d.datatype_id,8,file_ext.status,a.STATUS),'UNAPPROVED')) status_disp,
       a.CATEGORY_ID ATTACHMENT_CATEGORY_ID,
decode(d.FILE_NAME, null, (select message_text from fnd_new_messages where message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG')), d.FILE_NAME) FILE_NAME_DISP,
nvl(df.default_folder,'N') default_folder,
null action,
'N' Disable_Selection,
'N' Detach_Flag,
'Y' update_flag,
nvl(a.CATEGORY_ID, d.CATEGORY_ID) AS CATEGORY_ID_COPY,
d.FILE_NAME FILE_NAME_COPY,
d.DESCRIPTION DESCRIPTION_COPY,
d.title,
'N' Desktop_File
FROM FND_ATTACHED_DOCUMENTS a,
    FND_DOCUMENTS_VL d,
    FND_DOCUMENT_CATEGORIES_TL ct,
    DOM_REPOSITORIES n,
dom_file_ext file_ext,
    DOM_FOLDER_ATTACHMENTS df
WHERE a.DOCUMENT_ID = d.DOCUMENT_ID and
     ct.CATEGORY_ID = nvl(a.CATEGORY_ID, d.CATEGORY_ID) and
     ct.LANGUAGE = USERENV('LANG') and
     d.DM_NODE = n.ID (+)
     and df.attachment_id(+)=a.attached_document_id
 and file_ext.repository_id(+)=d.dm_node
 and file_ext.version_id(+)=d.dm_document_id) QRSLT  WHERE ((entity_name = :0 and pk1_value = :1 and pk2_value = :2 and pk3_value = :3 and (category_id in (:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17) or category_id is null)) and not exists(select 1 from eng_attachment_changes eng  where eng.attachment_id = attached_document_id  and eng.change_id = :18 and eng.ENTITY_NAME = 'MTL_ITEM_REVISIONS' and eng.PK1_VALUE = '105' and eng.PK2_VALUE = '26469616' and eng.PK3_VALUE = '36489192' ) )  union all  (select eng.attachment_id ATTACHED_DOCUMENT_ID,  eng.source_document_id,   eng.CREATION_DATE,   eng.CREATED_BY,   decode(eng.CREATED_BY,-1, (select message_text from fnd_new_messages where message_name = 'FND_ANONYMOUS_USER_NAME' and application_id = 0 and language_code = userenv('LANG')),  (select ltrim(hz.party_name, '*')  from fnd_user u, hz_parties hz where u.user_id=eng.CREATED_BY  and u.person_party_id=hz.party_id)) CREATED_BY_NAME,   eng.LAST_UPDATE_DATE,    eng.LAST_UPDATED_BY,   decode(eng.last_updated_by,-1, (select message