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
-
Manager Name not updating in AnalysisContent Hi, I have an OTBI analysis that display incorrect information from regional and resource managers. For some reason a manager change is not coming through despit… -
Manager Name not updating in Absence ReportSummary Manager change not reflected in reportContent Hi, I have an absence report that has a legal entity prompt that end users use that has worked perfectly fine until…User_2025-02-05-22-44-35-842 26 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 -
Analytics Section on HomepageContent Hello Everyone, Has anyone used "Analytics" section on homepage to display reports/dashboards? Currently, it displays Order to cash infolets and Service infolets… -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio… -
Provide Deep Link for a Performance Document inside a BI Publisher ReportSummary Refer to the direct Deep Link for Performance Document for Manager's feedbackContent Hi All, We are building a custom BI Publisher report that will generate Emai…
-
Multiple lines of dependent dataSummary Report not providing latest data only but multiple lines for dependentsContent Hi, I have created a report to provide the age, disability and Student Status of c…
-
BI Publisher vs OTBI? Any guidance/recommendations on when to use each solution?Content Hello, I have tried searching but cannot see anything as focused - query is, are there any recommendations or guidance from Oracle around when to use BI Publishe… -
HR Help Desk Affected PartyContent Hi all, We are currently rolling out the affected party field in HR Helpdesk and I'm having issues with finding the field in OTBI. Has anyone successfully report…
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…
-
How to know input values supported by any fast formulaContent Hi All, Like we have query to get context supported by fast formula, do we have any similar query or table that can help to fetch input values supported by any f… -
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.
-
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
Create a report for Areas of ResponsabilitiesContent Hi Guys, I need to realize a Report in order to extract: Person ID, Employee Name, Area Of Responsibility Name , Responsibility Type and Scope Of Responsibility.… -
Calculating the number of days between 2 prompt datesSummary Calculating the number of days between 2 prompt datesContent I have set up a prompt to get the absences with start dates between 2 dates but I would like to be a…
-
Oracle BI to HCM NavigationSummary Oracle BI to HCM NavigationContent Hello, Is there a smart navigation that will allow users to navigate from BI back into HCM without a new web browser being gen…
-
Implementing Styles in OTBISummary Where do you go to create/edit Styles for OTBIContent Hello Experts, We're using OTBI and I'm trying to leverage Style to get a consistent look and feel to our r… -
Leave adjustment detials for employeesSummary Leave adjustements for employees is available in any subject areas in OTBIContent HI, In the Absences sometime HC team are doing adjustment in the annual leave, …Farooq Syed, CPA, PMP, CISA, TOGAF 29 views 4 comments 1 point Most recent by User_2025-02-06-09-29-18-902 -
HR Help Desk - SR`s out of SLASummary Can we report on how many SR`s go out of SLAContent Hello All, i was wondering if anyone knows how i would go about creating a report on how many SR`s per period…
-
subtracting datesSummary OTBI subtracting datesContent I require a column that returns the difference between the current date/time and a column in OTBI, the results must be measured in …
-
Improvement Ideas for BI Catalog UI / NavigationSummary BI Catalog UI ImprovementsContent Hi All, We at DHL are using HCM for few years already and we are looking to further exploit our data to provide intelligence an… -
Bursting report with two parameter is not workingSummary Developed a bursting report with two parameter. One is date and another is person number. When the report is running by selecting a date and an employee it is wo…User_2025-02-05-22-36-27-300 82 views 2 comments 1 point Most recent by User_2025-02-05-22-36-27-300
-
Subject Area for Organization AttributesSummary Subject Area to display attributes from hr_all_organization_unitsContent We deployed few attributes at PER_ORGANIZATION_UNIT_DFF under Manage Organization Struct…
-
Oracle BIP Report - Does not return results with 'French' as Application Interface LanguageSummary Oracle BIP Report - Does not return results with 'French' as Application Interface LanguageContent Hello, I have a BI-Publisher report which uses database tables… -
OTBI - FTE doubles when adding line manager nameContent Hi, I have an OTBI report. Using the "Workforce Management - Worker Assignment Real Time" subject area. I am pulling back: "Worker Assignment > FTE" and am filte… -
Fusion -> Embedded BI Dashboard -> Job History -> Return gives errorSummary Fusion -> Embedded BI Dashboard -> Job History -> Return gives errorContent Hi, We have a few BI Dashboards / BI Reports embedded in Fusion application pages. Wh…User_2025-02-05-09-09-02-489 50 views 4 comments 1 point Most recent by User_2025-02-05-09-09-02-489
-
Reports in Flow Patterns: customizing layout, output, delivery, etc.?Summary Reports in Flow Patterns: customizing layout, output, delivery, etc.?Content I'm starting to work with creating Flow Patterns, and have a few questions I can't f…
-
How to add as-of date to existing reportSummary Workforce Management - Worker Assignment Real Time Analysis reportContent Hi, I have an existing report that requires an as-of date filter, I'm not sure how to d…User_2025-02-05-22-44-35-842 801 views 10 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
Is it possible to get metadata of OTBI reportsSummary I am looking for any workaround to get the report/analysis names with subject areas used in a folder.Tried to find any xdo tables but no luck. TIAContent Assume …
-
US Affirmative Action ReportingContent Hello, I was wondering if any had report examples that they use for AAP reporting? I have a few job change reports, but none that combine job change values and s…
-
Editing a scheduled OTBI AgentSummary Receive error when trying to edit a scheduled OTBI agentContent Does anyone know if you can edit an agent that is currently scheduled? I receive an error each ti…