R12: Master GDF is Picking Up Signature 37 Due to ROUNDING_AMT (Doc ID 2986296.1)

Last updated on DECEMBER 13, 2023

Applies to:

Symptoms

When creating a foreign invoice and entering an invoice amount
for 100 and a Line amount for 75, validate the invoice and a
LINE VARIANCE hold is placed. Now update the Line Amount and Distribution
Amount to 100 and re-validate the invoice and the hold is released.

The AP_INVOICE_DISTRIBUTIONS_ALL table is showing ROUNDING_AMT=37.5 which is incorrect.

When running the Master GDF, signature MGD-37 is picked up as per below, which is correct, due to the incorrect ROUNDING_AMT.

Impact Area(s): Accounting Failure

Findings and Recommendations:
Solution GDF: 22297430
Note: Doc ID 1276043.1
Script Name: ap_wrong_base_amt_sel.sql

Apply the GDF patch following the instructions provided in Doc ID 1276043.1

IMPORTANT: This fix will undo accounting.

You should apply the consolidated UNDO Accounting Patch 14082924 before
applying the GDF patch for this issue. Without this patch undo accounting
failures may not be properly reported and the GDF may appear to fail to fix
the data when in fact an undo error has occurred.

NOTE:For transactions posted in closed periods the reversing and corrected
events will be accounted in the current open period.
For a deeper understanding of the undo accounting process please refer to Doc
ID 753695.1

Steps to Reproduce:

1. Create a foreign currency invoice with Invoice Amount=100 and at the line level Amount=75.

2. Validate the invoice which places a LINE VARIANCE hold on the invoice.

3. Update the Line Amount and Distribution Amount to 100.

4. Re-validate the invoice and the hold is released.

5. Run the Master GDF for the invoice and the Signature MGD-37 is picked up because the

AP_INVOICE_DISTRIBUTIONS_ALL is showing an incorrect ROUNDING_AMT=37.5.

Cause

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