SAP Knowledge Base Article - Public

3772819 - "Failed to retrieve result with given criteria" error when using Job Requisition's Internal Status as filter in Integration Center - Recruiting Management

Symptom

Error occurs when filtering Job Requisition records by Internal Status in Integration Center:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1. Create an Integration Center job from JobRequisition entity
  2. Choose the needed fields including Internal Status (internalStatus)
  3. Go to "Configure Fields" section and notice data populated accordingly
  4. Go to "Filter and Sort" and add Internal Status as filter (for example, set it to "Pre-Approved", "Approved", or "Closed")
  5. Return to "Configure Fields" section
  6. The error occurs

Cause

The error is expected when label is used for Internal Status filter instead of numerical value.

Resolution

Use the mapped numerical values for Job Requisition's internal statuses when using Internal Status field as filter in Integration Center reports.

The table below lists the numerical values that are mapped to the different internal statuses of Job Requisition:

Numerical ValueMapped To
0Pre-approved internal status of a job requisition
1Approved internal status of a job requisition
2Closed internal status of a job requisition

Example: Instead of using "Closed", use the numerical value "2"

See Also

Keywords

integration center, jobrequisition, internal status, filter criteria error, failed to retrieve result with given criteria, COE0019, COE_GENERAL_SERVER_FAILURE, status code 500, internal server error , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem

Product

SAP SuccessFactors Recruiting all versions