Skip to Main Content

Analytics Software

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!

Discoverer Version - 11.1.1.7.0 with 19c Database and EBS 12.2.8

user12236222Jun 11 2020 — edited Jul 18 2020

We are currently on Discoverer Version - 11.1.1.7.0 and we are using this (in Sustaining support mode) on Oracle Database 12c and Oracle EBS 12.1.3. We are planning to upgrade our Database and EBS versions to 19c and EBS R12.2.8 sometime later this year. We would like to know if this will work or there are known issues that this will fail. as per Document ID 2674063.1 : Oracle Discoverer 11.1.1.7.0 Certification With EBS R12.2, Discoverer 11.1.1.7.0 is certified and supported with EBS R12.2.8 . Please suggest.

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