Baseline Definition For GL 12.1 Includes Non-supported Objects (Doc ID 1668190.1)

Last updated on SEPTEMBER 11, 2024

Applies to:

Symptoms

On :  5.5.1 version, Integra Apps

ACTUAL BEHAVIOR  
---------------
The baseline definition for Change tracking GL 12.1 are including some objects from 11.5.10 that are not supplied or supported for 12.1 in CCG.  GL intercompany accounts object appears in the GL 12.1 baseline definition.  When deploying the definition GL intercompany accounts will cause an error. GL.GL_INTERCOMPANY_ACCOUNTSr table does not have SET_OF_BOOKS_ID which is required in trigger logic. SET_OF_BOOKS_ID is present  in  11.5.10 object table. Set of books does not exist in the R12 table.

EXPECTED BEHAVIOR
-----------------------
Baseline definition should only include the same objects as a definition created manually.  They both should conform to CCG551_OracleMetadata.pdf

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure R12 target.
2. Review baseline definition for GL 12.1, note GL intercompany accounts is viewable.
3. Create manual definition for GL 12.1 note GL intercompany accounts is not present.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Confusion and errors when trying to deploy change tracking for GL 12.1 from baseline definition. GL intercompany accounts trigger cannot not be deployed due to table differences between the two EBS versions.

Cause

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