ASCP Query Slow For Planner Is Empty Condition And Unable To Export The Data From Workbench
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
ORGANIZATION_ID=1651 AND SR_INSTANCE_ID=1 AND 2=2
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms