Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
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… -
Employee/Manager Self-ServiceSummary How to report on effectiveness of ESS/MSSContent Hi all - checking in to see if any of you currently have a report that reports on the effectiveness of employee … -
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… -
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… -
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…
-
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… -
Time Cards - Calculated Time breakdownContent Hello We have a reporting requirement to show the calculated time breakdown by Type. Is it possible to bring this data in a OTBI report? In which folder do we ha…
-
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… -
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… -
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…
-
OTBI query: extract Withdrawal Reason, Data and CommentContent Hello, In the Learning subject area I cannot find the following info to extract: Withdrawn Date, Withdrawal Reason and Withdrawal Comment. Are they available? Wh… -
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? -
Limit Datepicker in OTBI parametersSummary Datepicker to limit the user to select only dates from past till today and not any future datesContent Can we limit OTBI Parameter Datepicker to show dates only … -
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 …
-
Need help on OTBISummary Sum of Balances in OTBI reportContent Hi Team, We are creating one report. Our requirement is to print the balance value in such a way that balance value of A an…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Retrieving Historical Data on all fields in Worker Assignment Real TimeContent I have built a report a report pulling fields from worker and department and have entered SET VARIABLE PARM_EFFECTIVE_DATE = '@{report_Date}{@{system.currentTime…
-
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… -
Date Filter with Default value FailsContent I am new to OTBI and have tried to follow the various posts etc. about creating a report with a filter on the criteria and have used a presentation variable. How…
-
OTBI division operator in calculated column formula is not producing correct results - in RecruitingSummary The division operator in a calculated formula is not producing correct results in the Recruiting - Recruiting Events Real Time subject area.Content In OTBI, when… -
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 …
-
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/…
-
report out on offer letter templateSummary How can we report out on which offer letter template was selected for a candidate