PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Form and Approval Builder - Lookups with Prompt

Using 8.58.10, 9.2 FS and HR

In many cases PeopleSoft stores a unique ID for a lookup value along with a text description. For example the LOCATION_TBL in HR has an ID for each location (behind the scenes) and then text that the user sees in a drop down as a prompt table).

In Form and Approval Builder is there any way to get that functionality? When I reference the key column of LOCATION_TBL for example, it shows that internal ID on the screen, not the text (long description) that the user would see from the prompt.

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