Is It Possible To Create An Embedded SQL Query In A Sales Order Form Folder? (Doc ID 2858576.1)

Last updated on AUGUST 08, 2024

Applies to:

Goal

How to embed a SQL query into a created Folder?
----------------------------------------------------------
Seeking a way to create a custom Folder on the Order Organizer using a complex query
that cannot be crafted using the available fields in the Find functionality. In one example,
users have items that have two different order holds applied to them (hold A and hold B).

Example:
---------
Trying to create a custom Folder that will show orders containing these items where
Hold A has been released but where Hold B is still applied.

Step-by-step process:
1. Log into Order Organizer
2. Using the Find functionality, define a condition where an existing Order Hold has been released.
3. Create the custom query to retrieve all orders in a given date range where that condition applies. (This is current state.)
4. Repeat steps 1,2 and 3, but define two separate conditions in step 2:
  2a. Where an existing Order Hold A has been released, and
  2b. Where a different Order Hold B has been applied
5. This is where the problem occurs. The Find functionality on the Holds tab only allows a condition
  for a single Order Hold. Users need to be able to query for two different Order Hold conditions and
  to return all sales orders in a given date range, but cannot determine how to do that. Users would
  propose to embed a SQL query, in the same way that SQL queries can be included in standard
  Oracle Folder functionality.

Unable to figure out how to create the necessary query using the available Find fields
(which limit the users to querying based on one hold at a time).

The 2 queries (2a) and (2b) work fine separately but unfortunately they cannot combine.
Ideally, would like to combine these two to identify orders where one hold has been
released, but where another hold is still applied.
 

Solution

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