Recruiting: Error when running process 'ESS job'

Summary:

Hello,

I'm having an issue when running the ESS job to create index definition and perform initial ingest to OSCS.

The parameter used is 'fa-hcm-requisition'. The process is failing each time.

Below is the log:

####[2024-08-13T06:26:37.649+00:00] [INFO] FndOSCSIndexIngestESS execution log
Entering execute of FndOSCSIndexIngestJob job
Fetching the parameter: CALLER: null
Fetching parameters: isP2TJob
Fetching parameters: Index Name for recreate
Parameters
indexName :::: fa-hcm-requisition
Only performing recreate for index - fa-hcm-requisition
ESS job FndOSCSIndexIngestJob failed with errorError while connecting to elastic: statusCode: 500 response: {"createIndex::fa-hcm-requisition-fnd-zdt":{"createIndex::fa-hcm-requisition-v7":{"acknowledged":true,"shards_acknowledged":true,"index":"fa-hcm-requisition-v7"},"status":0,"createAlias::fa-hcm-requisition-fnd-zdt":{"acknowledged":true}},"status":500,"initialIngest::fa-hcm-requisition-fnd-zdt":{"status":500,"message":"failure : java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00904: "PROSPECT_COUNT": invalid identifier\n","errors":[],"messages":["Processing Initial Ingestion for index : fa-hcm-requisition-fnd-zdt","Initial process state : {"ingestStartTime":"2024-08-13 06:26:36.837"}","Total number of rows processed in the current run 0"]}}