ARXCCS Customer Credit Snapshot Will Not Complete Takes 100% Cpu (Doc ID 1274819.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2, 11i.AR.O after applying <> to get the latest version of ARXCCS.rdf 115.40.15104.8, and attempting to run the ARXCCS report without parameters, the following error occurs.


MSG-00100: DEBUG: coll_name_low:
MSG-00100: DEBUG: coll_name_high:
MSG-00201: Currency Code USD does not have a valid exchange rate defined.
REP-1419: 'c_credit_amounts_calcformu0114': PL/SQL program aborted.


The issue can be reproduced at will with the following steps:

1. Submit the ARXCCS report without parameters


Business impact:

Due to this issue, users cannot run the report for all customers.

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