My Oracle Support Banner

Out Of The Box Role-Function Mapping for Read/Write/Access to OFSAA Post Load Changes Screen (Doc ID 2652365.1)

Last updated on MARCH 31, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 to 8.0.9 [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.

Role-Function mapping
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.