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
-
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav… -
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number… -
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 206 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 -
Cloud HCM cannot enable writeback,,,Summary Unable to understand how to write back dataContent Hi All, I am attempting to write back to a dff that i created but have been unsuccessful so far. In OTBI the o… -
Salary basis for future hireSummary Using the Compensation - Salary details real time don't see salary basis for future hireContent We need to get the salary basis for new hires, rehires, etc. For …
-
Unreadable content when reporting on GoalsSummary Excel generated error when using Export to ExcelContent Hi, when I'm reporting off the 'Workforce Goals - Goal Status overview real time' subject area, the analy… -
Future Dated Salary ReportSummary Ability to run a future dated salary change reportContent Does anyone know if it's possible to run a future dated salary report? We want to bulk load salary data…
-
Has anyone seen this error before and what can I do to fix itSummary Has anyone seen this error before and what can I do to fix itContent I get this error when I am trying to add this code to a report. (select pappf.*,ppa.hr_assig…User_2025-01-30-00-38-09-143 47 views 2 comments 1 point Most recent by User_2025-07-18-02-05-33-261
-
High number of columnsSummary High number of columns in BIP reportContent Hello everyone, Could you please give some tips on what is the best layout output option in BIP for a report that has… -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 437 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261
-
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…
-
Duplicate Rows; Multiple lines of dataSummary My report is spitting out multiple lines of the same data; trying to find a way to consolidateContent I'm building a report that will serve as a validation/audit…User_2025-01-28-20-40-07-753 150 views 8 comments 0 points Most recent by User_2025-01-28-20-40-07-753
-
HCM Extract Bursting PrioritySummary How to set bursting priority in BI Bursting or HCM extract delivery optionContent One of our integration partner requires trigger file (empty file with same file…
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…User_2025-01-23-21-24-21-434 704 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434
-
OTBI - Double to string conversionContent I am creating a report having a column for "Initialized Balance". I need to show '-' if value is null otherwise show the value. When I use like this IFNULL(CAST(…
-
Provision to create PL/SQL Package in Oracle Cloud fusion HCM?Summary Provision to create PL/SQL Package in Oracle fusion HCM?Content Hello Experts, Can we create a PL/SQL Packages in oracle cloud fusion hcm? Do we have provision f… -
OTBI - Absence Plan Period Start dateContent Hi, I am looking for Plan Period Start date (Absence). In which subject area and where is the location of that field. I have attached the screen shot which shows…
-
Absence Accrual Plans for EmployeesSummary Need query table/analysisContent One of our states where our employees are located has ruled to provide hourly employees with sick pay of 40 hours per year after…
-
Active Employees in a QuarterSummary How can I find Active Employees in a particular Quarter.Content Hi, Current I am using Assignment event real time subject area. I can pass 2 dates one start date…
-
Department tree versions issueContent Hi , Department tree having 2 versions , both are active , old version is end dated 31/12/2016 and new version is starts from 1/1/17. In new version existing dep…
-
How to Obtain "People Group" Field through BI PublisherSummary How to obtain "People Group" field through BI PublisherContent Hello All, I am unable to obtain "People Group" and "Legal Employer Name" fields through querying … -
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man…
-
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…
-
EEO-1 Report - R13Summary DUNS Number does not fit in field on reportContent Hello Community, The DUNS number on the delivered EEO-1 audit report in R13 does not fit and is cut off. In R1… -
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
SQL Expression for a specific month and day with a year of current year - 1Content Hi - I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year. I would like to make the year dynamic based on the year of t…
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Does Drill down feature work for Logical SQL based Analytics?Summary Want to know if the drill down feature works with analytics developed using Logical SQLContent For one of the requirement it was not possible to use the fields d… -
Weight updated from PerformanceSummary table of weight updated by PMContent Hi, I need to export the weight field about a goals that you can define from Performance Section. Could you please help me? …User_2025-01-28-21-18-09-074 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle