PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Pagelet with Prompts Issue

edited Feb 4, 2016 4:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 9 commentsAnswered
I have a user who writes a lot of queries and uses them as pagelets.  She has done several that include prompts in the queries.  She sets a default value in the prompt, and the user(s) can use the pencil to edit it and change the values.  No problem.

Her latest one needs to prompt against the PS_JOBCODE_TBL, which appears to be the first itme she's had one that needed to specify a SETID value.  Once we got the query working (you have to be sure to prompt the user for the SETID first, then the JOBCODE value) the query works great.  But when she puts it into a pagelet, it doesn't work.  She specified default values for both SETID and JOBCODE and it works for those, but when you use the pencil to change the values, it won't show any JOBCODE values.  Basically, it's like the prompt for

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