Credit Exposure Report Incorrect When Using On-line Not Pre-calculated Exposure (Doc ID 1599216.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Fulfillment

ACTUAL BEHAVIOR
---------------
Even after applying Patch 11662722:R12.ONT.B with file OEXUCERB.pls vesion 120.2.12010000.6:

When the user unchecks the 'Use Pre-calculated Exposure' box in the Credit Check Rule, the Credit Exposure Report for the same customer is not the same.
They have queries that show that the correct data appears on the report when they have the 'Use Pre-calculated Exposure' box checked and they run "Initialize Initialize Credit Summaries Table" request: Then then we get correct Credit Exposure amount on running Credit Exposure Report.
However if 'Use Pre-calculated Exposure' box is unchecked, and they run the Credit Exposure Report for the same customer, then Credit Exposure amount is incorrectly calculated correct.
They do no have a lot of exposure for customers, so they want to leave this box unchecked so that exposure is calculated real time and they do not have to run the "Initialize Initialize Credit Summaries Table" request to update the tables.

EXPECTED BEHAVIOR
-----------------------
Expect that Credit Check would be the same when 'Use Pre-calculated Exposure' box is unchecked

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management
2. Credit Check Rule setup > 'Use Pre-calculated Exposure' box is checked
3. Run "Initialize Initialize Credit Summaries Table" request
4. Run 'Credit Exposure Report' and verify the exposure for a customer
3. Credit Check Rule setup > 'Use Pre-calculated Exposure' box is unchecked
6. Run 'Credit Exposure Report' and verify the exposure for same customer nad see that exposure is not the same and incorrect

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get get correct exposure unless they check the 'Use Pre-Calculate Exposure' box in the credit check rule and Run " Initialize Credit Summaries Table" request.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms