Account Level Discrepancy Report Creation Issue (Doc ID 2673263.1)

Last updated on JUNE 17, 2021

Applies to:

Symptoms

On : 2.9.0.0.0 version

ACTUAL BEHAVIOR
---------------
When generating an Account Level Discrepancy Report, additional discrepancy lines from other Accounts (within the Group Customer structure) are included.
For example, a Parent Group Customer has 2 Accounts: Account X and Y.
If an Account Level Discrepancy Report is generated for Account X, the discrepancies belonging to Account Y are also included in the report.

EXPECTED BEHAVIOR
-----------------------
Account level discrepancy report should only contain discrepancies for the specific account chosen.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Pick one account, and try to generate an Account Level Discrepancy Report via ORMB UI;
2. Run the batch job to generate the discrepancy report lines;
3. Check the C1_DISCREPANCY_RPT_LN table, and notice that it included the other ACCT_IDs under the same group person on this supposed to be account level only report.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the proper records in the Discrepancy Report.

Changes

Cause

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