My Oracle Support Banner

Layer Cost Update error in MTL_TRANSACTIONS_INTERFACE ORA-6512 CSTPACIT.cost_det_move (Doc ID 550650.1)

Last updated on APRIL 04, 2025

Applies to:

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

Goal

On 11.5.10.2 AND ABOVE..
Using the MTL_TRANSACTIONS_INTERFACE, an Imported FIFO Layer Cost Update has been loaded into the system. when processing the transaction though it is remaining in the MTL_TRANSACTIONS_INTERFACE table with the following error:

CSTPACIT.cost_det_move :oracle.jdbc.driver.OracleSQLException: ORA-6502:
PL/SQL: numeric or value error ORA-6512: at ""APPS.CSTPLENG"", line 4608
ORA-06510: PL/SQL: unhandled user-defined excepti"

PROCESS_FLAG=3 (Error)
LOCK_FLAG = 2 (Not locked)
TRANSACTION_MODE= 3
SOURCE_CODE=Layer Cost Update

How can the Layer Cost Updates via the MTL_TRANSACTIONS_INTERFACE table be processed successfully?

Solution

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
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.