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
-
Job field empty for one employee but filled for other employeeSummary In a report the job field for some employees is empty and for some it does contain informationContent I have created a report with two subject areas (workforce m… -
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b… -
Adding Dynamic BI Publisher Link to DashboardSummary Creation of a simple dashboard with links to all reports in our instance (static BIP links don't solve our issues)Content Hi all, We are trying to create a more … -
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary =IF((Base SalaryContent SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (select salary_amount from cmp_salary where assignment_id=a.…
-
Performance Tile - create a measure of maxium distance from CEOSummary How to create a measure of max of levelContent Hi, we need to create a measure that is the maximum distance from CEO. Level is calculated by the following formul… -
Performance Tile - create a measure #managers/#employeeSummary How to create a measure #managers/#employeeContent Hi, we need to create a measure that is the ratio within the number of managers and the numbers of employees. …
-
Course training hoursSummary Learning DashboardContent Hi I am trying to pull through the training hours for the course against each of the offerings under the course, but nothing is pulling…User_2025-02-06-11-18-47-896 33 views 8 comments 0 points Most recent by User_2025-02-06-11-18-47-896
-
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement … -
Filled Requisition ReportSummary Need help troubleshooting a few things on a filled requisition reportContent Hello! Looking for some help troubleshooting the attached filled requisition report.…
-
Calculated item for % assigned to courseSummary Learning DashboardContent I`m using a new calculated measure to work out the 'Capacity % Filled' for each of the courses but it won't calculate correctly. Any id…
-
Duplicate Element EntriesSummary Element entries for employees are appearing twiceContent Hi, Please see attached XML file/ If an employee has more than one element entry then that will appear o…
-
LSQL QuestionsContent Hi all - I am working on an LSQL report for combining salary/assignment data to show old/new information. I have run into a few questions that I am really hoping… -
Slow Performance when Department tree columns are includedContent We have built a simple report using ‘Goal Alignments Real Time’ subject area. The report runs in few seconds if we do not include Department tree columns. Howeve…
-
Salary in USDSummary Create a report which calculates Salary in USD from Local currencyContent Hi, Am try trying to create a OTBI report which converts Salary (in local currency) to …
-
BI Publisher Report not runningSummary ORA-01476: Divisor is equal to zero error messageContent Hi, A user has contacted me saying they are unable to run this report and they see the following error m…User_2025-02-05-22-44-35-842 28 views 5 comments 0 points Most recent by User_2025-02-06-08-02-11-890
-
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are … -
Manager Name for a Position in an AnalysisSummary Pull in name or assignment numberContent Can you pull in the position manager in an analysis off of the position? I see supervisor ID and supervisor assignment i…
-
Requested feedback reportContent We are trying to build a report to get the requested feedback details using ‘Workforce Performance - Requested Feedback Real Time’ subject area. However, no data…User_2025-02-05-23-59-37-171 115 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
BI Publisher ReportSummary Column FormattingContent Hi, I have a BI Publisher report and everything works well but there are 2/3 columns that are not formatted correctly which makes the re…User_2025-02-05-22-44-35-842 39 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Aligned Goal information missing in report outputContent We are setting up Goal Alignment report using the "Workforce Goals - Goal Alignments Real Time". Subject Area. The report works fine when running with a HR View …User_2025-02-05-23-59-37-171 68 views 4 comments 0 points Most recent by User_2025-02-05-23-59-37-171
-
Workforce Trend Headcount by User Person TypeSummary We have a requirement to trend headcount by person type. It appears the workforce trend real time subject area only returns the latest person type and not the pe…
-
Fiscal CalendarSummary Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar.Content Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year …
-
Reports (and Dashboard) SharingSummary Request for best Practice for Reports (and Dashboard) SharingContent Hello all! We have newly implemented HCM Fusion and received little guidance concerning Repo…
-
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin…
-
Pivot Report - Have a heading and change value sequenceSummary How to change value sequence and have a label in pivot report?Content I have created an OTBI report with pivot output. On left side is the desired output and on …
-
FTP File delivery - PGP Encrypted with required extensionSummary PGP encrypted output with desired extensions.Content Hi All, We have a requirement to generate the extract output which is text format but > Delivery method : FT…
-
Attachment to the ORC NotificationsSummary ORC, Attachment to Offer Approval NotificationContent Requirement is to fetch and open the internal document (attachment) from offer approval notification. Curre…
-
Seniority Dates V3Summary OTBI Subject Areas to Report on Seniority Dates V3Content Does anyone know if the Seniority Dates V3 are available in any OTBI Subject Area? We need to be able t… -
Calculation cards Federal Start date and End DateContent Hi All, In which table/column holds the Federal Start Date and End date values. Thanks, Visu
-
Current and Previous Employment detailsSummary I need BI report to fetch Current and previous employment details.Content Hi Team, I need a BI report (Not OTBI) to fetch current and previous employment details…