IPAC Incorrect QTY And Cost After Create Back Inter Org Transfer (Doc ID 2471659.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

On : 12.2.7 version,

ACTUAL BEHAVIOR
---------------
Users have observed incorrect Quantity and Cost when creating inter-Organization transfers, after IPAC.

EXPECTED BEHAVIOR
-----------------------
Users expect to receive a fix,in order to have the expected quantities and cost for the Inter-Organization transfer transaction.

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

1. IPAC Incorrect QTY and Cost when inter organization transfer
Users have incorrect QTY and Cost after create back inter org transfer.
New Item is created LV72_TEST and assigned to org TPC and TC2. TPC and TC2 have different PAC Cost
Groups.
Create “Miscellaneous receipt” for item LV72_TEST in TPC. QTY = 500, Unit Cost = 300
Create “Direct Org Transfer” LV72_TEST from TPC to TC2. QTY = 200

2 On-hand after creation transactions
Org: TPC
Sub: SC1
Locator: SC1
Item: LV72_TEST
Onhand: 300

Org: TC2
Sub: SC1
Locator: SC1
Item: LV72_TEST
Onhand: 200

3 Create Periodic Cost Update transaction in TPC Cost Group
Item: LV72_TEST
Prior Period Quantity: 0
Level: This
Cost element: Resource
Prior Periodid Cost: 0.0000
Inventory Value Change: 4000

4 Run Iterative Periodic Average Cost Processor

5 Run Periodic Cost Distributions Processor for TPC and TC2 cost groups

6 Check Results

7 Run Periodic Inventory Value Report for TPC and TC2 cost groups

8 View Material and Receiving Transactions > Tools > View Accounting
8.1
TPC Miscellaneous receipt QTY +500

8.2
TPC Periodic Cost Update

8.3
TC2 Direct Org Transfer QTY +200

8.4
Users have correct QTY, Cost, Accounting data in PAC and Inventory for TPC and TC2 cost groups.

9.
Create back inter org transaction from TC2 to TPC. QTY = 100
Users have stock balance TPC = 400, TC2 = 100

10.
Run Iterative Periodic Average Cost Processor with same parameters
Run Periodic Cost Distributions Processor for TPC and TC2 cost groups
Check Results
Run Periodic Inventory Value Report for TPC and TC2 cost groups

TPC Organization showing:
Quantity 600 (must be 400),
Unit Cost 250 (must be 308),
Cost element Material 250 (must be 300)
Cost element Resource 0(must be 8)

TC2 Organization showing:
Quantity 200 (must be 100),
Unit Cost 0 (must be 308),
Cost element Material 0 (must be 300)
Cost element Resource 0 (must be 8)

11.
View Material and Receiving Transactions > Tools > View Accounting
11.1
TPC Miscellaneous receipt QTY +500 (OK)

11.2
TPC Periodic Cost Update (OK)

11.3
TPC Direct Org Transfer QTY -200 (ERROR)

Periodic Distributions transactions are not created.
Users expected Periodic Distributions (see 7.Check Results TPC Direct Org Transfer QTY -200)

11.4
TPC Direct Org Transfer QTY +100 (ERROR)
Periodic Distributions transactions are created, but with 0 cost.
Uses expected Periodic Distributions transactions
Debit Inv valuation Material 100*300,
Debit Inv valuation Resource 100*8
and Credit Inter-org Payable 100*308

11.5
TC2 Direct Org Transfer QTY +200 (ERROR)
Periodic Distributions transactions are created, but with OVERHEAD cost 250.
Users expected Periodic Distributions transactions (see 7.Check Results TC2 Direct Org Transfer QTY +200

11.6
TC2 Direct Org Transfer QTY -100 (ERROR)
Periodic Distributions transactions are not created.
Users expected Periodic Distributions transactions
Credit Inv valuation Material 100*300,
Credit Inv valuation Resource 100*8
Debit Inter-org Receivables 100*308
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

Cause

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