My Oracle Support Banner

Job Requisition Template HDL when updating existing object record error You cant create the job requisition template in state StateId cannot be NULL. (IRC-1590201). (Doc ID 2744287.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Recruiting Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.10.0 version, Data Load

When attempting to update an existing Job Requisition Template using Surrogate Keys via HDL/HSDL, the following error occurs.

ERROR
-----------------------
An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: You cant create the job requisition template in state StateId cannot be NULL. (IRC-1590201).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run BIP Reports to extract data for existing Job Requisition Template records
2. Ensure that user has the required Recruiter, Recruiting Manager and Recruiting Administrator Job Roles to update Job Requisition Templates
3. Run the HCM WS Jobs Data Common Diagnostic Test - Report & HCM WS Jobs Data Common Diagnostic Test - Correct reports, no issues with existing Jobs
4. Load the attached JobRequisitionTemplate.dat HDL file to update existing records
5. Encounter error message above

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.