My Oracle Support Banner

Cost Import Process not importing attributes in cst_item_costs table (Doc ID 2334489.1)

Last updated on AUGUST 17, 2021

Applies to:

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


On : 12.2.6 version,  Cost Maintenannce
When attempting to run CSTPCIMP: Cost Import Process using insert to interface table cst_item_cst_dtls_interface , for the attributes (attribute1, attribute2) the following error occurs.

The attributes (attribute1, attribute2) were being updated to cst_item_cost_details but not in cst_item_costs table

The issue can be reproduced at will with the following steps:

1) Insert data in cst_item_cst_dtls_interface table
2) Call Cost Import process. Parameters --> Import "Import item costs only", "Remove and replace cost information" etc.
3) Program will insert the data in cst_item_costs and cst_item_cost_details table. But attributes will be updated only in "cst_item_cost_details" and not in
   cst_item_costs tables


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

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