How To Build Data In CST_ITEM_COSTS Table Based On CST_ITEM_COSTS_DETAILS Table? Err 'Item cost should be defined before you transact'
Last updated on APRIL 17, 2017
Applies to:Oracle Cost Management - Version 12 and later
Information in this document applies to any platform.
Data is missing from CIC table, but is present in CICD table.
Provides datafix for the error
'Item cost should be defined before you transact'
which occurs while transacting the items .
This can occur in following cases
a)Data doesn't exists both in CST_ITEM_COSTS (CIC) and CST_ITEM_COST_DETAILS (CICD)
b)Data exists in CICD and doesn't exists in CIC
Cursor 'no_cic_cicd' handles case (a)
Cursor no_cic handles case (b)
Inputs required are cost method and bug number
How To Build Data In CST_ITEM_COSTS Table Based On CST_ITEM_COSTS_DETAILS Table?
How to check via SQL? Use this query:
If the query returns rows than there are items where cost details are not populated in the CST_ITEM_COSTS (CIC) table, but CST_ITEM_COSTS_DETAILS (CICD) table contains data for these these items.
You need to build data in CIC tables based on CICD where data is present.
How to build data in CST_ITEM_COSTS table based on CST_ITEM_COSTS_DETAILS table?
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