My Oracle Support Banner

CAP 8.1.2.4.2 - Error In T2T ENTITY_INFO_HIER_DATA_POP Script (Doc ID 3045113.1)

Last updated on SEPTEMBER 06, 2024

Applies to:

Oracle Financial Services Basel Regulatory Capital Internal Ratings Based Approach - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

In Basel 8.1.2.4.2,T2T ENTITY_INFO_HIER_DATA_POP - Issue in the LEFT JOIN :

LEFT OUTER JOIN DIM_ORG_STRUCTURE Z ON $MISDATE BETWEEN Z.D_RECORD_START_DATE AND Z.D_RECORD_END_DATE AND Z.V_ENTITY_CODE = DIM_ORG_STRUCTURE.V_PARENT_CODE

The “DIM_ORG_STRUCTURE.V_PARENT_CODE” reference looks incorrect. Using this join results in the parent entity skey being null consistently.

Changes

 

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
Changes
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.