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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
SQL for writing BI to fetch Document Eligibility details
Summary
SQL for writing BI to fetch Document Eligibility detailsContent
Can someone help me with the SQL for the below OTBI query. I want to write a BI report to pull the employee details along with their Performance Document Eligibility.
Basically want to know the table name storing Performance Document Period Name
SELECT "Workforce Performance - Performance Document Eligibility Real Time"."Performance Document Eligibility Details"."Eligibility" s_2,
"Workforce Performance - Performance Document Eligibility Real Time"."Performance Document"."Performance Document Period Name" s_3,
"Workforce Performance - Performance Document Eligibility Real Time"."Worker"."Employee Name" s_5,
FROM "Workforce Performance - Performance Document Eligibility Real Time"
Tagged:
1