ASCP Plan Run Is Successful But There's No Data In The ASCP Workbench - MSC_DEMANDS, MSC_SUPPLIES, MSC_ORDERS_V Have Zero (0) Rows For the PLAN_ID (Doc ID 1620232.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Memory Based Planner

Users are on 12.1.1 and have applied R12.1.1 CU3 Patch 8602258. This is a brand new instance. The users run an ASCP plan and it completes successfully. However there's no data in the workbench output (blank). The data files have data in MSLD_SUPPLIES.dat and MSLD_DEMANDS.dat which is strange. When reviewing table msc_supplies and msc_demands for the plan_id in question, no data is returned. Also the view msc_orders_v has no data as well. There is a forecast schedule with forecast data in the future attached to the ASCP plan and the data is successfully collected

EXPECTED BEHAVIOR
-----------------------
After running ASCP plan workbench should not be blank and data should be available for the plan_id in msc_demands, msc_supplies and msc_orders_v

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility : Advanced supply chain planner
2. Navigation : Supply chain planning > workbench
3. Workbench is blank after running plan

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