My Oracle Support Banner

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

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.