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
-
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an… -
Rcount sort orderSummary: I need to know what controls the sort order for the RCount function. I have a requirement to select one assignment per person from worker assignment real time S…
-
Issue while adding prompts to a pivot view of an OTBISummary: Not able to add and apply prompts to pivot view of an OTBI analysis Content (please ensure you mask any confidential information): The requirement I have is to …
-
Payroll Relationship - Element Duration Dates - Final Close DateContent Hello, We're keen to build a report that shows the final close date using OTBIEE Answers (subject areas), however when included this appears to be on the relatio… -
Unable to acheive trend analysis using prompt for accounting year in OTBISummary: Unable to use Time series formulae in OTBI to fetch YTD data for past 5 years/ for 5 years based on prompt Content (please ensure you mask any confidential info… -
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…
-
Variable Prompt not filtering Analysis.I am trying to create a prompt for an analysis in OTBI. This analysis was created using Logical SQL. When I created a column prompt, I got the error - "Failed to Load(Od… -
-
Field names are changed after moving the modified OTBI report to new podHello, Context: There is an existing OTBI report. We have created a few EFFs and included all those EFFs in OTBI report. We are able to run and view the expected results…
-
Job Offer Letter Template LimitSummary: Content (please ensure you mask any confidential information): Hello, My TA team was curious if there is a limit on the total number of Job Offer Letter Templat… -
Payroll Element Entries Real TimeSummary Results not displayed after adding worker details in the reportContent Hi All, I am trying to pull employee element entry details. For that, I am using Payroll E… -
How can I combine termination count and hire count in one analysisSummary: I have attached two different analysis One is showing hire count and other termination count But the requirement is that I need to have both the columns in the …
-
HOw to add a today's date for OTBIHow to add the today's date as one column in the OTBI report. Can this be possible
-
We are looking for options to connect to the HCM database from external application eg. ExcelSummary: We are looking for options to connect to the HCM database to pull employee and org data to simplify some of the processes for our HR. Content (please ensure you…
-
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD…
-
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working for Recruiting - Recruiting RealtimeSummary: For my OTBI analysis, I applied the prefix mentioned in the documentation for the Recruiting - Recruiting Real Time subject area under the Time Reporting headin… -
Move to HR blank in analysisSummary: Move to HR blank in analysis Content (please ensure you mask any confidential information): Hello experts, we are creating a custom OTBI analysis where we need … -
How to fetch latest record in OTBI ReportSummary: Hello All, I am developing an OTBI report to fetch Person's Skills and development data. For this, i have used 'Workforce Management - Person Profile Real Time'…
-
DFF in termination under PER_PPS_DF which subject area can we report from?Summary: We have added a DFF to termination under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from? Content (please ensure y…
-
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e… -
Error Codes: EKMT3FK5 Limitation of Pivot table in OTBISummary: I pivot 'Balance Name' (around 70 columns) and get this error message if I output too many records, I'm wondering how can I increase this limitation number for …
-
Payroll HCM - What tables would show historic scale points and hourly rates for that scale point.Hi , I'm currently looking into a request from one of my colleagues asking if it's possible to have our Holiday Accrual report have the Hourly rate reflect March 2024 pa…
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea… -
Benefit Participant Eligibility Employment Assignment Category TableHi, We are trying to create a report to fetch Participant Eligibility information. But not able to figure out the Employment Assignment Category information. Can anybody…
-
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
How to pass NULL and All column values prompt values in logical sqlSummary: Hi, I have created a dashboard prompt but when I am passing values as NULL and All Column values in prompt analysis is showing no result. I have created analysi…
-
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …
-
Globally Change User Timezone Preference in OTBISummary Is there a way to globally change users' timezone preference in OTBI?Content Hi! I am wondering if anyone knows if there is a way to globally change the OTBI tim… -
Chage Default Timezone for a Time columnSummary: There is a need to change the timezone of a time column in one of the OTBI analysis to reflect UK timezone. Currently it has default UTC timezone. Content (requ…