My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.