Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.7K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.5K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Purge Assignments with HDL
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
Answers
-
Please check below post:
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