Reports
Discussion List
-
View Report Based On Legislative Data GroupSummary View BI Report Output Based On LDGContent Hi All, We have custom BI report which is using seeded data model to query. We would like to view report data based on …Ganesh Kokkula 32 views 2 comments 0 points Most recent by Ganesh Kokkula Reporting and Analytics for HCM -
MR Report with Print all selections cannot be used in reference docletContent When a MR report is having a dimension in the POV and print all selections is enabled, the reference doclet is not being created. Please provide if there are any…Sandeep Hardikar N S 17 views 4 comments 0 points Most recent by Sandeep Hardikar N S Narrative Reporting -
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…User_2025-02-07-19-03-14-525 61 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.User_2025-02-05-23-02-10-916 62 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Balance Report for CanadaSummary This BIP report renders all dimensions associated to the reported balance and their values (RUN, MTD,QTD, YTD, etc.). Content Data model is based on the query pr… -
Intermittent Service Errors when editing reportsSummary Users receive service errors periodically when editing a reportContent After the December patch our users started getting errors periodically when trying to edit… -
Find courses not completed in a specializationContent Hello, I have created an OTBI report for our specializations in learn, but I cannot get the report to show which courses are still outstanding. In the screen sho…User_2025-02-06-11-18-47-896 48 views 2 comments 2 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM -
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :…User_I6AXL 49 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Direct vs In-direct suppliersContent All - How to identify in Oracle Procurement cloud the direct vs in-direct suppliers? Also is there a field in OTBI that can tell direct vs Direct suppliers? I se…Hari Thyagaraj 33 views 6 comments 0 points Most recent by User_2025-02-06-05-37-11-922 Reporting and Analytics for ERP -
Selection Steps/Filters per table in one reportContent Hi all, I'm wondering if it's possible to put different filters or selection steps per table, but within one report. I'm making some headcount reports and want t…User_2025-01-31-00-25-12-234 23 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Cross-Subject Area Report with 'Security - Roles and Privileges Real Time'Content We are in search of a report that would require a cross-subject area analysis using Worker Assignment Real Time and Security Roles and Privileges Real Time. I am…User_2025-02-08-03-57-26-191 57 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
schedule a OTBI Report when data is thereContent Hi, I want scheduler to run only when report has data. I have developed OTBI Report. Can you please tell me how I can do it in BI and OTBI. Thanks, VijayUser_2025-02-07-19-03-14-525 23 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Business Unit Headcount vs recognitionContent I am trying to create a pivot table to show headcount of business unit against our recognition values which employees have been awarded. So I can clearerly see a…User_2025-02-06-11-18-47-896 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Suppression is not working for Formula and Text Row in HFRContent Hello All, In HFR have enabled the basic suppression option but it is surprising only data rows, not a formula and text row which I have used for Header purpose.… -
Report with null data between tablesContent Hello experts I've managed to make an interaction between 2 tables in OTBI DataModel. Then I need to create a report. The problem is the report does not show the…Pedro Teixeira 14 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Summary Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Content Hi, We have a requirement were we need to hide a Performance Ti… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 334 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Reporting on reversed terminationsContent Hi all, I have searched on this topic but have not found a working example of this report or confirmation that it can be done. Can anyone advise whether it is po… -
Maximun Threshold Values for FR (PBCS)Summary The report is not opening with multiple members and with Expand All Functionality.Content Hello, We have created one report and it is not opening when the client… -
Substring Function in FRSContent Is it possible to use a Substring function in FRS reports? We have a requirement to Substring the Cost Centre values on one of our reports so I was just wonderin…User_2025-02-05-23-02-10-916 32 views 1 comment 0 points Most recent by Naveen Gowda Reporting and Analytics for ERP -
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…Jaswant Prajapati 379 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…User_2025-01-25-04-02-13-126 324 views 24 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Unable to access reports and analytics after userid changes in OTBISummary User no longer is able to access reports and analytics. Receives error 'Unable to reconnect (after 3 tries) to BI Presentation Server using the connection Id =BI… -
Unable to Combine 2 Subject Areas throws error.Summary I am trying to combine Compensation salary history and payroll element history Subject area it throws me error. If someone can help out or would appreciate if th…User_2025-02-07-09-10-02-492 53 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Field School Empty in Subject Area “Workforce Profiles – Person Profile Real Time”Content Hello All, We have created the following report “Report Degree” which uses the subject area “Workforce Profiles – Person Profile Real Time” and the following col…Bernard T 66 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…Kathleen Nguyen 26 views 8 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM -
Non Prod Last refresh (P2T) dateSummary Non Prod Last refresh (P2T) dateContent Hello All, Is there any way we can find the Non Prod environment last refresh (P2T) date by using a query/table or profil…