Custom Program Included In Shipping Document Set Errors oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: No corresponding LOB data found
(Doc ID 2914090.1)
Last updated on JULY 01, 2024
Applies to:
Oracle Shipping Execution - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
Added a custom concurrent program to the Shipping Document Set which needs to be kicked off at the time of ship confirm, but does not produce any report output .
Program does not complete successfully and errors with the following:
ERROR
-----------------------
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: No corresponding LOB data found :
SELECT L.FILE_DATA FILE_DATA,DBMS_LOB.GETLENGTH(L.FILE_DATA) FILE_LENGTH, L.LANGUAGE LANGUAGE, L.TERRITORY TERRITORY, B.DEFAULT_LANGUAGE DEFAULT_LANGUAGE,
B.DEFAULT_TERRITORY DEFAULT_TERRITORY, B.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.START_DATE START_DATE,
B.END_DATE END_DATE, B.TEMPLATE_STATUS TEMPLATE_STATUS, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.DS_APP_SHORT_NAME DS_APP_SHORT_NAME,
B.DATA_SOURCE_CODE DATA_SOURCE_CODE, L.LOB_TYPE LOB_TYPE
FROM XDO_LOBS L, XDO_TEMPLATES_B B
WHERE L.APPLICATION_SHORT_NAME= :1
AND L.LOB_CODE = :2
AND L.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
AND L.LOB_CODE = B.TEMPLATE_CODE
AND (L.LOB_TYPE = 'TEMPLATE' OR L.LOB_TYPE = 'MLS_TEMPLATE')
AND ( (L.LANGUAGE = :3
AND L.TERRITORY = :4)
OR (L.LANGUAGE= B.DEFAULT_LANGUAGE
AND L.TERRITORY= B.DEFAULT_TERRITORY ))
SELECT L.FILE_DATA FILE_DATA,DBMS_LOB.GETLENGTH(L.FILE_DATA) FILE_LENGTH, L.LANGUAGE LANGUAGE, L.TERRITORY TERRITORY, B.DEFAULT_LANGUAGE DEFAULT_LANGUAGE,
B.DEFAULT_TERRITORY DEFAULT_TERRITORY, B.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.START_DATE START_DATE,
B.END_DATE END_DATE, B.TEMPLATE_STATUS TEMPLATE_STATUS, B.USE_ALIAS_TABLE USE_ALIAS_TABLE, B.DS_APP_SHORT_NAME DS_APP_SHORT_NAME,
B.DATA_SOURCE_CODE DATA_SOURCE_CODE, L.LOB_TYPE LOB_TYPE
FROM XDO_LOBS L, XDO_TEMPLATES_B B
WHERE L.APPLICATION_SHORT_NAME= :1
AND L.LOB_CODE = :2
AND L.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
AND L.LOB_CODE = B.TEMPLATE_CODE
AND (L.LOB_TYPE = 'TEMPLATE' OR L.LOB_TYPE = 'MLS_TEMPLATE')
AND ( (L.LANGUAGE = :3
AND L.TERRITORY = :4)
OR (L.LANGUAGE= B.DEFAULT_LANGUAGE
AND L.TERRITORY= B.DEFAULT_TERRITORY ))
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. OM Super User Responsibility.
2. Shipping.
3. Documents.
4. Document Sets.
5. Add custom report to ship confirm document set.
6. Ship Confirm.
7. Report prints error.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |