oracle.apps.fnd.framework.OAException: java.sql.SQLException: No corresponding row found in XDO_LOBS
I have a case where I am receiving the following error:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: No corresponding row found in XDO_LOBS
I checked the following note:
Unable To Upload/Update Template Into Xml Publisher / Bi Publisher (Doc ID 459086.1)
But my customer is not facing any issue in TEST, DEV instances even though the XDO_LOBS contain only one row for that specific template.
Ran the query in all the 3 instances (DEV-Working Fine, TEST-Working Fine, UAT-Problem).
Problem LOB_CODE name is XXSPWR_WSHRDPAK.
Uploaded Query_Results.xls with the results for all 3 instances.
I really appreciate any hints.