After Upgrading To 12.1.1 AR Package Compilation Error Raises ORA-00904
(Doc ID 1301520.1)
Last updated on FEBRUARY 20, 2019
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.