Last updated on APRIL 04, 2017
Applies to:Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.
Users are finding discrepancies when trying to query using Sales Agreement Number on Quick Order Organizer and Standard Order Organizer.
Sales Agreements have been created our for our customers and are being used on the Orders.
If we query on the Quick Order Organizer/Order Organizer using Sales Agreement Numbers only then we see the list of all Sales Agreements.
If we query using the Customer Name or Number and Sales Agreement Number as an additional criteria for searching orders using Quick Order Organizer, the Sales Agreement LOV does not show any value (even though Sales Agreements exist for the customer).
There is no error there is just no data returned.
Order Management Responsibility
1. Open either the quick order organizer or the standard order organizer
2. query by agreement - returns data
3. query by customer - returns data
4. query by customer and agreement - returns no data.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms