Executing Personal And Public Queries In ASCP Work Bench Not Giving The Right Results

(Doc ID 2181928.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms in Production

Client created queries in the workbench.  When run incorrect data is returned.
Orgs other than CW1 and CD1 are returned.

Create query
Query Name: Bob's Messages
Query Type: Orders

Criteria: Organization
Condition: Among
From: MAS:CW1, MAS:CD1

Criteria: Order Type
Condition: Equals
From: Planned Order

Criteria: Suggested Order Date
Condition: Less Than
From: 15-APR-2016

Run against plan MRP_Ongoing
Org returned MAS:CM2 - Not an org in the query.


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