My Oracle Support Banner

DGS OBIEE VA - Usage of LRI Filter in GL Drill Down Reports (Doc ID 2763597.1)

Last updated on MARCH 30, 2021

Applies to:

Oracle Financial Services Data Governance for US Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

DGS Variance Analysis OBIE Reports - GL Level 2 Drill down

The query should use LRI flag condition when the join is on 'CODES' and not on 'SKEY' column

Ex:

Condition 1:
When using the "V_GL_ACCOUNT_CODE" or ACCOUNT CODE then Use F_LATEST_RECORD_INDICATOR

Condition 2 :
When using the "N_GL_ACCOUNT_SKEY" or any SKEY then DO NOT USE F_LATEST_RECORD_INDICATOR

Changes

 NA

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.