WRONG VALUE IN SUBLEDGER FOR PO RECEIPT TRANSACTIONS USING BRAZILIAN LOCALIZATION (Doc ID 1067400.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Process Manufacturing Financials - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Symptoms

Using brazilian localization for receiving that considers local taxes along with PMAC cost method in OPM Financials module: It is observed that Receiving value in cost transactions is correct. The receiving value in receiving distributions is correct. The receiving value in subledger is wrong

Difference between the actual cost and the subledger amount is due to difference between po_line_locations_all.price_override and rcv_transactions.po_unit_price.

Steps:
1. Enter a PO
2. Enter a receiving transaction in Integrated receiving module
3. Run Actual Cost in OPM Financials: Check the receiving value
4. Run Cost Update process
5. Run OPM Accounting Pre-processor
6. Run Create Accounting process
7. Run Detailed Subledger Report
8. Review the Detailed Subledger Report and see the Unit Price (i.e. 1,5)
9. Reviewing the Actual Cost Transactions Cost = 1,23, there is a difference between PO Line Locations (po_line_allocations_all.price_override = 1,5) and PO Unit Price (rcv_transactions.po_unit_price =1,23)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms