My Oracle Support Banner

All Batch Functions (Batch Creation, Reschedule, Re Route) Are Too Slow, Performance Problem (Doc ID 2530098.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, API Issues

ACTUAL BEHAVIOR
---------------
Customer reports that all Batch-related APIs (batch creation, reschedule, re route) are too slow. Using the standard forms, things are slow also. For example, a trace from creating a batch manually shows a query that took almost 100 seconds. Query is:

SELECT NULL, TO_CHAR(ACTUAL_QTY), TO_CHAR(BACKORDERED_QTY), TO_CHAR(BATCH_ID)
  , TO_CHAR(FORMULALINE_ID), TO_CHAR(INVENTORY_ITEM_ID), ITEM_DESC, ITEM_NO,
  DTL_UM, TO_CHAR(LINE_NO), TO_CHAR(LINE_TYPE), LINE_TYPE_MEANING,
  TO_CHAR(LOCATOR_ID), LOCATOR, TO_CHAR(MATERIAL_DETAIL_ID),
  TO_CHAR(MATERIAL_REQUIREMENT_DATE,'YYYYMMDD HH24MISS'),
  MATERIAL_REQUIREMENT_DATE_DT, TO_CHAR(ORGANIZATION_ID), TO_CHAR(PHANTOM_ID),
  TO_CHAR(PHANTOM_LINE_ID), TO_CHAR(PLAN_QTY), REVISION,
  TO_CHAR(ROUNDING_DIRECTION), TO_CHAR(SCALE_MULTIPLE),
  TO_CHAR(SCALE_ROUNDING_VARIANCE), TO_CHAR(SCALE_TYPE), TO_CHAR(SCRAP_FACTOR)
  , SUBINVENTORY, TO_CHAR(WIP_PLAN_QTY), RELEASE_TYPE, RELEASE_TYPE_MEANING,
  PHANTOM_TYPE, COST_ALLOC, CONTRIBUTE_YIELD_IND,
  CONTRIBUTE_YIELD_IND_MEANING, CONTRIBUTE_STEP_QTY_MEANING,
  CONTRIBUTE_STEP_QTY_IND, ORIGINAL_QTY, BY_PRODUCT_TYPE,
  BY_PRODUCT_TYPE_MEANING, DISPENSE_IND_MEANING, DISPENSE_IND
FROM
  GME_STEP_MATERIAL_DETAILS_V WHERE 1=1 and step_id = :Batch_STEP_ID order
  by line_type,line_no


Gather statistics is run every night

EXPECTED BEHAVIOR
-----------------------
Expect good performance

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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