Oracle Recruiting Cloud, part of the Oracle Cloud HCM suite, provides various tables and views for integration, reporting, and data analysis. Accessing these database objects is typically done through Oracle’s provided APIs or direct database access, depending on your permissions and setup.

Common Tables

1. ORC_JOB_POSTINGS – Contains details about job postings
2. ORC_CANDIDATES – Stores candidate information
3. ORC_APPLICATIONS – Manages applications submitted by candidates
4. ORC_INTERVIEWS – Tracks interviews scheduled, conducted, etc.
5. ORC_OFFERS – Contains information about offers made to candidates
6. ORC_USERS – User details who have access to the recruiting module

Common Views

1. VW_JOB_POSTINGS – A view combining multiple tables to provide a comprehensive look at job postings
2. VW_CANDIDATE_PROFILE – A view summarizing candidate profiles
3. VW_APPLICATION_STATUS – Provides the status of various applications
4. VW_INTERVIEW_DETAILS – Detailed interview information, often joining interviewer and candidate data
5. VW_OFFER_DETAILS – Details about offers, including status, candidate, etc.

Access Methods

• REST APIs: Oracle provides RESTful APIs to access these tables and views for integration.
• SQL Queries: If you have direct database access, you can query these tables and views using SQL queries.
• BI Tools: Business Intelligence tools like Oracle BI can also access these tables for creating reports.