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 it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi … -
Fusion Join beetween PVO'sSummary Need inputs for Sr # 3-19578113071Content Hi, Customer requirement is to get the "Displayed Input Value" field in ODI(Third party ETL tool) for that we have iden… -
'Column format - Suppress' do not work in OTBI Direct Database request reportSummary Suppress property in OTBIContent Hi All, I have created a direct database request report where I want to suppress a field 'Year' if the values are repeated. I us… -
Time card transferred to Payroll with success and failureContent Hi All, I am working on a report to get details of 1. Timecards transferred to Payoll. 2. Time cards not transferred to Payroll due to error and 3. Time card exc…
-
Customizing Seeded Analyses from CatalogSummary Seeded analyses are using custom values that don't match our setupContent Hi Everyone, I understand that with R13 we can no longer modify or remove the seeded re… -
Choosing All options from filter at the TableSummary We have department filter at one Table. We can't choose All.Content Hi All, How can we choose All options from one filter at the table. It allows only declared d… -
Employees by Tenure and Age BandSummary Employees by Tenure and Age BandContent Hi I am looking for a report which has the Employees by Tenure and their Age band for the last 4 years. Could you please … -
Unable to generate EEO-1 (Type 3 and Type 4 ) ReportSummary Unable to generate EEO-1 (Type 3 and Type 4 ) ReportContent I We have configured the EEO as per the note "Fusion US Payroll: How to Setup EEO-1 Report. Also appl…
-
How to add default value for a particular column in OTBISummary How to add default value for a particular column in OTBIContent I have created a analysis in OTBI. And have added one date column in the Promt and trying to defa…
-
Unable to identify manage element screen under settlement date column in element entry tableSummary Unable to identify manage element screen under settlement date column in element entry tableContent Attached application screen shot from Manage element entry an…
-
How to remove Grouping of data in OTBISummary How to remove Grouping of data in OTBIContent I have Created a report to fetch the absence Entries for a Person.And in the Prompt i am using Start date column. i…
-
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics.
-
Element Entry ReportSummary Element Entry ReportContent Hello Experts, Wondered if anyone could help with xml/sql that will help me pull out all the element entries against all employees (i…
-
Totals for Amount fieldSummary How to subtotal a field that does work when using "Totals After"Content Hello Experts, I am trying to create a subtotal of a field called "Amount" from "Benefits…User_2025-01-29-23-59-58-976 53 views 6 comments 0 points Most recent by User_2025-01-29-23-59-58-976
-
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g… -
Using Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…User_2025-02-04-18-26-11-309 1.2K views 6 comments 1 point Most recent by User_2025-02-04-18-26-11-309
-
Recreating HR dash boardContent Hi Team, Since the HR dash board willnot availabe after the latest patch, We are recreating it. We are facing following issue, 1. In one of the choice list "maxi…
-
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
How to link Data Sets belonging to different Data Sources in Oracle BI Publisher in HCM CloudSummary Approach to link data sets created from WebServive and SQL Query Data SourcesContent Hi All, We have a requirement to build reports on data from external data so…
-
HCM - Business Intelligence: Using OTBI Hierarchies -- September 14, 2017, 9 a.m. PT - Submit QuestiContent Submit your questions for the HCM - Business Intelligence: Using OTBI Hierarchies session to have them answered during the live event. Post your questions by pos… -
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …
-
OTBI Agent not sending some of the recipients emailsSummary OTBI Agent not sending some of the recipients emailsContent Hello, One of the recipients mails in agent - is not being sent , ALL other mails are sent . what cou… -
BI Publisher GUI Outer Join QueryContent Hi, We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models. Background: We used to have this pending ap… -
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f… -
Top Manager field not populatedSummary Some employees are missing a Top Manager so they don't appear on reportContent Does anyone know how the Top Manager field gets assigned? I pulled it into a repor…
-
Loan 401K Accrued BalanceSummary Trying to find where the Loan 401K accrued amount is stored in OracleContent Hi, We have a number of 401K Loans and due to the way we process thru our vendor we …
-
Error when Migrating Custom Subject Area ContentContent Hello! I migrated over my reports from one test environment to another test environment by using Archive/Unarchive. My reports have some custom columns that are …User_2025-01-31-00-25-12-234 39 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Need new table names to pull calculation card detailsSummary Need new table names to pull calculation card detailsContent Hi Team, i am looking for the table names/query to pull the calculation card details like Federal , …
-
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun…
-
Element result report - explanationSummary How the Element result report is designedContent Hi All, Can anyone elaborate me how the Element result report is designed. I am able to understand the Extract's…