PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to pass the SEQ_NBR into a query based user list

edited Sep 16, 2017 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

Does anyone know how to pass the SEQ_NBR to a query based user list in AWE. I set the user list to 'Use user as input' and 'Transaction keys'. Both are checked. The user list source is set to query with the query set to DUR_WF_POCMPBDRQ_PRJ_MGR:

SELECT A.SD_TEXT20_2

  FROM PS_FORM_SD A

  WHERE ( A.SEQ_NBR = :1

     AND A.SD_RECNAME = 'PO_CMPBDRQ')

I see the SEQ_NBR field from the form table in the Transaction Approvals Levels section in the Transaction Registry for the FormApproval process ID.

In the form design, I'm using the approver user list specified above.  However, when I fill out the form and submit for approval it shows there are no approvers found.  I'm not sure if I'm missing a step or if I can't use a query based user list to grab a field (operator_id) off the form for the approver list, filtering for the form name (sd_recname) and the sequence number.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center