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' (Doc ID 2095737.1)

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.

Goal

 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?

Solution

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