Introduction
In one of the previous example (link here ) we have learnt how to “ Load Data into Oracle HCM Cloud Using Inbound Interface Delivery Option”.
In this post we will try to learn about “ObfuscateSwedishWorkerAutomated” which is a delivered Inbound Interface HCM Extract in Oracle Fusion HCM Cloud Application.
We can navigate to Navigator->My Client Groups->Data Exchange->Manage Extract Definitions and then add filter value as “Inbound Interface” under type and it will display all available inbound interface available in the environment.
The purpose of this interface is to completely obfuscate (mask) worker related data from the system for all the workers who have been terminated 7 years of before the system date.
We will see that this extract has a parameter “Load Automatically”
The delivered interface has the following filter criteria
We could clearly see that there is a Extract Delivery Option defined details of the same are as follows:
Now we will try to run the “HCM Extract” with “Load Äutomatically” parameter as ‘N’and check results
We see that there is no Data file generated in this case ( We could not find a Extract Delivery as Worker here) and this may be because of the filter condition.
We will change the filter condition now to below value:
We will re-run the “HCM Extract” again
We will now check the results:
And when we open the data file we can see the data records:
From the above example we can clearly see that there is a record having person number as 553 (personid 300000049094876”)
Now we will check for the person record first and verify whether the details are visible in UI
Next we will try to modify the HCM Extract Data Group Filter Criteria (add condition that it should only fetch record for personid 300000049094876)
Now we will run the “HCM Extract” with “Load Automatically” as “Y”
And now when we check in person management we can see that the details for Person# 553 is masked
Summary
So this is how one can mask sensitive data , while this delivered extract has specific filter criteria to choose employees who got terminated 7 years (84 months) or earlier and only applicable for Sweden legislation but this could be applied to other legislations too and with a different termination date.
And with this , I have come to an end of this article, hope this was a good read.