Creating a Universal Work Queue Custom Node in Oracle Applications (Doc ID 1122776.1)

Last updated on MAY 25, 2022

Applies to:

Oracle Universal Work Queue - Version 11.5.10 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Goal

The purpose of this note is to provide steps to create a simple custom '3 tier' node hierarchy in the Universal Work Queue, similar to the "My Groups" node.

e.g.
Node Level1
--> Node Level2
------> Group1

This note covers :

Introduction
Define Custom Lookups
Define Custom Views
Create Spreadtable Metadata Definitions
Define UWQ Work Provider
Create SQL for Node Enumerator and Refresh
Enable New Nodes for User
Testing
Troubleshooting

Note : The following note should be used for reference purposes only.
The structure of the work list and the underlying pl/sql views and procedures are for demonstration purposes only and are not supported by Oracle.