Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
PAY: Scrambling payroll data while preserving tie-back capabilities
We're looking to scramble payroll-related data in our non-production instances. While it seems straight forward, the issue we have is maintaining functionality of the fast formulas, as well as the timesheet data.
We have a basic SQL script that will scramble the numeric data in the PAY_ELEMENT_ENTRY_VALUES_F.CREEN_ENTRY_VALUE and PAY_RUN_RESULT_VALUES.RESULT_VALUE columns, as well as the data in the PAY_PRE_PAYMENTS.VALUE and PAY_COSTS.COSTED_VALUE columns. However, that breaks the ability to do drilldowns between payments and GL related to the payroll data.
Looking at Oracle's data scrambling and data masking offerings, we can see that even they note that while the data will be obscureed, the relationships are lost during the ananomysint process.