After Upgrading To 12.1.1 AR Package Compilation Error Raises ORA-00904
Last updated on FEBRUARY 01, 2018
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.
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