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 add "Year" ,"Start Date" and "End Date" as prompt parameter in BI analysisSummary How to add "Year" ,"Start Date" and "End Date" as prompt parameterContent Hi. I am having one requirement in absence management where need to fetch the absence t… -
Worker Assignment Event history - job title "as of" assignment effective dateSummary Pulling data relevant to the history effective datesContent We have a report that is pulling all assignment events for an employee -- essentially a full summary … -
Limiting Results of Reports Based upon Data Security Level DefnintionSummary Limiting Results of Reports Based upon Data Security LevelContent We have custom HR roles which limit some users from functions and AORs used for approvals. Is i… -
Adding Subject Areas - errorSummary Using the 'Create Analysis' option and selecting 2 Subject AreasContent Hello, I am new to reporting and trying to use some of the out of the box features. The s… -
Probation Confirmation letter Automation in Oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…
-
How to get the Person Number for WHO Columns Like Salary Last Updated BySummary How to get the Person Number for WHO Columns Like Salary Last Updated ByContent Hello Everyone, I am looking to get the person number for the WHO columns like Sa…
-
Person Profile Report - Reduce Number of RowsSummary How can we combine the row data per employee?Content We have a requirement for a report which HR can use to view employee's person profile data: certifications, … -
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Currently I am using SQL Results option to populate value of a dashboard prompt called "Global Job Band".I am using below SQL code for this : Select SUBSTR ("Gra…User_2025-02-04-22-00-05-391 46 views 2 comments 1 point Most recent by User_2025-02-04-22-00-05-391
-
Increasing Export Limit into Excel, CSV, XML, etc.Summary Is there a way to increase the row limit when exporting to Excel, CSV, XML, etc.?Content Is there a way to increase the number of rows that can be exported out o…
-
Multiple Rows to Columns, from different FieldSummary Conver multiple rows into columns where the rows are generated by more than one fieldContent HI I want to convert multiple columns to rows, I'm trying to use piv…
-
Extract all values from Person Profile Content Type in single cellSummary I want the entire contents of an employee's "Skills / Areas of Expertise" in one cellContent Hello I'm looking for a way to combine everything an employee entere…
-
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…
-
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…
-
Significance of default Data Source 'AuditDB' in BI PublisherContent Hello What is the Significance of default Data Source 'AuditDB' in BI Publisher while creating the new data set. My Oracle Cloud Application is: 19A (11.13.19.01… -
Row disappearing in the output of RTF when the XML group tag is not thereContent Hi All, I have built one RTF template and have 5 fixed absence plans. If any of the plans is not there then the row is not appearing in the output file. My requi… -
Need OTBI RpdSummary Need OTBI RpdContent Hi , I believe if we install BI Apps (OBIA) we can get RPD which has OTBI subject areas. Can some share OBIA/OTBI Rpd. I am mainly looking f…User_2025-01-29-21-55-25-526 38 views 5 comments 1 point Most recent by User_2025-01-29-21-55-25-526
-
HOW TO... Report using more than one OTBI subject areaContent Part of a series of short 'how to' videos to help with a variety of topics. This one explains how to report across more than one OTBI subject area using the "dim… -
Need Table name to pull the Order Entry in Time and LaborSummary Need Table name to pull the Order Entry in Time and LaborContent Hi Team, Need Table name to pull the Order Entry in Time and Labor. highlighted the required fie…User_2025-02-04-07-00-18-658 26 views 2 comments 1 point Most recent by User_2025-02-04-07-00-18-658
-
HDL Loader issueSummary HDL Loader sample for balance group migrationContent I am looking for a sample for performing the balance group migration using HDL, we have a balance group with…
-
Case expressionSummary Case expression not returning right resultsContent Hi, when I put the following Case statement, I do not get the right number in the "ELSE" statement. It is far …
-
Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaSummary Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaContent Hi Experts, Wondering if there is some documentation around… -
How to enable seeded dashboards/Reports on new responsive enabled pages?Summary How to enable seeded dashboards/Reports on new responsive enabled pages?Content How to enable seeded dashboards/Reports on new responsive enabled pages?
-
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a…
-
New Hire/Joiners and Terms/Leavers reportsSummary How to run New Hire/Joiners and Terms/Leavers reportsContent We are new to Oracle as of January 1 and still learning what the OBTI reports can do for us. We need…
-
OTBI - Historical Point in Time Assignment and ManagerSummary Report when using Assignment Event Details can't export resultsContent We originally created a historical report using the assignment details effective start and…
-
Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that excel output it shows as Number stored as text and it comes with that y…
-
Help with BI Publisher Report and ParametersSummary Help with BI Publisher Report and ParametersContent Hi - We are having an issue with a BI Publisher Report to on dashboard. When we have these reports on the das…
-
Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that excel output it shows as Number stored as text and it comes with that y…
-
Oracle Report Jam at Collaborate 2019Summary Here to Build Your Reporting ConfidenceContent April 8-10 2019, San Antonio TXCome and meet reporting experts from across Oracle HCM product development who can …
-
Need Catalog/Query to validate the PBL LoadSummary PBL Validation ReportContent Hi Team, Need a Catalog/Query to validate the PBL Load. can some one help with the query. Regards, Chaitanya.User_2025-02-04-07-00-18-658 38 views 4 comments 0 points Most recent by User_2025-02-04-07-00-18-658