Item Exchange rate variance Is Not Considered In OPM Costing when invoice is created after receiving and before delivering (Doc ID 1990744.1)

Last updated on APRIL 05, 2017

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Item ERV is not considered in OPM Costing
Exchange rate difference is not getting considered in item cost after running Actual Cost Process in case of PO receipt for an LCM enabled organization.
Under certain conditions, ERV is not transferred to OPM Costing, using LCM adjustments .

This happens when invoice is created after receiving the goods into receiving location and before delivering to inventory.


STEPS

1. Create Po
Receive it to receiving destination
Conversion rate is 4

2. Run Landed cost Integration Manager
Run Shipments Interface Import

3. Match item Invoice
Rate is different from Receipt (3.889 instead of 4)
Validate invoice
Run Matches Interface Import
Run Submit Pending Shipments

4. Receive PO receipt into Deliver destination

5. Run Landed cost Integration Manager
Run Shipments Interface Import
Run Landed Cost Adjustments Import Process

6. Landed Cost Screen shows:
200,000.00-194,450.00=5,550, this is ERV (4-3.889)= 0.111 multiplied by the amount 50,000=5,550
Until here everything is ok.

7. Run Actual Cost Process
Actual Transaction View
It shows :
Source =PO receipt, Orgn=MAP, Ref=1377, Cost=200, qty=1000

Customer expectation:
Should be here LCM Adjustment with the ERV Amount

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