CMCPAW Periodic Actual Cost Worker raises CSTPPINV.COST_INV_TXN:CSTPPINV.COST_INV_TXN: (50): ORA-01403: No Data Found
(Doc ID 1456553.1)
Last updated on SEPTEMBER 19, 2019
Applies to:
Oracle Cost Management - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
Inventory Costing
CMCPAW module: Periodic Actual Cost Worker is raising the following error message:
ERROR
-----------------------
CSTPPINV.COST_INV_TXN:CSTPPINV.COST_INV_TXN: (50): ORA-01403: no data =found
Processing failure on phase 5.
STEPS TO VERIFY THE ISSUE
--------------------------------
The issue can be reproduced at will with the following steps:
1. Cost Managment
2. Periodic Costing
3. Run PAC Acquisition process
CMCPAW module: Periodic Actual Cost Worker
+---------------------------------------------------------------------------+
Current system time is 23-APR-2012 17:24:20
+--------------------------------------------------------------------------+
debug_level =3D 0
CM_EXTENDED_DEBUG =3D 2
Parameter:
cost method = <cost method>
legal entity id = <legal entity id>
cost type id = <cost type id>
period id = <period id>
coost group id = <group id>
proc. types = <proc types>
proc. upto date =3D 2012/04/30
Start Validation
Complete Validation
Running from 2012/04/01 00:00:00 to 2012/04/30 00:00:00
Start Phase : 2
Start Processing Phase 2
Complete Purging Phase 2 - 5
Complete Beginning Balance Setup
Finish Processing Phase 2
Start Processing Phase 3
Complete LLC Computation
Finish Processing Phase 3
Start Processing Phase 4
Complete WIP Job Build
Finish Processing Phase 4
Start Processing Phase 5
Transfer cost flag not set for this LE=20
Complete Processing Periodic Cost Update : 0 txns
Complete Processing Periodic Cost Update : 0 txns
Complete processing group 1 : 5 txns
Complete Processing Periodic Cost Update : 85 txns
txn_id: <transaction id>
CSTPPINV.COST_INV_TXN:CSTPPINV.COST_INV_TXN: (50): ORA-01403: no data =found
Processing failure on phase 5.
a)
(transaction_type = 26)
Changes
Removed Shipping Network setup.
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 |
Changes |
Cause |
Solution |
References |