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
-
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu… -
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Best Practices: OTBI Compensation - Compensation Stock Details Real Time subject areaSummary: This is part of a series for best practice tips to use in your cloud environments, created by Oracle BI and Product Management. Roles and Privileges Compensatio… -
Can report schedule can trigger notifications based on the notifications triggered in last 24hours.Summary: We have a requirement, where 2 reports are developed. And the first report is triggered manually and for the second report scheduling is required. Is there any …
-
Cost of absence sicknesSummary: Report to show cost($ amount) of employee leave balances Content (please ensure you mask any confidential information): Hi Team, We have developed a report for …
-
FDI format date field to MON-YYHello, In FDI I'm trying to format payroll action effective date as a period format 'MON-yy'. TO_CHAR is not a recognized function, I tried a CASE statement for WHEN Pay…
-
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… -
Is there a SQL query that will show when last a BI Report has been run by a user?Summary Is there a SQL query that will show when last a BI Report has been run by a user?Content Hello Is there a SQL query that will show when last a BI Report has been… -
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …
-
To report performance document status related information and rating detailsSummary To report performance document status related information and rating detailsContent Hi , Planning to build a report to show performance document status of a pers…
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…
-
PDF available for Tables and Views for HCMSummary: Is PDF option available for Table and Views i see there is no option to download. Tables and Views for HCM Content (please ensure you mask any confidential info… -
Query to extract Journey ID, Journey Name and task IDSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a query retrieving all Journey details loaded at the employee level? T… -
How to use "Combine results based on union, intersection, and difference operations?Summary: I don't understand how to use it. Whenever I add my 2 subject areas and then the fields, I don't know what to do after that. I need additional fields that are n…
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o… -
Annualized Full-Time Salary the same value as Annualized Salary for those with <1.0 FTESummary: Within the Compensation - Salary Details Real Time there is an option to pull in both the Annualized Salary and Annualized Full-Time Salary. When checking this …
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…
-
Absence DFFSummary: Dear All, I have created global DFF in the absence page and I want to show them in the analysis report for, I already use ( Workforce Management - Absence Real … -
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
Need to get distribution curve to work when count is 0I am trying to create a distribution curve for performance ratings. It looks good when there is a count >0 for each rating but when there is a 0 count for Unsatisfactory…
-
Where can I find the Specialization Description to add to my Specialization_Courses report?I can't find the description field to add to my report using the subject area Learning Records Real Time. Is this field in another subject area? Specialization Descripti…
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…
-
How to Output a Table Entered in HTML Format in a Document Using BIPSummary: I am creating a document using BIP. I want to output table data entered in HTML format. I would like to confirm the following two points: What kind of SQL state…
-
How to fetch the Initials of the employee using OTBI?How to fetch the Initials of the employee using OTBI?
-
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…
-
Consolidated List of OTBI and BI Publisher Reports Posted (9 December 2014)Content The following is the list of published OTBI and BI Publisher reports between 15 October 2014 and 9 December 2014: * Fusion Benefits: Dashboard for Costs and Tota… -
How to customize seeded Payment Register ReportSummary: How to customize seeded Payment Register Report Content (please ensure you mask any confidential information): Hi All, We got a requirement to add new columns i…
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).
-
OTBI Analysis - How do you select the gross earnings for the max Date Paid per employee?Summary: We are able to get a list of gross earnings for each worker per pay date but we only want to SELECT the gross earnings associated with the max check date (Date …
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…