R12 E-Business Suite Technology Stack Database Upgrade From 220.127.116.11 - 18.104.22.168 Causes Create Accouting Programs To Fail With Error 'ORA-904 or ORA-942 invalid identifier'
(Doc ID 2435497.1)
Last updated on NOVEMBER 13, 2019
Applies to:Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.
E-Business Suite 12.2 Technology Stack, Database for Application Technology related issues
After a database upgrade from 22.214.171.124 to 126.96.36.199, some programs are failing due to changes in 188.8.131.52 RDBMS code.
For example the create accounting programs will begin failing for Receivables, Payables, and Cost Management with the following error:
'An internal error has occurred in the program xla_je_validation_pkg.validate_third_parties. ORA-00904: "T"."PARTY_ID": invalid identifier.'
After further investigation the following query fails with same error message in 184.108.40.206 but works in 220.127.116.11:
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