SQL Developer

Please check below post:

https://apps2fusion.com/oracle-fusion-online-training/165-oracle-articles/2534-purge-person-data-from-test-environments-…

Starting 20A you would need to have some setups on "HCM Data Loader Config Parameters"

Note: Purge Person Diagnostic Test can only be run in Non-Prod Environments.

Kind Regards

Ashish

Thank you Ashish,

I am aware of the Purge Person Diagnostic Test which can only be run in Non-Prod Environments.

However we have this issue in our PROD environment.

What do you mean with: Starting 20A you would need to have some setups on "HCM Data Loader Config Parameters"

Is this enabling HDL to delete assignments?

Thanks

Jeroen

Yes. Some Config to enable Purge Person.

Kind Regards

Ashish

But it only works for Non-Prod Environments right?

Then it is still not working for us.

Thanks anyway

Jeroen

Yes this only works for Non-Prod Environments.

A quick question, which of the following do you intend (in this case):

a) Completely Remove Data From Database (Try DELETE option using HDL)

b) Mask data so that even if visible not much info could be made out of this ( Use ObfuscateWorker Extract.. you would need to tweak some piece. ... worked example on how obfuscateWorker extract works can be found in below link:)

https://apps2fusion.com/oracle-fusion-online-training/165-oracle-articles/2542-anover-1

Hope this helps!

Kind Regards

Ashish

Hi Ashish,

we just need to Purge Assignments with HDL

Just like you are able to do from the front-end in HCM Cloud.

I am raising an SR.

Cheers
Jeroen

Delete is not supported for assignment objects with HDL. However, you can overwrite all but the very first row with by setting PURGE_FUTURE_CHANGES to Y and changing the end date of the the end of time.

helpful hints:

All child objects (assignmentSupervisor, assignmentMeasure, etc) must be deleted first, which you can do with HDL as everything below assignment level supports DELETE

Only works on currently active Work Relationships so if working on terminated workers you need to reverse the termination on the Work Relationship to proceed (theres a flag on WR for that)

Thanks Nick,

Purging all but the first row might indeed be useful in some cases.
However, we have scenarios where we need to change the Effective Start Date of the first row, and this cannot be done unless you recreate the assignment.

Cheers

Support for Oracle HCM Cloud Applications can now be found on https://cloudcustomerconnect.oracle.com/pages/home

Kind Regards

Ashish

I had a similar scenario and deleted WorkRelationship, which deleted Work terms and assignments and reloaded it