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
-
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 44 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 71 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 97 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 72 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 55 views 2 comments 0 points Most recent by User_2025-01-31-02-00-10-435
-
Analysis on Assignment related changesSummary Analysis on Assignment related changesContent Hi - We are trying to create some notifications/alerts for assignment / employment changes. Has anyone have an exis…
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …
-
Average age as of date errored out when use Performance TileSummary Average age run as of date parameter errored out when run as Performance Tile only but it is not errorring when run on different compound view using both Perform…
-
Subject Area for Compensation One Time PaymentsSummary Is there a Subject Area for Compensation One Time Payments?Content Is there a Subject Area for Compensation One Time Payments?User_2025-01-22-19-38-05-255 12 views 2 comments 0 points Most recent by User_2025-01-22-19-38-05-255