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.
Published Job Requisition and External Career Site SQL
Summary:
I am looking for Table(s)/SQL that link the Job Requisition posted and External Career Site configured.
Content (required):
I am currently facing issue to create a report that links the job requisition posted and new active external career site.
I am using below tables :
IRC_REQUISITIONS_B
IRC_PUBLISHED_JOBS
IRC_CX_SITES_B
While the default 'CX' career site is deactivated, IRC_PUBLISHED_JOBS still has only this site_id.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Code snippet used in the Query:
0