What to do if HCM Extract definition is not editable : Rel 13 18C / 18D

If you are suddenly seeing that you are not able to edit the HCM Extract definition, which you were able to edit earlier, then there is a new feature from 18C/18D patch bundle that is causing it.

The extract would be in read only format as shown below :

The solution for this is to open the extract and uncheck the "Lock Definition" and provide the comments.

Once the extract is saved, the extract would become editable again.

Thanks,
Srikanth

HCM Extracts : How to find ESS job id for a scheduled extract to be cancelled

Hi ,

Many times we may not find the exact ESS job to be cancelled, when we want to cancel an already scheduled extract.

In that case we can use below SQL to identify the ESS job ID. Here we just need to key in the extract run name which we have entered while scheduling the extract :


select pfi1.INSTANCE_NAME , pfi1.flow_instance_id , essrh1.requestid  from
pay_flow_instances pfi1 ,
pay_requests pr1,
ess_request_history essrh1
where pfi1.INSTANCE_NAME like '<Extract Run Name>'
and pfi1.flow_instance_id = pr1.flow_instance_id
and pr1.call_id = essrh1.requestid

Hope this helps.

Thanks,
Srikanth