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 MAY 23, 2017

Applies to:

Oracle Cost Management - Version 12.0.0 and later
Information 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     =3D 3
legal entity id =3D 23276
cost type id    =3D 1000
period id       =3D 23001
coost group id  =3D 3000
proc. types     =3D 2
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: 4267555
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

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