Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Table Value set to fetch the data from User defined table

We are looking to create table Value set to fetch the information from User Defined Table but that is not working properly:

Below is the value set I have created but that the DFF is showing blank value

FROM Clause: ff_user_column_instances_f fucif, ff_user_columns fuc, ff_user_rows_f furf, ff_user_tables fut

*Value Column Name: substr(fucif.value,1,80)

Value Column Type VARCHAR2

Value Column Length 80

Description Column Name substr(fucif.value,1,80)

Description Column Type VARCHAR2

Description Column Length 80

ID Column Name substr(fucif.value,1,80)

ID Column TypeVARCHAR2

ID Column Length 80

Enabled Flag Column Name

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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