India GST: Incorrect Line Amount Captured In JAI_IRN_DETAILS table For RMA Credit Memo With Discount Line. (Doc ID 2917788.1)

Last updated on MARCH 23, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Wrong data for discount line in total_amount column in jai_irn_details table for RMA Credit Memo.

EXPECTED BEHAVIOR
-----------------------
Data for discount line in total_amount column in jai_irn_details table for RMA Credit Memo should match the jai_irn_extract data for original sales order line.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. navigate to India Local Order Management responsibility.
2. Enter a sales order. Add the line items.
3. Discount line is applied as a part of adjustments done at Sales order level. ( Customer is using the Modifiers functionality to apply the discounts.)
4. Book the sales order.
5. At shipment level the consolidated amount (after discount is adjusted).
6. This data is pushed into the JAI_IRN_EXTRACTS table as the Tax Point Basis (Delivery).
7. Later AR invoice is imported against this order.
8. Now RMA is done against this sales order.
9. Against the RMA the AR Credit Memo is created.
10. Data against the RMA Credit Memo is inserted into JAI_IRN_DETAILS table.
11. It is observed that TOTAL_AMOUNT column shows incorrect value in JAI_IRN_DETAILS table.
12. The discount line amount is reflecting as positive value in in JAI_IRN_DETAILS table. Whereas this should be negative value.
13. Because of this the discount is getting added to TOTAL_AMOUNT column in JAI_IRN_DETAILS table and increases overall amount.

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.