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
41
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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