My Oracle Support Banner

Executing Personal And Public Queries In ASCP Work Bench Not Giving The Right Results (Doc ID 2181928.1)

Last updated on FEBRUARY 25, 2019

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: 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.


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.