My Oracle Support Banner

REVERSAL CREDIT MEMO CREATION COST ISSUE DUE TO DECIMAL POINTS ROUNDING ISSUE (Doc ID 2860167.1)

Last updated on MAY 17, 2022

Applies to:

Oracle Retail Invoice Matching - Version 19.0.1 to 19.0.1 [Release 19.0]
Information in this document applies to any platform.

Symptoms

Debit Memo(Cost) Reversal (Credit Memo) creation cost Issue due to Decimal Points Rounding issue.
 
Not able to reverse the Debit Memo (Cost) in a particular scenario where the Database value is not matching with the value which is populated by the system on the front end screen.

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

1. Set the CURRENCY_COST_DEC column value to 4 in the table CURRENCIES.
2. Set the CURRENCY_COST_DEC column value to 2 in the table IM_CURRENCIES.
3. Create the Purchase order with an item unit-cost with 10213.5960 and qty as 1 and ship and receive the PO.
4. Create the merchandise document (Invoice) for the created PO with the Unit_cost 20427.1920 and qty as 1 with discrepancy value.
5. Match the invoice by clearing the discrepancy with "Receipt(Order) Unit Cost" Unit Cost Resolution.
6. Run the Reimrollup batch to create the DM for cost discrepancy resolution.
7. Capture the Table level data of the created DM and note the values.
8. Open the front end application and search the created Debit Memo(DM) by providing the PO number and check the values on the Front end screen.
9. Select the DM and reverse the DM and it triggers to create the Credit Memo(CM), the CM screen will open, note down the values and provide the reason code on the screen without changing any values. Try to click on the submit button and system will throw the attached error message and will not allow you to reverse the Debit memo due the value difference (in decimals) between the table level value (four/three decimal and the screen value which is rounded to two decimals).

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
References


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