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 JUNE 21, 2023

Applies to:

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

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