Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Purge Assignments with HDL

Jeroen v MeenenApr 23 2020 — edited Aug 7 2020

Hi guys,

If we try to purge (completely remove all date-effective rows) an Assignment via HDL it errors with:

"You supplied a DELETE instruction for the object component Assignment, which can't be deleted. (HRC-1035622)"

However from the front-end this action is allowed by removing all assignment date-effective rows one by one, starting with the most recent.

We have scenarios where assignments were created with the wrong effective start date, the only way is to purge and recreate the assignment.

Why is not allowed through HDL?

Regards

Jeroen

Comments

AshishHCM

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

Jeroen v Meenen

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

AshishHCM

Yes. Some Config to enable Purge Person.

Kind Regards

Ashish

Jeroen v Meenen

But it only works for Non-Prod Environments right?

Then it is still not working for us.

Thanks anyway

Jeroen

AshishHCM

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

Jeroen v Meenen

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

Nick McHenry-Grobel

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)

Jeroen v Meenen

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

AshishHCM

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

Kind Regards

Ashish

Aslam-HCM

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

1 - 10

Post Details

Added on Apr 23 2020
10 comments
3,254 views