My Oracle Support Banner

R12 E-Business Suite Technology Stack Database Upgrade From - 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 to, some programs are failing due to changes in 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 but works in 



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.