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
-
Prompt Filter - Date Format ChangeSummary We can't change filter's Date Format at promptContent Hi All, I added date filter with using Prompt for analysis. In Analysis, I can change date format as I want…User_2025-02-04-18-26-11-309 93 views 12 comments 2 points Most recent by User_2025-02-04-18-26-11-309 -
Issues with BIP reportSummary Issues with BIP reportContent Hi, I have following issues with my BIP report: 1. How to fetch country name from a country code ? I need to print country name in …
-
Employee Roster by Month Including Hours WorkedContent Does anyone have an example of a report that can be selected based on a begin/end date and list all employees with an active assignment for a specific department… -
As-of-Date Doesn't work anymoreSummary As of date variable in OTBI doesn't workContent Hi, Since the last release, the feature of putting variable in OTBI analysis for effective date doesn't work. The… -
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…
-
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 114 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021
-
OTBI Does Not Produce ResultsContent Hi All, I am just running a simple query to get the list of all employees. It's only showing my name, plus as soon as I one more column it does not produce any r… -
Timezone - BIP Report schedule defaultSummary Timezone - BIP Report schedule defaultContent Hello All, When we schedule any BIP report, in Output tab we noticed that below is the default timezone for all use… -
Unable to report on Element Entry HistorySummary 1=2 in SQL query?Content Hello Everyone, I'm trying to use Payroll - Element Entries History Real Time and have created a simple analysis (XML attached) to see e… -
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud Thanks
-
19B caused a number of BIP reports to now fail - HY000Content Hello, Following our upgrade to 19B at the weekend a number of custom reports are now no longer working that we had built. I wonder if any reporting experts woul… -
Report for users with current rolesSummary Not able to pull all users for above reportContent Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Req…
-
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
'Column format - Suppress' do not work in OTBI Direct Database request reportSummary Suppress property in OTBIContent Hi All, I have created a direct database request report where I want to suppress a field 'Year' if the values are repeated. I us…
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re… -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a… -
Possibility of creating a report with Card Association ID'sSummary Has anybody got a report displaying Card Association ID'sContent Hi, We are looking to create a report identifying Calculation Card ID's We have looked at the fo… -
How to add default value for a particular column in OTBISummary How to add default value for a particular column in OTBIContent I have created a analysis in OTBI. And have added one date column in the Promt and trying to defa…
-
Absence ApprovalSummary Looking to produce a report to show denied absences.Content Hi all, I need to create a report to show historic absence data and to include denied absences. I'm u…
-
Unable to identify manage element screen under settlement date column in element entry tableSummary Unable to identify manage element screen under settlement date column in element entry tableContent Attached application screen shot from Manage element entry an…
-
Unable to generate EEO-1 (Type 3 and Type 4 ) ReportSummary Unable to generate EEO-1 (Type 3 and Type 4 ) ReportContent I We have configured the EEO as per the note "Fusion US Payroll: How to Setup EEO-1 Report. Also appl…
-
Employees by Tenure and Age BandSummary Employees by Tenure and Age BandContent Hi I am looking for a report which has the Employees by Tenure and their Age band for the last 4 years. Could you please … -
Choosing All options from filter at the TableSummary We have department filter at one Table. We can't choose All.Content Hi All, How can we choose All options from one filter at the table. It allows only declared d…
-
Is there a User Activity Report?Summary Is there a User Activity Report?Content Looking for a report or way to see how often user(s) login to Core HR system. Any reporting or functionality capable of t…
-
How create a column by concatenating multiple columns in otbiSummary How create a column by concatenating multiple columns in otbiContent We have a requirement to concatenate multiple columns and print it as separate column in otb…
-
Cannot Find Category Name in Service RequestsSummary Looking for Category Name in the CRM Service ModuleContent Hey everyone, We recently installed HCM and we use the service model to act as our HR Help desk. I hav…
-
How to remove Grouping of data in OTBISummary How to remove Grouping of data in OTBIContent I have Created a report to fetch the absence Entries for a Person.And in the Prompt i am using Start date column. i…
-
Time card transferred to Payroll with success and failureContent Hi All, I am working on a report to get details of 1. Timecards transferred to Payoll. 2. Time cards not transferred to Payroll due to error and 3. Time card exc…
-
Using Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…User_2025-02-04-18-26-11-309 1.3K views 6 comments 1 point Most recent by User_2025-02-04-18-26-11-309
-
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics.