Duplicate Actual LC Adjustment records in Actual Cost Transactions View (Doc ID 1968748.1)

Last updated on APRIL 05, 2017

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.4 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Actual Cost Process

ACTUAL BEHAVIOR
---------------
LCM item cost for PO return/correct is wrong, which shows 1 in item costs form.

Source Orgn Reference Component Class Code Analysis Code Cost Quantity
PO Receipts PR2 2051 1-MATERIAL DIR 1 100
PO Receipts PR2 2051 1-MATERIAL DIR 0 -10
PO Receipts PR2 2051 1-MATERIAL DIR 1 -10
Actual LC Adjustment PR2 6 | 1 | 2051 1-MATERIAL DIR -10 0
Actual LC Adjustment PR2 6 | 1 | 2051 LCMPENNY LCMPENNY 10 0
Actual LC Adjustment PR2 6 | 1 | 2051 1-MATERIAL DIR 1 0
Actual LC Adjustment PR2 6 | 1 | 2051 LCMPENNY LCMPENNY -1 0

EXPECTED BEHAVIOR
-----------------------

Item Price:
Amount: 90, Unit Landed Cost: 1
Charge:
Amount: 10, Unit Landed Cost: 0.11111 --10/(100-10), 10 is total charge of PO 100units and PO return is 10units.

Item Cost is 1+0.11111=1.11111
Source Orgn Reference Component Class Code Analysis Code Cost Quantity
PO Receipts PR2 2051 1-MATERIAL DIR 1 100
PO Receipts PR2 2051 1-MATERIAL DIR 1 -10
Actual LC Adjustment PR2 6 | 1 | 2051 LCMPENNY LCMPENNY 10 0
Actual LC Adjustment PR2 6 | 1 | 2051 LCMPENNY LCMPENNY -1 0



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Item : LCM-TAI
2. Cost Factor : LCMPENNY
3. Disabled all relevant pricing modifier. (planned to enter freight invoice via cost factor directly)
4. Create PO XXXX, 100unit LCM-TAI @1, approve it.
5. Do receipt of the PO.
6. Run 'Landed cost Integration Manager' in purchasing
7. Run 'Shipments Interface Import' in LCM
8. Do return of PO XXXX: 10 units.
9. Run 'Landed cost Integration Manager' and 'Shipments Interface Import'
10. Create invoice for item : LCM-TAI-ITEM
11. Create invoice for freight : LCM-TAI-CHARGE (enter freight invoice via cost factor directly, no estimated lcm charges)
12. Run 'Matches Interface Import' and 'Submit Pending Shipments' in LCM
13. Run 'Landed Cost Adjustments Import Process' and 'Actual Cost Process' in OPM Financials

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