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 Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information… -
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are… -
Requisition: Is it possible to create a report to see who deleted a candidate from a requisition?Hello, Is it possible to create a report/analysis to see who deleted a candidate from a requisition? If so, could you please tell me how? I am not so familiar yet with O… -
Calculated Eligibility fieldSummary: Hello, We're trying to extract the Calculated Eligibilty column in SQL, as we need to know the value if it's Forced Eligible or Eligible. However, we cannot fin…
-
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…
-
OTBI Analysis with 2 subject areasI am trying to use Workforce Mgmt Person Seniority SA + Workforce Mgmt Worker Assignment. I need person number, seniority date, but in worker assignment, we have DFFs so…
-
Learning Items for Pending WorkersSummary: Unable to pull Pending Worker information from Learning Records Real Time DM and Assingment Real Time DM Content (please ensure you mask any confidential inform…
-
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…
-
Not enrolled in Waive but showing on OTBI report, along with standard enrollmentIn OTBI using Benefits - Enrollments Real Time, we are getting 2 records on some employees - 1 enrollment in Waive and 1 enrollment in Medical. They are only enrolled in…
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi… -
How can I activate audit trial on PER_CONTACT_RELSHIPS_F tableSummary: How can I activate audit trial on PER_CONTACT_RELSHIPS_F table Content (please ensure you mask any confidential information): Version (include the version you a…
-
Specialization Completion PercentageSummary: I am looking to build an OTBI report that lists by associate an enrolled learning specialization and a summary count of the number of the courses in the special… -
OTBI > Permissions > HR Specialist cannot open DashboardContent Hello All, I will appreciate your support on the issue below: The HR Specialist with Data Role “AUIB Human Resource Specialist” cannot open the Dashboard (File “…
-
Creating a report from BI Workflow Correction Notification in HCMSummary: A client is looking to create a report of all of the correction notifications they receive in order to better analyze the data. Is this possible? Ex. Correction…
-
Moved: Locked Goals IssueThis discussion has been moved. -
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
What is the Subject Area for News and Announcements (which are displayed on the user home page)?Summary: We have a requirement to show employee announcements in an OTBI dashboard, so we want to know the subject area for the same. Content (required): Subject Area fo…
-
HR is unable to view own record on 1 Report in OTBISummary: Hi Team, Our HR Team has raised a concerned wherein they are unable to access/ view their own data (means the one who's extracting the report) in 1 of our repor…
-
Moved: Trying to invoke candidate attachment REST API through PL SQL procedure giving errorThis discussion has been moved.
-
Need example for Bursting Query in case of Multiple data setsContent Hi, Can anyone explain how to write Bursting query in case of Multiple Data Sets? Thanks in advance. Jyoti -
Need help on the Attrition % formulaSummary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…
-
HCM Extract by Business UnitSummary: I'm looking to filter multiple HCM Extracts by Business Unit ID. I seen there was a similar ask in 2017. I'm looking to do the fast formula route, as I presume …
-
Where can we report on Employee's LDAP Manager?Summary: We need to write a report where we can pull the Employee Manager data stored in LDAP. Content (please ensure you mask any confidential information): We need to … -
New DFF in termination do we need to refresh the data connection to see this in FAWSummary: We have a new DFF in termination under PER_PPS_DF do we need to refresh the workforce management data pipe to see the new DFF in FAW? Content (please ensure you…
-
global transfers reportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Use Case and …
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
Need a query that combines both termination transaction details with the employee details.Hi I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for … -
Issue getting most recent/max date for "Offer Extended" Recruiting EventSummary I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows retu…
-
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal…