"Report Pending Cost Adjustments" Performance Issue

(Doc ID 2393960.1)

Last updated on MAY 02, 2018

Applies to:

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

Symptoms

 "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,
  source_type,
  organization_id,
  inventory_item_id,
  wip_entity_id,
  operation_seq_num,
  department_id,
  adjustment_quantity,
  transaction_id)
  SELECT /*+ LEADING (CICT) +*/
  3,
  1,
  WRO.organization_id,
  WRO.inventory_item_id,
  WRO.wip_entity_id,
  WRO.operation_seq_num,
  WRO.department_id,
  DECODE (WE.entity_type,
  5, WRO.costed_quantity_issued,
  WRO.quantity_issued),
  TO_NUMBER (NULL)
  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 =
  :b0
  AND WRO.inventory_item_id =
  CICT.inventory_item_id)
  AND ( (

EXPECTED BEHAVIOR
-----------------------
Expect this to run in appropriate time

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