Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
sql to fetch organizations or departments based on business unit
Hi Team,
We are trying to write sql to fetch all organization or departments for a business unit. But we dont know how to link organizations to business unit. To tell you the purpose of this, we have requirement to build two prompts in a BIP report - one for BU and other for Organization. When user inputs/selects a BU value in BU prompt, Organization prompt should show only organizations which are linked to BU selected in BU prompt.
Table HR_ALL_ORGANIZATION_UNITS_F does not have business unit field. We dont know how to establish a connection between BU and organization. We need to write sql. We cant use OTBI/subject area. Please help us in this asap.
0