My Oracle Support Banner

The ACCTD_AMOUNT_APPLIED_FROM Has The Incorrect Amounts using the MOAC Responsibility. (Doc ID 2700004.1)

Last updated on AUGUST 11, 2020

Applies to:

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

Symptoms

The receipt data corruption occurs when the user creates the receipt after query other currency receipt using MOAC responsibility.

Following steps will make the data corruption on the receipt data.

Scenario:

The precision of JPN is 0 and HKD is 2.

1. Create the transaction for book JPN and HKD

  JP15may20-I01 USD 107.87 rate 107.259 (JPN: 11,570)
  HK15may20-I01 USD 107.87 rate 7.75164 (HKD: 836.17)

2. Query the receipt from OU:HKD

3. Create the receipt for OU:JPN

  JP15may20-R01 USD 208.98 rate 107.259 (JPN: 22,414)

4. Apply to JP15may20-I01

The data corruption occurs as follows.
The precision of JPN is 0. So, the ACCTD_AMOUNT_APPLIED_FROM should be 11570 instead of 11570.03. And the CURR_ROUND shouldn't be generated.

The ACCTD_AMOUNT_DUE_REMAINING should be -775.16 ( -1611.33 -(- 836.17) = -775.16) instead of -775.33.

This issue occurs if the exchange rate is rate type with 'User'.

Both issue will make the corruption data that will be listed on the "STATUS is CLOSED but ACCTD_AMOUNT_DUE_REMAINING <> 0" in the result of the Receivables Reconciliation Analyzer Report(Note:2255895.1).

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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