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

What is the syntax to refer project_id in the Project DFF setup

Accepted answer


When setting up Project Descriptive Flexfield we need to automatically populate one of the DFF segments with value from HR organization setup. In the DFF segment setup we are planning to use initial value sql to get the Hr_organization_v.attribute1.


select org.attribute1 from hr_organization_v org, pjf_projects_all prj where prj.carrying_out_organization_id = org.organization_id and prj.project_id = syntax for project_id on the project overview page.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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