Reports
Discussion List
-
Payslip Summary section is not matching main sectionSummary Involuntary deductions is doubling and does not match the summary sectionContent Hi All, Has anyone else had an issue with the Canadian payslip where the Garnish…User_2025-02-04-08-51-08-912 20 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Displaying an uploaded document stored as a blob in a BI Publisher report?Content We have a report request to display attachments that are uploaded by employees in a BI Publisher report. The uploaded attachments are stored as a blob and the ta… -
First "Approved" Position RecordSummary SQLContent Hey guys. I'm trying to extract the first approved record's effective start date of all my active positions. I tried to use this in order to extract t…BenZionP 5 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Combining multiple subject areas but using one as the main data setContent Hi All, As there are certain subject areas only that would contain information needed but also have it's own limitations, I am trying to combine two subject area…Eric.C 52 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Resize a performance tileSummary I would like to arrange about 10 of them next to each other and I need to reduce size of each container.User_2025-02-08-08-49-19-186 33 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report on Scheduled Process (ESS Jobs)Summary Looking for report on Scheduled Process (ESS Jobs)Content Hello, I'm looking for a report on scheduled processes. Does anyone have such report and would like to …Yves Blanc 83 views 6 comments 0 points Most recent by Avinash Potti Reporting and Analytics for HCM -
Reference prior year based on prompt in Narrative reportingContent I have a client requirement where they want to select a year and period and show the comparison with the same period but for the prior year in the second column.…Asad Hussain-190357 64 views 4 comments 1 point Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…s_b 39 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Point in Time Org Chart with open vacanciesContent Hello, Has anyone built a Point in Time Org Chart with open vacancies? Thanks in advance!Dishti Malhotra-Oracle 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 34 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 332 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM