MFA Icon

MFA for Oracle Community

Starting September 2025, Oracle Community will require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account—and the community data—by adding an additional layer of security during sign-in.

Read more about MFA
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
Reporting and Analytics for ERP

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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