Reports
Discussion List
-
Current status is "Interim"Summary Trying to report on all employees who are an interim assignmentContent I'm trying to report on all employees who are currently on an "Interim". Using the HR Acti… -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 22 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM -
Nee a delivered report path that triggers approval notification email for time and labor module.Summary Nee a delivered report path that triggers approval notification email for time and labor module.User_2025-02-04-07-00-18-658 23 views 7 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
List of all Scheduled BIP ReportsSummary List of all Scheduled BIP ReportsContent Hi Team Is it possible to extract the list of all scheduled BIP reports along with owner and schedule frequency? Which t…Karthik K-Oracle 129 views 6 comments 3 points Most recent by User_KM4LK Reporting and Analytics for HCM -
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …Bernard T 16 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Bursting to SNOW - Postmaster issueSummary Emails are being blockedContent Hi Team, I've implemented a report to burst an emailt to ServiceNow Inbox with copy to my own email (Dev environment). I am getti…Alvaro Couto 37 views 6 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Help Building HCM Group Membership ReportSummary I need to build a report that pulls all employees HCM Group membershipContent It doesn't seem that there is an easy way to find out what HCM Groups an employee i…David Rabalais 122 views 1 comment 2 points Most recent by David Rabalais Reporting and Analytics for HCM -
Report on BI Publisher Bursting RecipientsSummary Extracting details of bursted email recipients over set periodContent Hello, We have a nightly bursted email report inviting employees leaving our business to co…RebeccaAult1799 49 views 4 comments 9 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
BIP | SQL query to get details of the employees belonging to departments below the selected departmContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging… -
Report on employee careers of interestContent Hi, Has anyone built a report that indicates people and their careers of interest under career development in Oracle HCM Cloud? I am specifically looking to buil…Dishti Malhotra-Oracle 32 views 2 comments 0 points Most recent by Krista Kay Reporting and Analytics for HCM -
Can we update a column after BI report bursting for person levelSummary Can we update a column after BI report bursting for person levelContent Hi , We have a requirement in compensation module to avoid the letter bursting multiple t…User_MC37Q 42 views 2 comments 0 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
BI report to extract time informationSummary Any pre build BI report to extract time information available?Content Hello anyone has any prebuild report to read Time information? Thanks, Nicola -
Bursting HistorySummary Need to find the table for bursting report hisotryContent Hi Guys, I found a table for BIP Bursting report history but seem that the only usable column is the US…User_2025-02-05-11-53-59-507 72 views 9 comments 2 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
Missing Salary Report on OTBIContent Hi all. I'm trying to build a simple report on OTBI that reports the employees who are missing salary at the current date. I tried to use both Compensation - sal…BenZionP 83 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
when using HTML2FO function to convert HTML enabled text in rtf template output is not coming with tSummary when using HTML2FO function to convert HTML enabled text in rtf template output is not coming with the font and size defined in RTF templateContent Hi All, In a … -
Pulling DFFs in to Analysis ReportsContent Hi, I'm relatively new to reporting - How can I pull DFFs in to OTBI Analysis Reports? * DFF fields in the employee's assignment record - are these listed in a s…Stephanie Jung 46 views 8 comments 3 points Most recent by Sumit Upadhyaya Reporting and Analytics for HCM -
Is there a way to round-off numbers and truncate dates in simple XML outputs?Content hi. I can't seem to find a way to round-off numbers and truncate dates for simple XML hcm extract outputs. Is it possible?notautomni9 22 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for HCM -
Accrual Balance Report is showing double the actual valueSummary Accrual Report is showing the balance as double what it should beContent Hi, I have created a accrual balance report in OTBI using the Accrual Real Time subject … -
Date fields using excel templatesContent Is there a way to print date fields on excel based BI publisher reports where excel can recognize it as an actual date field? Is this the only solution https://d…User_2025-02-10-08-27-16-805 28 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Using .xlsx template instead of .xlsContent Is there a way to load .xlsx file as a template instead of .xls file? I am trying to create a BI publisher report with slicers and I run into compatability issue…User_2025-02-10-08-27-16-805 44 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Active employees that have a zero net paymentSummary Looking for an analysis/report that shows active employees that received a zero net payment for a pay periodContent Hello, I am looking for a report/analysis tha…User_2025-01-31-02-45-52-854 48 views 3 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM -
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering…Mani Venkataraman 1.1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Reporting on the positions colleagues are working in (factoring in secondments)Content Im looking to report through OTBI on where colleagues are currently working, factoring in secondments. For example I only want 1 row to appear for each colleague…MattW 36 views 9 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
How t get inactive employees less than 500 net payment from "Payroll-Payroll balances real time subSummary Ho t Pulling inactive employees from"Payroll-Payroll balances real time subject area" .Content Hello Gurus, I am trying to pull all employee including terminated…Manju01 74 views 20 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM -
Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going …User_2025-02-04-08-51-08-912 107 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM -
Custom Performance Document TemplateSummary Changing the fonts in Performance Document templateContent Hi, Has anyone successfully customized the RTF in template in: Path: /Human Capital Management/Career/…Janine Dorongon 29 views 2 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
report out on offer letter templateSummary How can we report out on which offer letter template was selected for a candidateRiti Malhotra 29 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Report for Share and Retain and Share and ReleaseSummary Report for Share and Retain and Share and ReleaseContent Is there anyway we can report off of Share and Retain and Share and Release from performance document Is…Reddykrishna Chidella-Oracle 32 views 2 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pull Succession Plan Name with Talent Profiles.Content I have created a report to pull latest Performance, Potential, Risk of Loss And Impact of Loss from Talent Profiles. Is there a way to add Succession Plan name t…User_2025-02-10-08-27-16-805 27 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Change Font of Delivered Performance Management ReportSummary Change Font of delivered - Performance Document Worker And Manager Ratings ReportContent Hello Experts, I am planning to change font (to Arial) for the delivered…Anil Pillaresetty 37 views 9 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM