Sushanta Chakraborty-Oracle I exactly understand your problem. Try this: FAW: Console>Application Administration>Uploads>Download File>User Group Mapping>Current You will have a zipped CSV file with all Fusion roles by a Username plus FAW Application roles on top. The file is definitely contains all Oracle seeded FAW…

Sumanth V -Oracle, We solved the problem by pulling the Roles (Groups in FAW)/Username mapping from Fusion Security into FAW DW but it's more complicated than querying the DW table directly in one way or another, eg., to use a synonym or custom view. To complete a final task - automatically upload specific Security…

Madasamy, It would help to know the FAW tables containing Group - User mapping, please.

Thanks a lot Mohamed! select_physical * from...PVO... works great.

Krithika, Arjun: The Idea has been filed: Thank you.

The 3-34682251381 SR was created.

Mallikarjuna, Thanks a lot for a quick answer. I guess, opening a SR with a request to add sorting into RPD will work? Getting deeper, if we extended the Subject Area with custom Facts, will be those sorted with the seeded ones? Thanks.

Thanks Krishna. I believe that creating an extract is much heavier than select * from PVO in OTBI/BIP

Thank you Krishna for the response. Yes, we have a data loss on the way from HCM base tables to FAW and trying to query PVO to find out if it returns all data we need.

Vincent, Unfortunately your idea is not doable. When I've created a variable and used the way you intended https://...-@{4}-....oraclecloud.com/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=RequisitionId=@{3} OTBI sent an error: and it's understandable why, it may compromise the security. We can't use the variable…

Thank you Vincent, There's another solution proposed, for Oracle to add in OTBI a new Action Link type (e.g. "Naviate to a Current POD") that's automatically adding current POD root at the beginning of URL for DeepLink usage:…