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
-
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis… -
Performance tile to show a 0 instead of no resultsContent Is it possible for a performance tile to show as a '0' if there are null counts instead of it showing a message saying 'no results' -
Dashboards - ObseleteSummary Dashboard - ObseleteContent Hi, Just want to know the Dashboards going to be obsolete in coming versions and Infolets will take precedence. Regards/Prasanth Vers…
-
Query Data Model securitySummary Example of query or config to allow data models be displayed to all employees without them seeing whole company data.Content Hello all When a more robust report … -
D&I reporting - what works for your organisation?Summary D&I reporting - what works for your organisation?Content Hello all - over the years I've helped lots of customers with many diversity reports, but the world is m… -
how we can use gif in flash template through bi publisherSummary how we can use gif in flash template through bi publisherContent how we can use gif in flash template through bi publisher -
Dashboard promptsSummary Creating a dashboard prompt using a formula based columnContent Hi We are using below formula to show the actual "Start date" of employees in the reports. IFNULL…
-
OTBI: Multi Tab Excel Downloadable OTBISummary OTBI: Multi Tab Excel Downloadable OTBIContent Hi All, We have a requirement of creating a single OTBI analysis with multiple layouts. Each Layout should have a … -
Report on 'Ad Hoc' feedbackContent The business has decided they want the option to give feedback without the one receiving the feedback being able to see it (don't ask me why). We've advised the … -
Preferred Browser for OracleSummary I would like to know what is the preferred browser to use for Oracle applications. Can you provide documentations?
-
OTBI: how to achieve UNION ALL operation in OTBISummary OTBI: how to achieve UNION ALL operation in OTBIContent Hi, We need to replicate BIP's UNION ALL operation in OTBI Is it possible? Regards Rashmi
-
OTBI Environment variablesSummary Display current user details in environmentContent Hi, Has anyone come across any OTBI environment variables. Or is there a subject area that displays the curren…User_2025-02-05-23-02-10-916 90 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all… -
Function for getting leave balance prior to execution of monthly leave accrualSummary Function for getting leave balance prior to execution of monthly leave accrualContent Hi, Please share function name or logic in order to get the leave balance o… -
Rehire Date as a PRESENTATION_COLUMNSummary Rehire Date as a PRESENTATION_COLUMNContent Hi All, My business user complains to me that Rehire date is not a presentation column and is not as easy as adding a… -
BI report Name change and path changeSummary Impact AnalysisContent Team, We have a request to change report name and path of few reports . These reports are scheduled already. Just wanted to know what woul…
-
Payroll Balance Duplicating with Multiple AssignmentsContent Hi, I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in so…
-
Reports got failed when scheduled in DEV3 completed in DEV2Summary Reports got failed when scheduled in DEV3 completed in DEV2Content Some of our reports got failed when scheduled in DEV3. On analysis we could see that the Data …
-
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… -
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo… -
Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla versSummary OTBI Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla version as old value and new value as custom expression lang… -
Reporting on Rejected DORSummary Requirement to report on rejected DORContent Some of the DORs in our system pass through the Approval cycle. I have checked "Workforce Management - Documents of …
-
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766
-
Trying to embed a dashboard on shared My Team PagesSummary Trying to embed a dashboard on shared My Team PagesContent On the Manage my team absence balance page (We have renamed this to Time Off Balances) I have embedded…
-
(Under Oracle Review) Data Dictionary for ReportsSummary Create Data Dictionary for ReportsContent We want to have a data dictionary of our reports created Can this be pulled via SQL. 1. Path 2. Report Name 3. Report D…
-
Generate barcode in PDF outputContent Hello, I am trying to generate the bar code in a RTF template with an output as PDF. When I use the output as HTML or any other the bar code is printed correctly… -
OTBI: Report with more than 50,000 rowsSummary New customer joining with large number of employees - more rows requiredContent HI all, We currently use many OTBI reports for our standard reports. However, we …
-
Tables for Worker Time Processing profiles in HCMSummary Tables for Worker Time Processing profiles in HCMContent Hi Team, I am looking for a query to find Worker time processing profiles(HCM Groups) based on assignmen…
-
HCM Extract Vs BI PublisherContent I do understand HCM Extract would be the recommended way of reporting versus BI Publisher. However, is there any Oracle documentation that I could refer that has… -
Multi-selection parameter is not working for more than 1000 LOVsContent Hi All, I am using position name as parameter in my BI report. Syntax for using multi-selection parameter is- POS.NAME IN (:P_POSITION) OR 'All' IN (:P_POSITION …