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
-
OTBI - Pivot with multiple information types (Email Type, Phone Type)Content Hi, We have a report with some personal information on it. Among other columns in report we do have Email (incl. Email Type) , Address ( incl. Adress Type) and P… -
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 88 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571 -
Any way to query a table to capture the IP Address of user logging in?Summary IP Address of user logging in?Content I have been asked if it is possible to provide a report of users logging in to HCM Cloud over the past 30 days and provide … -
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…
-
How to enable seeded dashboards/Reports on new responsive enabled pages?Summary How to enable seeded dashboards/Reports on new responsive enabled pages?Content How to enable seeded dashboards/Reports on new responsive enabled pages? -
Subject Area for Area of ResponsibilitySummary subject area needed for area of responsibilityContent We have had a business need for some time to pull Area of Responsibility information into an analysis. Does… -
Looking for a simple element balance look up that captures Payroll reversalsSummary My element balance look up is missing negative values that occur from Payroll voids and revesal.Content Hi, I have this simple Payroll element balance look up th…
-
Oracle BIP Bursting of PDF Output to a 'local' directorySummary Oracle BIP Bursting of PDF Output to a 'local' directoryContent Hello, I was trying to schedule a BIP job to burst the output file type of PDF to a local machine… -
Created a Time Card dashboard and want to the Manager prompt to default to the manager pulling the rSummary Is there a way to default a prompt so that it is automatically set to the person that is pulling the reportContent We have a Time Card dashboard with a prompt fo…User_2025-01-28-20-43-56-568 73 views 8 comments 2 points Most recent by User_2025-01-28-16-10-52-033
-
Manager hierarchy not updatingSummary Manager changes aren't updating in the flattened hierarchy table despite the scheduled process running successfullyContent Since upgrading to 19A a couple weeks …User_2025-01-25-02-35-56-629 217 views 7 comments 2 points Most recent by User_2025-01-25-02-35-56-629
-
Audit Table InformationSummary Audit Table Information - AUDIT_CHANGE_BIT_MAP_Content Hi, Our business requirement is to do an Audit on the changed attributes. So as per Doc ID 1923367.1, we e… -
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl… -
Performance Tile and Change ViewSummary Performance Tile and Change ViewContent Is it possible to create a performance tile infolet - let's say for Employee Headcount and then include a Change View sel…User_2025-02-04-10-47-55-876 61 views 2 comments 2 points Most recent by User_2025-02-04-10-47-55-876
-
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 174 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro
-
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w… -
Person Address HistorySummary Need to pull all addresses for specific personsContent We are finding all sorts of errors with our addresses; no end dates, multiple addresses of same type I am …User_2025-01-23-21-24-21-434 300 views 5 comments 2 points Most recent by User_2025-01-23-21-24-21-434
-
How to get the manager's manager name in OTBIContent Hi, I got the employee manager name in OTBI subject area's and we need manager's manager name in OTBI. Please let me know the presentation table and column for t… -
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in… -
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks Thiru -
Data Model Validation ResultSummary SQL query contains non-equi joinsContent Hi Guys, I am in 18C and I am getting the following warning message in Data Model: WARNING Dataset:LOV_Emp_Name SQL quer… -
Reporting Questions (HCM data)Summary Reporting Questions (HCM data)Content Have 2 reporting related questions: 1. Which reporting tool (OTBI or BI Publisher) do you train your business users on? The… -
Integration or Report ScheduleSummary Integration or Report ScheduleContent Hi experts, please provide steps for canceling schedule of hcm extract integrations. And how do we check weather if BI Publ…
-
"Questionable" URL link from Absence DashboardContent Morning Experts, Really hoping someone can shed some light on this bizarre issue. We have the standard Oracle OTBI dashboards within our Production environment a…
-
Table name for department history of employeeSummary Table name for department history of employeeContent Hi All, May i know the any other table name which tracks the department history of employee except per_all_a…
-
How to sort Payslip reprinting report?Summary Need to know how to add a sort order to a RTF templateContent It is suggested in the following Oracle support note to customize the payslip template to achieve a… -
Subject Area for Employee roleSummary Subject Area which Employee role has access, and employees can see their LE and LOCContent Subject Area which Employee role has access, and employees can see the…
-
Languages for a personContent In SQL, which table(s) would I need to look at to get the following data for a person? * Language * Speaking Level * Writing Level * Reading Level * Sign Level T… -
Termination date for Rehire employeesSummary Termination date for Rehire employeesContent How to display termination date for rehire employees in OTBI report. We want only the latest assignment record to be…
-
Current Leave Balances and impact of Future Leave BookingsContent Hi All The sample report attached is a visual representation of two interacting elements: Current leave balance (up to the balance calculation date) and Future B…User_2025-01-30-03-53-16-644 84 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle