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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Restrict Line manager to access PII dataManagers have access to LINE manager and Hiring manager role. They are able to see PII data of their direct reports such as DOB, Address through reporting. We are planni…
-
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…
-
Absence type display feature tab attributesGood day! I need help in identifying what is/are the table source/s for the items boxed in red below… it is in the Display Features tab in Absence Type: TIA.
-
Which table stores the data from plans and plan types tab?Hi Team, I am trying to fetch the data from plans and plan types tab which is under below navigation: Benefits Administration > Plan Configuration > Program Name > Basic…
-
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? PFA. Thanks,…
-
Issue in pulling candidates latest hire date in BI/OTBI reportSummary: Hello experts, We are trying to pull candidate details along with hire date. For one of the candidate we have updated the start date and when trying to fetch th…
-
User Last Login Date ReportSummary Need to report on User Last Login DateContent Hi All, I am looking for a way on how can I report for User Last Login Date using BI Publisher. I tried using the F…
-
hcm infoletSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
how can we add two subject areas worker assignment and ORC subject area for candidate numberSummary: Hi Team, we need candidate number from ORC subject area source real time and worker assignment real time . Thanks, Ajay Content (please ensure you mask any conf…
-
EU Pay transparancySummary: We looking for a report to analyze the pay transparance between genders as requested by EU. Has anyone seen or created a report showing variances in payment per…
-
BI Reports are not displaying to tag them in Link or Image section in DashboardSummary: Hi Team, We are creating the Dashboard. Unfortunately, we were encountering that BI reports are not showing to add them in the Link or Image sections in the das…
-
How to Retrieve Level 2 Manager's Designation in OTBI ReportSummary: I need to pull the designation of a level 2 manager using OTBI in Oracle Fusion. Looking for guidance on how to achieve this. Content (please ensure you mask an…
-
Building Scalable Payroll Balance Reports in OTBISummary This document provides guidance to OTBI report developers on how to build scalable reports for reporting on Fusion Payroll balances.
-
sql statement to get the performance document current taskSummary sql statement to get the performance document current taskContent Can anyone help me on how to fetch the current task for the employee performance document , the…
-
Query to get Questionnaire answers given by user and right oneContent Hello experts. I need a report for learning assessments. This report is to get the learning item - task assesmment - questionnaire - answer - right answer (based…
-
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…
-
Exclude 'Days Suspended' in Recruiting Dashboard Time to Hire data?Summary: Exclude days suspended in Recruiting Dashboard 'time to hire' metrics Content (please ensure you mask any confidential information): Our client wishes to exclud…
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')
-
SQL to get Cost center mapped to countrySummary: Hello Everyone, I just want to ask for SQL on how to get the cost center who are mapped to country. Thanks,
-
Contract duration is displaying no data on FAWHi, I've been trying to create a simple report to show the contract duration of the new hires in a company for a specific month. My reports should look like that where T…
-
Unable to get required currency format in Excel outputSummary: this is the tag we are using to get amount column in US format. we are able to get it in PDF output but not in excel. Content (please ensure you mask any confi…
-
Getting "The file uploaded may contain a virus or otherwise failed to be scanned for viruses."Summary: While trying to load the company logo image on an OTBI Report, i am getting the following error. "The file uploaded may contain a virus or otherwise failed to b…
-
How to retrieve timestamp when candidate submits RMI applicationSummary: Content (please ensure you mask any confidential information): Working to troubleshoot CSP automation and I am looking for a timestamp for when candidates submi…
-
SQL to fetch the history ratings from talent profilesSummary: Hi, Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation: Me>career and performance>skills and qualifica…
-
How to suppress aggregated column in order not to repeat its values for every rowsSummary: Suppress aggregated column value Content (please ensure you mask any confidential information): Is it possible to suppress the value of aggregated column in ord…
-
how to use get_variable in IF condition in RTF templateHi Team, We have a requirement to display the data in report based on net sal, to get this done we are using below tag in RTF template and its not working, we tried diff…
-
Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…
-
OTBI report should drill to show the courses that are part of the specialisation.Hi, We need assistance with an OTBI analysis where clicking on a specific specialization should redirect to another analysis that displays the courses included in that s…
-
Join in OTBI is not removing data where joining two subject areas.Summary: When joining two subject area's the data is not removing information in one of the subject areas. Content (please ensure you mask any confidential information):…
-
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…