My Oracle Support Banner

After Upgrading To 12.1.1 AR Package Compilation Error Raises ORA-00904 (Doc ID 1301520.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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


After upgrading to 12.1.1, there are several AR Invalid Objects raising ORA-09004 errors, due to extra/unnecessary columns in some AR tables.

ARP_CREDIT_MEMO_MODULE is invalid due to presence of RA_CUSTOMER_TRX_LINES_ALL.INVOICING_RULE_ID (this field should only be in RA_CUSTOMER_TRX_ALL).

ARP_PROCESS_HEADER PACKAGE is invalid due to presence of RA_CUSTOMER_TRX_ALL.GL_DATE (this field should only be in RA_CUST_TRX_LINE_GL_DIST_ALL).

Review of <Bug 285493> shows that these fields existed in the tables.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.