My Oracle Support Banner

How to Control the Amount of Plan Recommendations Returned By a Query in Supply Chain Workbench (Doc ID 2971375.1)

Last updated on AUGUST 30, 2023

Applies to:

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


How do you control the amount of Plan Recommendation records returned when querying data in the Supply Chain Workbench?

For example, from the Supply Chain Workbench, using the Navigator window (Actions)

  1. Navigation:  Supply Chain Plan > Workbench > Plans > [Plan Name] > Current > Recommendations > Purchase Requisitions > Right-click on [Org] > Supply and Demand > Supply
  2. Enter the following filter criteria
    1. Org Equals [Org]
    2. Make or Buy Equals Buy
    3. Order Type Equals Planned order
    4. Item Equals A

How do you limit the data returned to only 180 days worth of data?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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