Exception Counts And Recommended Planned Order In Planner Workbench Is Not Matching (Doc ID 1598769.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Exception query does not pull correct records.
Date limitation appears to not be properly reading/calculating the Days from Today value in the preference set.

STEPS
-------------
Query exceptions and see that we have very few recommendations for release of work orders and requisitions
AND PLANNER_CODE = '16492'
AND ORGANIZATION_CODE = 'BIO:UPM'
The preferences are setup for View Recommendations (Days from Today) - 500

When we query supply and demand in the workbench using
ORG BIO:UPM'
Planner 16492
make or buy - Buy
sugg Due date Less than 31-MAR-2014
This pulls 619 records

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