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.


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.


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
 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


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