My Oracle Support Banner

R12 E-Business Suite Technology Stack Database Upgrade From 11.2.0.3 - 11.2.0.4 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.

Symptoms

E-Business Suite 12.2 Technology Stack, Database for Application Technology related issues

 

 



After a database upgrade from 11.2.0.3 to 11.2.0.4, some programs are failing due to changes in 11.2.0.4 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 11.2.0.4 but works in 11.2.0.3: 

  

Cause

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
Symptoms
Cause
Solution
References


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