Found Item Cost Details (CST_ITEM_COST_DETAILS) record was missing for a specific Cost Type (Doc ID 2935205.1)

Last updated on SEPTEMBER 15, 2024

Applies to:

Symptoms

On : 12.1.3 version, Cost Maintenance

When attempting to review item cost information for specific cost type the following error occurs.

ERROR
-----------------------
Found that Inventory item cst_item_costs exists but details are missing in cst_item_cost_details


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Review item cost information for the inventory_item_id, organization_id  and cost_type_id.

a. View  the the form

    Responsibility : Cost Management
    Navigation: Item Cost Summary Screen > Enter Organization id, Item Number

b. Retrieve data thru Sql Query  (SQLPLUS)

    Please run as below and provide the output in excel format  with column headings:

    Select * from cst_item_costs where inventory_item_id = &Item_id and organization_id = &org_id;
    Select * from cst_item_cost_details where inventory_item_id = &Item_id and organization_id = &org_id;   

Changes

Cause

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