Hi All, We are supposed to achieve this Direct Database Query option in two steps, From analytics level, we have to set a privilege to the Non-Admin user using Manage Privileges option. We have to enable the Direct Database Query option in RPD. Since we don't have access to RPD it is not possible to achieve. And also based…

Hi , PFA , This is the way to create direct db query. Regards, Vijay S

Hi , I think you are used filter in the report in the selection. Maximum limit is 300 , if it exceed it result in this error. Regards, Vijiay S

Hi , You can create direct db query by using Data model and create a report. New >> Data Model Regards, Vijay S

FYI 

Hi All, For HCM , its successful module . When it goes for SCM we cant use multiple subject area for all the Scenario. In such case you have to go for the SET OPERATORS(UNION, UNION ALL). So that you can create OTBI report using multiple subject area. Regards, Vijay Subramani

Hi Giuseppe, You can use the Data Sync Tool to get your requirement.\ Regards, Vijay S

Hi, You will find the R12_ERP_SCM_OTBI_Database_Mapping Excel in the Oracle site , it will be very useful to find the Subject Area , Presentation column , Database column and even Table name Regards, Vijay S