OBIA 11g Costing- Item Cost Subject Area Is Not Loading Standard Cost while running the ETL (Doc ID 1986529.1)

Last updated on DECEMBER 16, 2015

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.1 version, DataWarehouse
Costing- Item Cost Subject area is not loading standard Cost

While running the ETL you are not seeing Standard Cost for Products loaded in Costing- item Cost SA. On analysis you found this SA is loaded through the following interfaces :-

  1. SDE_ORAR1213_ADAPTOR_SDE_ORA_CSTITEMCOST_DAILY_FACT_PROCESS
  2. SDE_ORAR1213_ADAPTOR_SDE_ORA_CSTITEMCOST_DAILY_FACT_DISCREET
  3. SDE_ORA_ITEMCOSTGENERAL_PROCESS

The Process interface is not loading any data. Discreet Interface is loading only actual cost using a EBS table, MTL_CST_ACTUAL_COST_DETAILS.  Process interface needs to pull data if it is relevant for process manufacturing.

You need all costs in Costing- Subject area actual & standard.

Cause

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