Hi @Saur2607-Oracle This is an ER and it might be worked in future release But the workaround is to store the 3 letter code in a custom column(city,country etc) and use that to generate the map.

Hi @VenkateshMupparaju Use XDO_SHEET_NAME_? to specify the naming convention for each sheet. Please review the documentation https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#ext_multsheets

HI @Basti Is LBAC enabled in your environment?

Please share the process log file after deploying the DFF

Hi @cvidhya Please add a proper measure column and a common dimension if that did not resolve the issue please share the log file

Hi @RobHeath OTBI inherits the data security from Fusion only. Make sure the user has only one BU access in Manage Data Access for Users. If still user sees the data in OTBI, please grant only BI consumer role and remove the BI Author or BI Admin role access to the user

HI Khalid Aldosari-Oracle Make sure to add measure from both the subject areas and common dimensions

Please review below thread https://community.oracle.com/customerconnect/discussion/665801/query-to-get-report-run-history-in-fusion-hcm

hi @Parag Hiremath are you calling OTBI report from BIP data model? or issue is related to OTBI report?

hi @Aarthi Natarajan-Oracle Please share the logfile, I will review and assist you further Regards, Ravi

Hi @User_H31GM You can review the below sample one select * from EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t FETCH FIRST 100 ROWS ONLY

HI @Sam Bandara Go to report properties and copy the report location from there.

Hi @jmore92 There is no available calendar template.Please review the below document. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/support-calendars-and-time-zones.html#GUID-F8B5ACA1-6054-4028-8AC4-2BC43E12332F

HI @Sam Bandara You can use below method from Catalog service downloadObjectInSession() Method Use downloadObjectInSession() method to download an object from the BI Publisher catalog for a given user.

@Walter Gess please share the logfile of the report

please add a measure column from the subject areas that will resolve this issue

Hi @Tmorris, In custom folders we cannot set System Account as the owner . It will update to System Account only when the upgrade happened to new version.

Hi @bwdata, You can review the Report job history page of the job when you enable bursting, it will show you the details of the success and missing email notifications .

Hi Ilmars K, This Subject area Provides real-time information about the security setup in the application. This subject area is independent of the pillar and can be used to report on roles and details across pillars like HCM, ERP, SCM and so on. Use this subject area to report on role categories, roles, functional security…

Hi Suprit, As per the documentation it supports only GET not the POST method BIP doesn't support HTTP POST method which doesn't return HTTP Status code 200. Here REST method responses with HTTP 202 Accepted status code