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

Help getting interview date - BI report for ORC.

Accepted answer


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.

Howdy, Stranger!

Log In

To view full details, sign in.


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