Why HDL is not working consistently to unpost pipeline requisitions?
I am facing some issue to push data through HDL
Can anyone tell me why the following HDL file (JobRequisition.dat) is not working consistently? I can see the some requisitions are getting unposted but for some HDL is not working.
METADATA|PostingDetails|RequisitionNumber|ExternalOrInternal|StartDate|EndDate|PostingStatus
MERGE|PostingDetails|205|ORA_EXTERNAL||2024/04/22 00:00:00|ORA_UNPOSTED
MERGE|PostingDetails|205|ORA_INTERNAL||2024/04/22 00:00:00|ORA_UNPOSTED
MERGE|PostingDetails|225|ORA_EXTERNAL||2024/04/22 00:00:00|ORA_UNPOSTED
MERGE|PostingDetails|225|ORA_INTERNAL||2024/04/22 00:00:00|ORA_UNPOSTED
Then I tried with parent information also as below :
METADATA|JobRequisition|RequisitionNumber|CurrentStateCode|CurrentPhaseCode|SubmissionsProcessTemplateId
MERGE|JobRequisition|131|REQUISITION_UNPOSTED|REQUISITION_OPEN|300000009380404
METADATA|PostingDetails|RequisitionNumber|ExternalOrInternal|StartDate|EndDate|PostingStatus