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
-
Grade Legislative Information not available in OTBISummary: Grade Legislative Information not available in OTBI Content (please ensure you mask any confidential information): Hi All, We want to pull out the Grade Legisla… -
How to schedule an agent to run only if new / upcoming terminations are enteredSummary: Hello, I'm working on a push report for our security operations team who wants to be notified of upcoming terminations entered into the system. Unsure how to pr… -
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
Need an help for SQL querySummary: Content (please ensure you mask any confidential information): I want to extract report for Manage Legal Reporting Unit Registrations, however I have a SQL whic…
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a… -
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear…
-
How to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: First, I apologize, as I am not a reporting guru like you all so this question may seem rudimentary! I am the main administrator for our HCM Learning app. I oft… -
How can I see all chart types in Fusion Data Intelligence (FDI)?Summary: How can I see all chart types in Fusion Data Intelligence (FDI)? Content (please ensure you mask any confidential information): I need to know what kind of char… -
Oracle FDI initial configuration guideSummary: Oracle FDI initial configuration guide Content (please ensure you mask any confidential information): We are trying to setup a brand new FDI environment. Does e…
-
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI…
-
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.… -
Assigning HR AOR Roles Changed ReportingSummary: We are moving our HR Specialists to AOR Roles, based on Location. And in testing this in our lower instances, everything on the screens is working as expected. …
-
Employee job levelsSummary: Adding job level to employee report Content (please ensure you mask any confidential information): We have a requirement to show the employee job levels. When I…
-
Subject Area -- Custom Column Formula IssueWe have an analysis built off of "Workforce Management - Accrual Real Time" joined to "Workforce Management - Work Relationship Real Time." Results return on a data tabl…
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_… -
Are there subject areas for Connections Reporting?Summary: We'd like to report on activity and user participation in the Connections feature. Are there subject areas available for analysis reports? Content (required): W… -
OTBI Report Perfomance issue when I apply the 7 countries in promptSummary: Hi All, We have OTBI report but in report Perfomance issue when I apply the 7 countries only but if i apply one country working fine in prompt . needs all the d… -
OTBI Absence reportSummary: I have created a OTBI report to pull absence details and it has parameter of two dates start date between. Client is passing the dates of 1st of Aug to 30th Aug… -
Can someone help me how to apply Pivot in my OTBI Analysis?Summary: There are multiple values per employee. I want it to display in a single row, but one per column. Is it possible? Your help is so much appreciated. Content (req…
-
The journey report also tracks journeys that have not startedSummary: Hi experts, The journey report has tracked journeys that have not been started Hi experts, The journey report has tracked journeys that have not been started, i… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check… -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
How to get Consolidated output using Bursting data modelSummary: Hi Team, I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule…
-
Sql Table to get the details of BIP Data model QueryContent Hi, Is there any database tables available to fetch the details(Query) used in a BIP Report. We would like to see the list of reports using a particular field sa… -
How to control the font size in TCS ?How to control the font size in TCS? The font size for the Total value in TCS is smaller than the font size used for tabular data.