Hello All,
Requirement: Hide sensitive data from EBS frontend user.
We have implemented a VPD policy on one of the sensitive columns. it is working fine as expected but when a user logs on to the EBS and query the form and update any column of the VPD enabled table it is updating the VPD policy column to null
For eg: There is a table called CUSTOMER table in the AR module of EBS.
CUSTOMER
NAME
DOB
CREDIT_CARD - VPD policy
ADDRESS
Let's an EBS user login into the EBS frontend and query the form (CUSTOMER). The user will see the null value in CREDIT_CARD column which is expected behavior however if a user updates the ADDRESS column then it is updating the CREDIT_CARD value to null permanently.
I have couple of questions
1) is there any solution or workaround to avoid VPD column being updated when user updates non-VPD columns on the table?
2) is there any alternative tool or solution with in Oracle or EBS to accomplish the customer requirement. I think EBS doesn't support data redaction
3) is there any other tool or solution
4) Any suggestion or method that you know or implemented to accomplish the same.
Thanks in Advance