Package ARP_PROC_RCT_UTIL Is Invalid On 10g (Doc ID 2126352.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Following error is showing when creating Misc Receipts:
MISC_RECEIPTS_EVENT.insert_row_procedure raised unhandled exception
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04063

After checking the invalid objects, found out that package ARRURGWB.pls is invalid.

Following errors shows when compiling package:

SQL> alter package ARP_PROC_RCT_UTIL compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY ARP_PROC_RCT_UTIL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1886/13 PLS-00382: expression is of wrong type
1886/13 PLS-00436: implementation restriction: cannot reference fields of
BULK In-BIND table of records



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