CSTPPINV.get_perp_ship_cost (10): ORA-00001: Unique Constraint (INV.MTL_PAC_TXN_COST_DETAILS_U1) (Doc ID 2181403.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.
 
 

ERROR
-----------------------
CSTPPINV.get_perp_ship_cost (10): ORA-00001: unique constraint (INV.MTL_PAC_TXN_COST_DETAILS_U1) violated




STEPS
-----------------------
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

 

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