"Report Pending Cost Adjustments" Performance Issue

(Doc ID 2393960.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Cost Management - Version and later
Information in this document applies to any platform.


 "Report Pending Cost Adjustments" Performance Issue

There is a performance issue with concurrent job "Report Pending Cost Adjustments".
After checking with our internal DBA, this job is stuck at the insert statement below.

INSERT INTO cst_std_cost_adj_temp (transaction_type,
  DECODE (WE.entity_type,
  5, WRO.costed_quantity_issued,
  FROM wip_discrete_jobs WDJ,
  wip_accounting_classes WAC,
  wip_requirement_operations WRO,
  cst_item_costs_temp CICT,
  wip_entities WE
  WHERE ( ( ( ( ( ( ( ( ( ( WRO.organization_id =
  AND WRO.inventory_item_id =
  AND ( (

Expect this to run in appropriate time


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