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
-
Fetching Gross Pay YTD for a terminated employee in BI ReportSummary Fetching Gross Pay YTD for a terminated employeeContent Hi, I am able to fetch Gross Pay YTD till last payroll process date but not after that. I require to fetc… -
Run report on OBIEE on specific user\permissionsContent Hello, Is someone familiar with a way to run specific analysis in OBIEE catalog without consider the permissions of the user? I explain: we have users the shoul…
-
Chart Legend ColorsSummary Is there a way to change the chart colors in OTBI?Content I cant find or figure out how to change the colors on my bar chart. Any help would be greatly appreciat…User_2025-01-28-08-47-04-905 62 views 3 comments 1 point Most recent by User_2025-01-28-08-47-04-905
-
Performance Document StatusSummary Lost Performance Document information after manager changesContent Dear All, In my simple analytic I use the worker manager, his employees and the status (Perfor…
-
Duplicate RowsSummary When bring multiple emails / phones, it brings them in on one line and then creates an additional line with one of the attributesContent UPDATE: With everyone's … -
Benefit CreditsSummary We need a report that would display Benefit CreditsContent We need a report that would display Benefit Credits by Person Number on the left access and each benef…User_2025-01-29-19-59-40-005 48 views 1 comment 0 points Most recent by User_2025-01-29-19-59-40-005
-
Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XXSummary Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XXContent Hi, We have a requirement as below: ========================… -
Does anyone have a report that gives the rate of pay at the time someone is paid?Summary Looking for pay rate reportContent Does anyone have a report that is able to show what rate someone was paid based off of the payroll run results? For instance, …
-
Let us know how you deliver manager and HR dashboardsSummary 5 minute surveyContent Following the deprecation of the Manager Resources and Human Resources dashboards in HCM Cloud, we are interested to understand how you ar… -
Is there a way to sort a date field by month only?Summary Field format shows MM/DD but sorts by Year. Is there a way to sort/filter by just the month?Content I have created a Birthday report and the date field format re…User_2025-01-28-20-43-56-568 78 views 3 comments 1 point Most recent by User_2025-01-28-20-43-56-568
-
Historical Audit Report for Assignment dataSummary Looking for existing report, or direction on how to construction report for historical Assignment dataContent Hi, Can you please suggest if there is an existing …
-
Max cell count reached when exporting analysis to ExcelSummary Max cell count reached when exporting analysis to Excel truncating dataContent Good afternoon. We have begun seeing the following error when running some of our … -
Last full time equivalent salary for leaversSummary Looking to report on the last full time equivalent salary for leaversContent Hi, I have created an absence report to show absences for a set period. I'm looking …
-
Printing details on a single row using a XSL Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio… -
Hierarchical prompt for org tree strucutre in BI Data Model ReportContent Is it possible to create a prompt in BI data model report that will give us the whole org tree structure in a cascading way according to different levels as we h… -
Oracle Report Jam at OHUG 2018 in VegasContent Highlights Sign up to guarantee some in-depth 1:1 report building using Oracle Transactional Business Intelligence (OTBI) for HCM, Taleo Acquisition, Taleo Learn…
-
HCM OTBI Report Multiple Selection ParameterSummary HCM OTBI Report Multiple Selection Parameter Not WorkingContent Hi, I'm trying to use multiple selection parameter ( menu type ) in data set sql query but report…
-
link dashboard to a page entrySummary how the get the dashboard URL in order to make a new page entryContent hi all, ive created a Dashboard which include an absence analysis and a general prompts in…
-
Maximum job proficiency in job profile competency in BI PublisherSummary where can I find the target level of competency job profile in BI publisherContent Hello, Do you have an idea where can I find the maximum proficiency in job com… -
Is there a way to create a sql viewSummary Is there a way to create a sql viewContent We want to create a sql view (e.g. employee hierarchy) and use it in various reports rather than repeat the code in ev…
-
Total Compensation StatementsSummary We don't use the comp module - but we do utilize the Payroll and Benefits modules. Has anyone created a OBTI report that would pull all gross payroll numbers, LT…User_2025-01-29-19-59-40-005 102 views 9 comments 0 points Most recent by User_2025-01-29-19-59-40-005
-
Amounts getting duplicated in OTBISummary Amounts getting duplicated in OTBIContent Hello - We build a custom OTBi report using 'Compensation - Workforce Compensation Real Time' SA. There are few columns…
-
Measures and Multiple versions of Org HierarchySummary Issue with Org Fields introducing a multiplier of delivered measuresContent Hi community! Recently we have introduced a new organization structure into our appli…
-
Two part question regarding CEO's manager and Assignment Manager (Unsecured)Summary Reporting with CEO and Assignment Manager (Unsecured)Content This is a two part question. 1.) Our CEO does not currently report to any manager in HCM. Is this co…
-
BI Report to draw Absence Balance mismatchSummary Need to develop a OTBI/BI report in Fusion to draw Absence Balance mismatch in front endContent Hello Team, There is a balance mismatch in Fusion front end. The … -
Unable to fetch few tasknumber from approval related tablesContent Hi Team, We have a requirement to generate report for approval transactions (i.e approved/rejected). For that we have built a query based on the below tables 1)h…
-
Payroll - Element Entries Real Time SA not returning all Elements associated with personSummary Number of Element Name for a person returned by Payroll - Element Entries Real Time Subject Area is not matching with Fusion Data. Please suggest.Content Please …User_2025-01-30-20-59-13-989 76 views 6 comments 0 points Most recent by User_2025-01-30-20-59-13-989
-
Years in Job calculationSummary How to calculate years in jobContent We are trying to calculate the number of years an employe has been in a specific job, but since there is no "start date" for… -
Query related to Job Code and Position NameSummary Query related to Job Code and Position NameContent Hi I would like to know if we can fetch the job code and Position Name in one table. Can anybody share the que…
-
Oracle HCM Cloud, Release 13 (Update 18A), May Maintenance Pack?Summary Any one upgraded their systems to Oracle HCM Cloud, Release 13 (Update 18A), May Maintenance Pack?Content Hi All, Any one got their versions upgraded to Oracle H…User_2025-07-18-02-05-33-261 59 views 2 comments 0 points Most recent by User_2025-01-31-02-00-10-435