Reports
Discussion List
-
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the… -
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 60 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …Arti P 31 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…Scott Paulin 11 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would…Revital Mefano 22 views 2 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…Anton Rzhanov 72 views 8 comments 0 points Most recent by Anton Rzhanov Reporting and Analytics for HCM
-
EEO and VETS Reporting Set upSummary: Hi All, I am trying to run the delivered EEO and VETS reports from My Client Groups> Payroll> Submit a Flow area . But nothing is appearing in the LE dropdown a…Gaurav Rath- PGC 22 views 3 comments 0 points Most recent by Gaurav Rath- PGC Reporting and Analytics for HCM -
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 73 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Using Session Variable can be used in BIP report to restrict data based on the user who will run it?Summary: Is Using Session Variable can be used in BIP report to restrict data based on the user who will run it? Content (required): Hello, I am running a BIP report reg…Hazel De Castro 38 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need a BI Publisher Add-In Supported by MS Office 365Summary Need a BI Publisher Add-In Supported by MS Office 365Content Hi, We need a BI Publisher Add-In Supported by MS Office 365. Please provide a link to download the … -
BI publisher not workingSummary Unable to use BI publisher in ExcelContent Hi folks! I need to modify a Excel Template for a Oracle Cloud report. It seems that my BI publisher is not working pr…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…Anjan Polimera 12 views 1 comment 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 72 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…User_2025-02-10-16-28-01-402 49 views 4 comments 1 point Most recent by Karen Long Reporting and Analytics for HCM -
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 45 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM
-
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 478 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Is there a UE that can fetch LE details including LE addressSummary: Requirement is to get all active LEs and their respective address along with Bank Details for the UE. Content (required): I tried using the below UE but it does…Vibha Pandey - Oracle 11 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
Source System ID for Work TermsSummary: Sample Query to extract SSID for Worker.dat >>>> Work Terms object upload Content (required): We have a requirement to extract SSID of work Terms object for Wor…Dhajani Perera 568 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Best practices on how to combine HR data from other non Oracle applications with Oracle CloudSummary: I would like to know how other customers have linked data from other applications to their Oracle cloud solution. we have OAC and use ADW as a data source and a…Robert Geddes 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
Converting UTC to EST time zone in Logical SQLSummary: Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax. Cont…Denise Izzi 2.5K views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 31 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM