BMCCLTG - Calculate Manufacturing Lead Times GUI Performance Problem (Doc ID 1403733.1)

Last updated on MAY 15, 2016

Applies to:

Oracle Bills of Material - Version 11.5.10.1 and later
Information in this document applies to any platform.

Goal

Performance problems with process BMCCLTG -  Calculate Manufacturing Lead Times GUI  

It shows the sentence which is time consuming:

SELECT COM.COMPONENT_ITEM_ID
FROM
MTL_SYSTEM_ITEMS MTL2, BOM_INVENTORY_COMPONENTS COM, MTL_SYSTEM_ITEMS MTL1,
BOM_BILL_OF_MATERIALS BOM WHERE NVL(BOM.ALTERNATE_BOM_DESIGNATOR,
'XXXXXXXXXXX') = NVL(:B5 ,'XXXXXXXXXXX') AND COM.BILL_SEQUENCE_ID =
BOM.COMMON_BILL_SEQUENCE_ID AND BOM.ORGANIZATION_ID = :B4 AND
BOM.ASSEMBLY_ITEM_ID = :B3 AND MTL1.INVENTORY_ITEM_ID =
BOM.ASSEMBLY_ITEM_ID AND MTL1.ORGANIZATION_ID = BOM.ORGANIZATION_ID AND
MTL2.INVENTORY_ITEM_ID = COM.COMPONENT_ITEM_ID AND MTL2.ORGANIZATION_ID =
BOM.ORGANIZATION_ID AND COM.IMPLEMENTATION_DATE IS NOT NULL AND
NVL(COM.ECO_FOR_PRODUCTION,2) = 2 AND NOT (MTL1.REPLENISH_TO_ORDER_FLAG =
'Y' AND MTL1.BOM_ITEM_TYPE = 4 AND MTL1.BASE_ITEM_ID IS NOT NULL AND
MTL2.BOM_ITEM_TYPE IN (1,2)) AND ( COM.DISABLE_DATE IS NULL OR
COM.DISABLE_DATE > :B1 ) AND ((MTL1.EFFECTIVITY_CONTROL <> 1 AND :B2 IS NOT
NULL AND COM.DISABLE_DATE IS NULL AND :B2 BETWEEN
COM.FROM_END_ITEM_UNIT_NUMBER AND NVL(COM.TO_END_ITEM_UNIT_NUMBER, :B2 ))
OR (MTL1.EFFECTIVITY_CONTROL = 1 AND COM.EFFECTIVITY_DATE <= :B1 ))
 

Steps:

  1. Navigate to Bills of Material > Routings > Lead Times 
  2. Run the program: Calculate Manufacturing Lead Times GUI 

Solution

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