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
-
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
-
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… -
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…
-
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… -
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…
-
Line Manager DashboardSummary Line Manager prompt - Connect by in Logical SQL?Content Hi Team, I've added a Line Manager prompt in our custom version of Line Manager Dashboard. Because some o… -
List of Report for Onboarding ChecklistContent Hi All, Can anyone share a post of link in which we can get List of Report for Onboarding Checklist. Any kind of reports will help. Thanks & Regards, Kiran Versi…
-
"Insufficient Privileges" in Fusion CloudContent Hi All, We have a requirement to find the approver name of a particular transaction. I did some research and found that may be we can get relevant data in hcm_fu…
-
FTE by Actual Hours WorkedContent Hi All, I need a report that shows FTE per cost center by actual hours worked (in time card) instead of FTE based on scheduled hours. Have any ideas on how to be…
-
Recruiting - Recruiting Real Time - Ability to Report on Position Details?Summary Currently you cannot report on all position attributes in ORC like FTE, having difficulty with joining subject areas.Content We are trying to report on FTE for O… -
migrate data model from test instance to productionContent Dear Members, I have accidentally deleted a data model of a report from production instance. Thankfully, our Test instance still has that data model as is and un…
-
Agent Failure NotificationSummary Would like to have a notification sent to our HRIS group when Agents fail without sending the reportContent We are looking for a way to have agents send a notifi…
-
Transaction Administration through multiple languagesSummary Process Name and Process Category are challenging in multiple languagesContent Hello Everyone, I've been pushing to create useful reporting on the goal setting p… -
Role Change Reflect to AnalyticsSummary When you change roles in Fusion, does it also get changed at the same time in Analytics?Content We encounter scenarios where we cannot see a report and then we a…