SPWA - Drill Down From Favorites(exceptions,Metrics) Doesnt Work As Expected. (Doc ID 2876003.1)

Last updated on JANUARY 18, 2023

Applies to:

Symptoms

Drill down from Favorites, Types (exceptions, metrics) to exception table doesn’t honor/consider the favorites definition/conditions

NAV: ASCP (R) / Supply Chain  / Supply Planning Work Area - choose plan
Step 1: Search Favorites -> Type = Exceptions / Metrics
Step 2: Choose exception or metrics
Step 3: From the results ( choose a record) and drill down to Exceptions View

Issue :Exception tab doesn't fetch the correct data (Doesn't honor the exception when drilled down from favorites ( exception/ info tile) results.

Example:

Go to Favorites--->Click on Exceptions--->Click on our Favorite called "Items with expired lots"
This Favorite is setup to search all items with exception "Items with expired lots" and expiration date is less than 180 days

We get back X number of records with exception " Items with expired lots", which expire in under 180 days.
Pick an exception and Drill to Details

This opens the Exception view and shows All of that items expiring Lots across the entire plan horizon  - which is much longer than 180 days
-- This item had 4 lots expiring within 180 days and another 8 lots after 180 days - the Exceptions view showed all 12 records

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.