E1: 03B: The RR Rounding Record is Created in the Receipts Header Table (F03B14) with an Incorrect G/L Date Value when Working a Foreign Currency Deduction (F03B14, P03B40). (Doc ID 2749857.1)

Last updated on FEBRUARY 04, 2021

Applies to:

Symptoms

Any cash receipt can be created with multiple deductions on it via Standard Receipts (P03B102). These deductions can be worked at different times.

When the cash receipt is in a foreign currency for a foreign currency invoice or invoices and has a different exchange rate than the invoice(s) matched on it, the system may use the R7 AAI to create a rounding record, with document type RR, in the Receipts Header table (F03B14). When the deductions on the receipt are worked at different times, with different exchange rates, whichever deduction is worked last, has a RR record created for it with an incorrect GL date: the system uses the GL date of the receipt creation and not that of when the deduction was worked.

STEPS TO REPRODUCE

1. P0015A: exchange rate setup for USD and CAD
2. P03B11: create invoices and credit memos with the following values:

3. Post the invoices and credit memos.
4. P03B102: create the receipt header as follows:
   1. GL date: 9/18/2020
   2. receipt amount: 89,019.28
   3. transaction curr: CAD
   4. base curr: USD
   5. exchange rate: 1.3178

With following invoice applied and deductions created:

5. Post the receipt
6. P03B40: match R5 nr 2 and nr 3 to RM 1 and RM 2 respectively, using Tickler = G/L date 12/31/2020, exchange rate 1.2812
7. Post the batch
8. P03B40: for R5 nr 3, using Tickler = G/L date 12/31/2020, exchange rate 1.2812:
   800. Apply 9,800.00 to RM 4
   801. Apply 139.55 to RM 3
   802. Apply 165.61 to RM 5
9. Post the batch: the post goes into error due to the GL date of the RR record created via Step 8: the GL date is 9/18/2020 instead of 12/31/2020.

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.