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
-
We need OTBI column name in Absence as per below image to get leave applied dateSummary: We need OTBI column name in Absence as per below image Type is Adjustment. Content (please ensure you mask any confidential information): Version (include the v… -
element entry secured views queryIs there a query that contains a table to be used to get only the secured list element entries based on the element security profile. Similar to the table per_person_sec… -
How to change the Query Time Out value in BI Published reportHi, How do we change the "Query Time Out" value in BI Published report It is available in Properties of the report data model , however maximum limit is 180000 and if i … -
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…
-
SQL to get Org Pay Method of PersonSummary: SQL to get Person Org Payment Method Content (please ensure you mask any confidential information): pay_org_pay_methods_f record holds the BASE_ORG_PAY_METHOD_N…
-
which table stores area of Expertise and Area of Interest in Talent ProfilHello, I would like to know which table stores Area of Expertise and Area of Interest in Public Info in Talent Profile page. Attaching the screenshot for reference. Rega…
-
Version controlSummary Version control for OTBIContent Is there any preferred version control software for OTBI and BI Publisher code? Thanks -
Need table name for Business Object Type and its associated actionsSummary: Need table name for Business Object Type and its associated actions, as we are working on deep link for Job Requisitions page. So we are searching for actions u…
-
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…
-
Does anyone have a report for page field labels in different languages?Requirement is, to provide for business user review, a list of field labels by page, and their translated labels, for each language pack in scope. Does anyone have a rep…
-
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 ? https://us.v…
-
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…
-
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…
-
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 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…
-
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…