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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here
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.

DFF Initial Default using SQL

Summary:

Descriptive Flexfield Configuration provides a Initial Default setup (DFF Segment > Initial Default > Default Type = SQL) which allows to enter a SQL which can query the tables and get the needed data.

Position DFF segment needs to be defaulted by querying data from tables to dynamically populate data form Oracle HCM and ERP tables.
But as per Oracle Support Document - Fusion Global HR: Initial Default of type SQL on a Segment does not Default on Redwood UI (Doc ID 3056052.1) - There isn't support for defaulting via SQL in Redwood UI. For Redwood UI, the defaulting is supported using business rules only.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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