My Oracle Support Banner

Questions Related to LEAF_ONLY_FLAG Value From DIM_GL_ACCOUNT Table In Reconciliation Context (Doc ID 2387876.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Risk Management (ERM)
Oracle Financial Services Analytical Applications Reconciliation Framework (GL Recon)
Slowly Changing Dimension (SCD)

Goal

In the context of running the out of the box SCD 127, the GL_ACCOUNT_CODE with LEAF_ONLY_FLAG is 'N' was noticed to be inserted into DIM_GL_ACCOUNT table.

 

Please help clarify below questions:

Question 1: Why is DIM_GL_ACCOUNT required to have GL_ACCOUNT_CODE with LEAF_ONLY_FLAG = 'N'?

Question 2: Does the Reconciliation Framework apply for all Child GL (General Ledger) Codes, if selecting only the Parent GL Code?
 

Solution

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
Goal
Solution


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