Monthly Archives: May 2015

Oracle R12 Reports Customizations REP-2103, REP-57054

page Scenario

Run Customized Purchase Order Report (Portrait) in Oracle Apps R12 and you hit the above issue

The PO Print error thrown is masking the actual cause of the issue. Verified the standard PO report works fine with problematic Purchase Orders. But the custom PO RDF throws an error.

So, in order to re-construct the error, re-apply the customizations one at a time to the standard PO report to replicate which customization is causing the issue.

http://vagnvagensbygg.se/firmenit/4425  Issue

Enter Password: 
MSG-00010: I
REP-2103: Column 'PLL_SHIP_ADDRESS_STATE_CODE' : PL/SQL formula returned invalid value or no value.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 
REP-2103: MSG-00010: I
REP-2103: Column 'PLL_SHIP_ADDRESS_STATE_CODE' : PL/SQL formula returned invalid value or no value.

moved here Cause

The standard report works fine. Then most probably, the customizations that have gone in would be the cause of the error.

http://homelogistic.fr/49926-benadryl-diphenhydramine-uk.html Fix

Try increasing the Custom formula/summary and placeholder columns discover here Column Width to maximum (lets say 25000) and then try running the custom report. If it fixes the issue, run a hit and trial method to find the custom summary/formula/placeholder column which is the cause of the issue.