How to create dependent LOV for ESS Job based on a table in Fusion

As per support note:

How to Use Table Value Set in ESS Parameter's LOV?
Can oracle.apps.fnd.applcore.flex.vst.model.publicView.ValueSetValuePVO be used for table value set?

Solution

If using the oracle.apps.fnd.applcore.flex.vst.model.publicView.ValueSetValuePVO for table value sets , there will not be any return value.

To create an ESS parameter LOV for a table validated value set the table VO must be used directly.

Ex.

Now Lets create an LOV for Check Number

1. Search for this document on google

Rel13_18B_Financials_OTBI_Database_Mapping_with_ViewObjects
( just remove protection from the excel file)

https://cloudcustomerconnect.oracle.com/posts/f53e634ec2

2. This will list VO -> Table -> Column Mapping

3. List down mappings, I found below mappings

This excel contains (VO NAME-> TABLE_NAME -> COLUMN NAME)

VO Definition	Database Table	Database Column
oracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceDistributionPVO	AP_CHECKS_ALL	CHECK_NUMBER
oracle.apps.financials.payables.payments.singlePayments.publicView.analytics.PaidDisbursementSchedulePVO	AP_CHECKS_ALL	CHECK_NUMBER
oracle.apps.financials.payables.payments.singlePayments.publicView.analytics.PaymentHistoryDistributionPVO	AP_CHECKS_ALL	CHECK_NUMBER
oracle.apps.financials.payables.payments.singlePayments.publicView.analytics.DisbursementHeaderPVO	AP_CHECKS_ALL	CHECK_NUMBER
oracle.apps.financials.payables.payments.singlePayments.publicView.analytics.PaidDisbursementSchedulePVO	AP_CHECKS_ALL	CHECK_VOUCHER_NUM
oracle.apps.financials.payables.payments.singlePayments.publicView.analytics.DisbursementHeaderPVO	AP_CHECKS_ALL	CHECK_VOUCHER_NUM
oracle.apps.financials.payables.payments.singlePayments.publicView.analytics.PaymentHistoryDistributionPVO	AP_CHECKS_ALL	CHECK_VOUCHER_NUM

4. Create Table based LOV in Manage List of Value Sources:

Find by class path:

List of Values Source Definition Name Start with FscmTopModelAM.FinApPmtSinglePaymentsAM.DisbursementHeaderPVO

Define ESS Program

Logout and login, this will create dependent LOV .