CSTPPINV.get_perp_ship_cost (10): ORA-00001: Unique Constraint (INV.MTL_PAC_TXN_COST_DETAILS_U1)
Last updated on JUNE 07, 2018
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Costing Transaction Errors
The Periodic Average Cost Processor (Periodic Actual Cost Worker)is launched for a specific month, and it ends in error.
The procedure indicated that this might be due to the insert statement at row 2105 of the package CSTPPINV. The procedure finds 12 records and it expects just one.
The following Bug 21788195, solves this issue in 12.2.4 version, but this is occurring in the 12.1.3 version.
CSTPPINV.get_perp_ship_cost (10): ORA-00001: unique constraint (INV.MTL_PAC_TXN_COST_DETAILS_U1) violated
The issue can be reproduced at will with the following steps:
Navigation Path Inventory Responsibility
1. Launch the PAC processes for period close
2. Periodic Average Cost Processor is launched and shows error status
3. Review the related logfile and see the error message
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