Use-case: Restrict/Hide sensitive data from backend DB & EBS frontend user.
Potential solution: Identified VPD (implement column-level policy) as a potential solution to stop backend (DB) and Frontend (EBS 11i /R12) user viewing/accessing sensitive data
We have implemented a VPD policy on one of the sensitive columns. it is working fine as expected for backend DB user but when a user logs on to the EBS and query the concurrent form and update any non-vpd column of the VPD enabled table, it is updating the VPD column to null on the same table.
For eg: There is a table called CUSTOMER table in the AR module of EBS.
CUSTOMER Table NAME DOB CREDIT_CARD - VPD policy ADDRESS
Let's say an EBS user login into the EBS frontend and query the form (CUSTOMER). The user sees the null value in the CREDIT_CARD column which is expected behavior due to VPD policy however if a user updates the ADDRESS column then it is updating the CREDIT_CARD value to null permanently.
I have the following questions
1) is there any solution or workaround to avoid the VPD column being updated when the user updates the non-VPD columns in the EBS Concurrent form?2) is there an alternative tool or solution within Oracle or EBS to accomplish the customer requirement. I think EBS doesn't support data redaction3) is there any other tool or solution that can enable us to accomplish a solution for our use case4) Any suggestion or method that you know or implemented to accomplish the same.
Thanks in AdvanceRaja
The Oracle Applications & Technology Users Group (OATUG), formerly the Oracle Applications Users Group (OAUG), is the world’s largest education, networking and advocacy forum for Oracle Applications & Technology users.
firstname.lastname@example.org Oracle Applications & Technology Users Group 3525 Piedmont Rd NE Bldg 5, Ste 300 Atlanta, GA 30305-1509 USA (404) 240-0897
Copyright 2020 Oracle Applications & Technology Users Group. | All Rights Reserved. | OATUG PoliciesAll material, files, logos, and trademarks within this site are properties of their respective organizations.