You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ESS JOB User defined list of value with multiple displayed fields

Summary:

Creating a parameter for a custom ESS Job with a custom list of value .

Content (please ensure you mask any confidential information):

In Oracle Fusion I've created a ESS Job for a custom OTBI Report; in the report I have a parameter Buyer, to show the list of all buyers.

When I run the report in Scheduled Process, I'd like to show the full name of the buyer but to pass person_id to the report.

I've created a user defined list of value source:

whit FULL_NAME and PERSON_ID in the select

I’ve attached the list of value to the Buyer parameter in this way:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!