ASCP Query Slow For Planner Is Empty Condition And Unable To Export The Data From Workbench (Doc ID 2024160.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Using Advanced Supply Chain Planning / Planner's Workbench
On 12.2.3 in Production:
When attempting to perform a search of the Supply/Demand form
using the criteria 'Planner' and condition 'is empty',
find that it takes 1 hour 20 minutes to fetch the first 60 rows of supply/demand results.

EXPECTED BEHAVIOR
-----------------------------------

Expect the find to complete in seconds.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. (R) Advanced Supply Chain Planner
2. Open Planner's Workbench
3. Query the workbench with the condition Planner is empty.


-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot reasonably identify supply and demand that needs
to have a valid Planner assigned.

SQL ID g1v12rb0g74wq
SELECT ORGANIZATION_CODE,ITEM_SEGMENTS,ASSET_GROUP,REQUESTED_START_DATE,
.......
 PARENT_MODEL_ITEM_NAME
FROM
 MSC_ORDERS_V WHERE plan_id = :1 and ((order_type NOT IN ( 18, 6, 7, 30, 31))

  or (order_type IN (18, 6, 7, 30) and quantity_rate <> 0) or (order_type =
  30 and (fill_kill_flag = 1 or so_line_split =1)) or (order_type = 31 and
  quantity <> 0)) and category_set_id = 15 and sr_instance_id = :2 and
  organization_id = :3 AND -1=-1 AND 2=2 AND PLANNER_CODE IS NULL AND
  ORGANIZATION_ID=1651 AND SR_INSTANCE_ID=1 AND 2=2


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