Multiple Issues with Aging Buckets Data on Case Folders When Compared to the Data in Receivables and Advanced Collections Application (Doc ID 1930451.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Credit Management - Version 12.0.1 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

Multiple Issues with Aging Buckets Data On Case Folders When Compared to the Data in Receivables and Advanced Collections Application.

ISSUE 1:  Credit Exposure amount that is displayed on 'View All Data' Link is not accurate.  
Unable to figure out where this is coming from because this information is not changing and not matching up to the amount showing up on Credit Exposure Summary Report. 
This issue exists for every customer.

ISSUE 2: Open Invoice Amount showing on 'Update Case Folder' page is not matching up to the Open Invoice Amount showing up on 'View All Data' for all case folders.
This issue exists for every customer.

ISSUE 3: Receivable Balance on Case Folder pages is not matching to the Receivable Net Balance showing in IEX.  
This issue exists for every customer. 
OCM is adding up the following columns from summary tables: OP_INVOICES_VALUE, OP_DEBIT_MEMOS_VLAUE, OP_CREDIT_MEMOS_VALUE, etc. and UNRESOLVED_CASH_VALUE.  Actually the value for UNRESOLVED_CASH_VALUE should be subtracted from the sum of all open transaction columns.

ISSUE 4: Aging Buckets showing up on OCM Case Folders are not matching up to the buckets on AR and IEX.

Steps to Reproduce:
1. Create Case Folder
2. Review Receivable balance to be incorrect.
3. Open Invoice Amount showing on 'Update Case Folder' page is not matching up to the Open Invoice Amount showing up on 'View All Data' for all case folders.
4. Credit Exposure amount is not correct.

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