Incorrect Decimals Displayed Between Procurement and Cost Transactions (Doc ID 2803670.1)

Last updated on SEPTEMBER 05, 2021

Applies to:

Symptoms

There are different values for Merchandise Amount Base between procurement and cost accounting transactions.

For example, in eProcurement (ePro) Requisition, Purchase Order (PO), Receipt, Voucher, and Payment the Merchandise Amount Base is 20.02 USD while Cost Accounting lines showing 20 USD where there is a difference of 0.02 USD.
This issue creates a loss for the Inventory department and the General Ledger (GL) will show a different amount in both ledgers.

How could these transactions have the same amount?

Steps to Reproduce the Issue:
1. Defined the Market Rate conversion for example between 1 USD = 3.6725 EUR
Navigation Set Up Financials/Supply Chain > Common Definitions > Market Rates > Market Rates
2. Create ePro Requisition – Special request raised for
Business Unit = US001
Currency = EUR
Price 5.4459 EUR (Merchandise Amount Base 20.02 USD)
3. Then create transactions under Purchase Order (PO), Receipt, Voucher, and Payment. The system creates these transactions with Merchandise Amount Base is 20.02 USD.
4. Create Inventory and Cost Accounting transaction under Business Unit = US010.
Then check the results under navigation Cost Accounting > Inventory and Mfg Accounting > Review Transaction Details > Inventory Transactions
Notice Cost Accounting transaction in US010 = 20.00 USD while the rest of transactions were 20.02 USD, and from these resulting in a difference of 0.02 USD.

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.