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.
Help getting interview date - BI report for ORC.
Summary:
Hello experts,
Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables.
- I can see this table have the info i need - IRC_IS_INTERVIEWS .But the connector SUBMISSION_ID is only present in the oracle documentation , i cannot see it in our instance , if i try to use it , i get invalid identifier error.
- I have tried going the round about way to connect different tables but with no success.
would appreciate a sample SQL you use to get the interview start date or any other tips to achieve the same.
Tagged:
0