BI Publisher (MOSC)

MOSC Banner

oracle.apps.fnd.framework.OAException: java.sql.SQLException: No corresponding row found in XDO_LOBS

edited Mar 9, 2018 4:00AM in BI Publisher (MOSC) 9 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center