My Oracle Support Banner

PERORMANCE ISSUE WITH MSC_X_HZ_PLAN.POPULATE_BUCKETED_QUANTITY (Doc ID 974519.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Collaborative Planning - Version 11.5.10 to 12 [Release 11.5 to 12]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 in Production:
Find that reports taking around 9 mins, this is too long from users point of view.
The procedure taking long time is :

BEGIN MSC_X_HZ_PLAN.populate_bucketed_quantity(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15); END;

SELECT OWNER_ITEM_NAME,SUPPLIER_ITEM_NAME,CUSTOMER_ITEM_NAME, UOM_CODE,NVL(TP_UOM_CODE, UOM_CODE) ,OWNER_ITEM_DESCRIPTION,
SUPPLIER_ITEM_DESCRIPTION,CUSTOMER_ITEM_DESCRIPTION
FROM MSC_SUP_DEM_ENTRIES_UI_V WHERE INVENTORY_ITEM_ID = :B5 AND
PUBLISHER_ORDER_TYPE = :B4 AND PUBLISHER_NAME = :B3 AND CUSTOMER_NAME = :B2 AND SUPPLIER_NAME = :B1 AND ROWNUM < 2

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 6854 2.70 2.42 0 0 0 0
Fetch 6854 846.90 827.36 0 13371700 0 6854
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 13708 849.60 829.79 0 13371700 0 6854

The issue can be reproduced at will with the following steps:

EBS procurement user running bucket reports from the portal

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.