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

HCM Extracts : How to specify dynamic date in HCM Extracts Schedule

It is very rare that the HCM Extracts would be developed to be run on ad-hoc basis.
Most of the times the extracts are scheduled on a periodic basis.

Saying so, we might need to pass dynamic value for its parameters for ex: effective date. ( in place of SYSDATE which is by default )

Lets say we want the extract to run with date range of 15 days in future. ( i.e EffectiveDate is SYSDATE+15 )

To achieve this, we need to go to Data Exchange ==> HCM Extracts ==> Refine Extracts ==>
Search for the extract and click on edit.

Select the Effective Date parameter and click on edit. Enter below values :
a. Parameter Basis : Post SQL Bind
b. Basis Value : select sysdate+15 from dual
c. Save and then Submit.
 

Bingo, now whenever the extract runs the effective date would be Todays date + 15.

Thanks for reading,
Srikanth