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 display condition based counts in OTBI pivot reports?Summary How to display condition based counts in OTBI pivot reports?Content Hello All - Looking for your inputs on this pivot report. I have a condition like this (CASE …User_2025-01-25-04-02-13-126 37 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 -
If we can track if the BI report last modified by which userContent Hi, We need to find last modified by on DM and Reports , if we can track if the BI report last modified by which user Regards Nidhi -
Primary FlagSummary What does it actualy do?Content Hi, total N00b here, please bear with me! In our version of Oracle, we've always used five flags (below) in order to get 'active'…
-
Having problem with Manager Field in OTBISummary Having improper value of Managers in OTBIContent In our system we have two different manager type i.e. functional manager and one is matrix manager. Functional M… -
License and certifications Skill Area Attachments - Where are they stored?Summary Require ability to view attachments employees have added to their License and certifications in OTBIContent Hello, I am trying to view attachments employees have…User_2025-02-04-11-20-13-378 107 views 7 comments 1 point Most recent by User_2025-02-04-11-20-13-378
-
HR Specialist information- Which subject area contains the informationSummary Is there any Subject Area that can tell who is the HR Representative of an Employee?Content Hi I have the need to create an analysis and include who is the HR re…
-
FMLA Absense Report issueSummary FMLA Absense Report issueContent We have build a report in OTBI that would total all of the FMLA Time Off Codes (US FMLA, US FMLA No Pay, US FMLA PTO, US FMLA ST… -
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click …
-
DFF in RTF for GoalsContent Hello, I created 4 DFFs in Goal Details page and would like to include them in the RTF. However i don't see them in the xml output to use in while editing the RT… -
OBI - Cant view all employees in resultsSummary OBI - Cant view all employees in resultsContent Have a Custom HR data role with view all persons and view all everything else. This role also has Workforce Trans…
-
How to bring citizenship and nationily in analaysis?Summary Creating a termination Report using subject area Workforce Management:Worker Assignment Event Real TimeContent Creating Analysis in OTBI using subject area Workf…
-
Sql to find Learn content without a course, Offering and Selfpaced ActivitySummary Sql to find Learn content without a course, Offering and Selfpaced ActivityContent It would be a great help if you can give me the sql which can find the Content… -
Images on InfoletsSummary We want to find suitable images to display on our infoletsContent Hello, For some of our infolets where it isn't relevant to see a count of colleagues e.g. numbe…
-
Talent Profile - Summary of RoleContent Hi all - I am trying to find the fields to create a report from our Talent Profile section. I am trying to find how to report on the area in Fusion going to Pers… -
Generate OTBI Report only if it meets specific population sizeContent I have a business requirement where an infolet (OTBI report) should not generate a report/data if the population size is less than 20. Does anyone know how to de…User_2025-02-04-10-47-55-876 65 views 2 comments 1 point Most recent by User_2025-02-04-10-47-55-876
-
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
Need Help? Contact Us? InfoletSummary Need Help? Contact Us? InfoletContent Hi, The following post suggests the region 'Need Help? Contact Us.' on the Managers Terminate Work Relationship page is an … -
How to pass Run Time Parameter in Logical SQLSummary How to pass Run Time Parameter in Logical SQLContent Hi Team, I am working on one Logical SQL in OTBI. Report is working fine but i could not bale to pass run ti…
-
Report to view status of every individualContent Hi, I have a need to list every person in the organisation and whether they are active or not. I can look at assignments but obviously someone could have multipl… -
Busting OTBI Myths - Trend reportsContent Myth: You can't report trends in OTBI Trend reports can be produced in any subject area which has a "Time" dimension folder (as of 19B 63 out of 78 subject areas… -
How to add securituy in OTBI foldersSummary What is the best practices for security for OTBI folder level for all Organization.Content Under Custom folder there are sub folder as mentioned below for FIN, S… -
Removing Rich Text Formatting from OTBI AnalysisContent Morning all, Can anyone suggest any ways of removing any formatting from text fields in OTBI? I'm trying to export our Goal Descriptions / Success Criteria / Com…
-
Headcount Measure shows blankSummary Headcount Measure shows blank from workforce Management - Worker Assignment real time subject area where as we can see the values from applicationContent Hi, Hea…
-
Past terminations not appearing in reportsContent We added anyone who has left this year (prior to implementation) as basic records so we could report full year of leavers data and those basic records are not ap…
-
Get Assignment > Job Details > Manager Details in OTBI Subject areasSummary Would like to know where to pull the data which I can see in the Manager Employment > Assignment > Job Details > Manager Details sectionContent Hi, Business woul… -
Date prompt is getting passed in invalid format to BI report used in Dashboard.Summary Date prompt is getting passed in invalid format to BI report used in Dashboard.Content Hello, We are facing an issue in while using dashboard as BIP as content. … -
Position Management ReportingContent All - I posted this in the reporting board as well, but started to wonder if there was also a process/configuration limitation to the data/reporting available. H…
-
Historic data of role assignmentsSummary Historic data of role assignmentsContent Hello Does anyone know if it is possible to return the history of a role being assigned to a user? For example User A ha…
-
BI Publisher Export LimitContent We recently created a BI Publisher report based on a Data Model. The Data Model was created based on a BI Analysis. When trying to schedule the report with an ou…
-
DISTINCT NOT WORKSSummary DISTINCT NOT WORKSContent Hello everyone, Does anyone have any idea why my query does not work? I'm using DISTINCT but I get repeated rows. Also, we have 8500+ e…