PAC Costing Problem: Transaction Stuck in the MTI MTL_Transactions_interface: The PAC Periodic Update Transaction Fails with Error Message 'NO OPEN PERIOD FOUND FOR DATE ENTERED'
(Doc ID 2023514.1)
Last updated on APRIL 18, 2023
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 and R12.2.4 versions, Inventory Costing
ACTUAL BEHAVIOR
---------------
While upgrading the R11 instance to R12.2.4. We use "Oracle EMEA Add-on Localizations User Guide for Turkey – Discrete Manufacturing"document to setup Turkey localization.
Oracle EMEA Add-on Localizations
User Guide for Turkey Discrete Manufacturing
Release 12.2
Part No. E15565-01
The PAC Costs are calculating incorrectly.
EXPECTED BEHAVIOR
-----------------------
The costs to be calculated correctly
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1- Create new item
2- Open PO with this item (Quantitiy: 10, unit_price: 10)
3- Match PO to Invoice (Quantitiy: 10, unit_price: 15)
4- System create an IPV on invoice as 50 TL( Turkish Lira).
5- Run costing programs.
6- System calculate unit cost as 10TL.
The correct cost is 15TL for one sample.
1. Run Periodic Cost Update
2. Find that the transactions inserted into the Transaction Open Interface mtl_transactions_interface table
are failing with error = No Open Period
Note: Customer working with PAC since 2008. Customer updates Periodic Cost
Update for closed inventory periods. The update is taking place in customer
master organization GLO (organization_id = 103) for which customer never
opened any period.
Customer notes: " transaction open interface is Periodic Cost Update which
should evaluate the transaction date against the periodic period and not the
inventory period."
Support Notes: Inventory Code inspected and should be skipped over for PAC
process when transaction type is for a PAC interface row.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cost transactions in error
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |