Out Of The Box Role-Function Mapping for Read/Write/Access to OFSAA Post Load Changes Screen
(Doc ID 2652365.1)
Last updated on SEPTEMBER 12, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 to 8.0.6 [Release 8.0 to 8]Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Data Integrator (ODI)
Post Load Changes (PLC) previously named Post Load Transformations (PLT)
Data Transformation (DT)
Data Quality (DQ)
Goal
Question 1: On 8.0.x version, below out of box Role-Function mappings were noticed to be present for Read, Write & Access roles. Please help understand what these Functions are used for.
| V_ROLE_CODE | V_FUNCTION_CODE |
| DT_ACCESS | ETLDTQ |
| DT_ACCESS | ETLUSR |
| DT_READ | ETLDTQ |
| DT_READ | ETLUSR |
| DT_WRITE | ETLDTQ |
| DT_WRITE | ETLUSR |
Also confirm if above Roles have access to "Data management framework -> Data management tools -> Post load changes" screen out of box.
Question 2: Since the ETLUSER is described as "The user mapped to this function will be a Data Integrator user", is it still required if "ODI" is not used?
Question 3: Neither ETLDTQ nor ETLUSR are "Read Only" functions (as they provide "Write" privileges), hence they cannot be used to create a "Read Only" user.
Please suggest the functions to be used for obtaining "Read only" access to the PLC screen? Requirement is that user is able to open the DT and view the same, but be unable to modify/save it or create a new one.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |