Get Started with Redwood for Oracle Cloud HCM Begin Now
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 combine one Finance subject area and also HCM subject area in a single OTBI reportSummary: Is it possible to combine one Finance related subject area and one HCM related subject area in a single OTBI report. Content (please ensure you mask any confide…
-
Detail of oracle delivered standard reportsSummary: Need details of Oracle delivered standard reports Content (please ensure you mask any confidential information): We have a list of oracle provided standard repo…
-
Veteran Self-Identification Status - no results in OTBI Person Real Time SA **Updated**Summary: I have the 'Veteran Self-Identification Status' along with the other Veteran statuses in multiple analyses and dashboards. Recently, sometime after 8/15/2024, t…
-
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…
-
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a…
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…
-
How can i get absences in BIP Report that where approved and then withdrawn/deleted .Summary: Hi, Please suggest tables that stores absences that where approved and then withdrawn , are there any transaction table that stores the data or absence events t…
-
Loading Job Requisitions via HDL - What table is collaborators held in?Summary: I'm loading Job Requisition from one Oracle environment to another and I'm having trouble finding the table where Collaborators sit. Please advise. Thanks! Cont…
-
SQL query to fetch Division, BU and Department namesSummary: Hi Team, We have created a SQL query to fetch Inactive employees AOR. We would like to fetch division name, Department name and Business unit name also in the s…
-
OTBI : How to customize the seeded OTBI dashboard and analysis used in the dashboardSummary: Hi All, I have to customize the line manager dashboard -> Absence (tab). When I click on edit dashboard -> edit the analysis, I can see the analysis. But I want…
-
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am…
-
How to run report to pull specializations and courses on a single report?Summary: I need to run a report with all specializations with the courses in the specializations with course sequencing position. I don't need any user information, just…
-
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…
-
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…
-
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…
-
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in…
-
Generate Payslip - Archive Information and Generate Report ErrorSummary: When i ran Generate Payslip, The Archive Information and Generate Report log status are Error. Content (please ensure you mask any confidential information): I …
-
How do I report on only the most recent assignment (active or terminated)?Summary I need to build a report of all employees and only want the most recent assignment to appear on my report.Content Hi all, Does anyone know how to report on all t…
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…
-
Export Element RatesSummary Need to pull element rates out of HCM/PayrollContent Has anyone been successful in pulling element rates out of HCM/Payroll? By Element Rates, I am not referring…
-
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Primary key PVO legal entity / legal entity registration numberHi, Can I join these 2 tables using the 2 primary keys ? Will my legal entities match the registration number in a report ? Regards, Lauriane
-
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th…
-
User Role Audit ReportSummary: User Role Audit Report - We want to see when changes were made, who made the changes, what change was made, what role to user is added or removed Content (requi…
-
Assignment Manager (Unsecured) Dimenssion in Goals Real Time SASummary Data Role Data security not working in OTBI, when using the Assignment Manager (Unsecured) Dimmension in goals Subject areaContent Hi Team, We are using the Dime…User_2025-01-23-22-36-48-692 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
How to alignment of text in TCS statement ?Summary: The text alignment in columns of TCS reports is inconsistent, with some columns using left alignment and others using right alignment. However, the alignment of…
-
Misalignment Candidate selection process phase and state between OTBI and UISummary: Content (required): Hello Guys, We would create a report that show for each Candidate selection process Phases and States the correct number of application. By …
-
Table name to check Password Expiration Date of userSummary Table name to check Password Expiration Date of userContent Hi All, Can any one please help me to find the table name where i can get password expiration date of…