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
-
Onboarding/Recruiting Employee Name fieldSummary: What is an alternative for updating the "Employee Name" in OTBI, where it displays First Name Last Name for Onboarding/Recruiting, and not change any of the exi… -
filter out html imputs in columnSummary: Im making a reporting for talent and need to filter out de html inputs in the Description field of the table HRT_CAREER_STATEMENT_ITEMS_V. is there a better way… -
OTBI Report Library ReportSummary: First question: Is there a subject area besides OTBI Usage that displays the entire catalog of reports, allowing you to filter by a commonly used field? For exa…
-
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks… -
Compensation - Indvidual compensation real time not showing any detailsDespite of having the necessary roles I still don't have access to show data from this subject area I added everything from this document, Document 3052888.1 but still, …
-
Employees with and without goalsSummary: Hello, I need help on this report. I need to show employees even if no goals. It used to show properly but now the report is only fetching the "with goals" stat…
-
In which page is Military Rank Lookup present?Summary: Hi, We are aware there's a Military Rank lookup as per following documentation We are able to find the lookup, and add values to it, but we do not find this fie… -
Users able to access OTBI without security rolesSummary: Users without who do not have security roles to access reports and analytics are able to bypass this by using the below URL https://FUSIONURL.COM/analytics Is t…
-
I am looking for a filter to add to a date to show values in the current financial yearSummary: I have an OTBI analysis for terminated workers and I am wanting only those terminated in the current financial year to return in a filter. how to I write and ap…
-
Competency proficiency reporting - employee and manager ratingSummary: Hi there, I need help where to find the Employee rating for Competencies. The Manager rating is located in this folder "Workforce Performance - Performance Rati…
-
OTBI missing journey tasksWhen creating an analysis to report on deferred journey tasks, I am not seeing ALL results. I am getting some, but there are definitely others that are seen in the UI, b…
-
Since redwood update in hcm the URL for reports are now not able to be shared as these get 404 errorSummary: Redwood has been updated into our production enviroment. The URL for the BIP reports, now no longer is able to be copied, shared as a link, and opened. Content …
-
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co… -
How to do grouping for data visualization in OACwe had a requirement to develop a workbook on Business unit wise Average age of employees. For that i have made a connection with Oracle Analytics and then i have create…
-
In My report have two views is Pivot table view and Table view how can we schedule both to emailSummary: Hi Team, In My report have two views that is Pivot table view and Table view how can we schedule both to email. when i tried it goes to only table view report. … -
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme…
-
Formula for Days Open in OTBI for Job RequisitionsSummary: I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get …
-
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload… -
Custom Payslip Prints Wrong AmountsHello experts! We use a custom format for our payslips. When the payslips are generated, if an employee has money going to different banks, and one prenotes and the othe…
-
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac…
-
Employee/Person Addresses not visible in per_addresses_f tableSummary: We have loaded Employee/Person Home Addresses data using HCM HDL file and the load was successful. I can see the data in the table per_person_addr_usages_f but …
-
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that…
-
Unable to bring max effective date record in a report while using an EIT flex fieldSummary: In a report with 2 subject areas, columns are not working properly. Subject Areas used: Worker Assignment Real time and Person Real time Created a report with s… -
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…
-
Can i get a list of reports from Catalog in OTBI?Summary A client has requested a report showing names and location of all reports available in OTBI (including custom reports). How can i get such a report? Content (ple…
-
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont…