R12: Drilldown To Cash Receipts From GL Fails With: ORA-06510: PL/SQL: Unhandled User-Defined Exception (Doc ID 834179.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Receivables - Version 12.0.4 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

Attempting to drilldown to Misc Receipts in General Ledger and receive the following error:

Error:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.ARP_AUTO_ACCOUNTING", line 7756
ORA-06512: at "APPS.ARP_AUTO_ACCOUNTING", line 7759

FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06510

Responsibility:  General Ledger Superuser
Navigation:  Inquiry > Account
Enter search criteria
Go To:  Account > Period
Click Show Journal Details
Journals screen comes up
Select a Receivables/Misc Receipts Journal
Click Drilldown
Web page comes up
Click View Transaction button

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms