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.
Get Started with Redwood: Oracle Cloud SCM and Purchasing
Reporting and Analytics for HCM
Discussion List
-
Report to pull all Payroll balances to move from one TRU to anotherSummary: Does anyone have a report they have used in the past to pull all balances for an employee, in order to do balances adjustments due to incorrect TRU? Content (pl… -
Query to fetch absence plan balance history detailsHi Experts, Greetings of the day!! We have a requirement to get all the absence plan balance history details. We need all individual entries like Periodic accrual, Carry…
-
Reporting on assessment attempt scores when there's more than one assessment in the offeringSummary: I need to report on the score achieved for each attempt within an assessment however I find that if an offering contains more than one assessment activity, the …
-
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share? -
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were… -
How does the per_person_names_f_ audit table get populated?Summary: I am creating a report to audit name changes in our system. This is so we can see where corrections happened, deletions etc. I have been using the per_person_na…
-
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie… -
Display a Document of Records Image in a BIP ReportHi all, My customer has a requirement where they need to see a report that includes a Document of Record image (passport photo) in a BIP RTF report. Has anyone managed t…
-
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…
-
Add custom logo in a Workflow NotificationHi, I customize the RTF of CmpWkstApproval Notification. I add an image in the RTF, the image is visible when i run the report but the image is not visible when the noti…
-
can't find element group (object group) in payrollHello, I'm trying this query to get the employees who are included in an element group (object group) but it didn't results in anything SELECT distinct person_number,per…
-
How attach more than one PDF file into an alert custom (e-mail)Summary: How attach more than one ".PDF" files into an alert custom (e-mail) Content (please ensure you mask any confidential information): Hi to all, our client asked u…
-
BI Publisher - RTF Template - FontSummary: Hi Everyone, I am developing the Offer Letter and Employment Agreement for my client using BI Publisher. Since they are using numbering, and under the original …
-
What is the relationship between hrc_txn_header and gl tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe…
-
Employees with Manager Change can be viewed in OTBI by the old manager?Summary: OTBI report with the following info: Employees info + performance ratings + worksheet manager name info. This report has been delivered to managers. If an emplo… -
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo…
-
Query for State Tax Withholding details for all statesSummary: Hello! I am looking for the BI query for State Tax Withholding. Thank you in advance! Content (please ensure you mask any confidential information): Version (in…
-
Is there a standard report in Oracle HCM Cloud Recruiting that calculates the 'Time to Fill' KPI?"Summary: Content (please ensure you mask any confidential information): Hello team, I'm trying to determine whether there's a standard report in Oracle HCM Cloud Recruit…
-
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…
-
Supplier Portal InquirySummary: Looking to create an Inquiry Only Supplier Portal role to support supplier portal vendors requiring inquiry to their Invoices, Payments, PO and Supplier profile…
-
FTE in Compensation Subject Area is not correctSummary FTE value is showing 5 instead of 1Content Hi All, I need your help. I am getting two different values for FTE in OTBI. One comes from Compensation Subject Area … -
How to display Name given Person Number.Summary: We have a DFF tied to Department that has the Person Number of the Executive overseeing the department. The name of the executive (not just Person Number) is of…
-
How to identify Overdue Onboarding TasksSummary: I'm writing an analyses using the subject area Workforce Management - Checklist Real Time. I can see tasks that are incomplete, but I need to report only on tas…
-
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 …
-
How do we get the Pay Period Month , Year , Max Gross Pay MTD in OTBISummary: 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 to insert an report dashbaord on a redwood page?How to include or embed an OTBI report/dashboard on a Redwood page -
Is There a Delivered Bonus Statement Feature in Oracle Incentive Compensation?Summary: Is there a similar feature or functionality in Oracle Incentive Compensation for generating a Bonus Details Statement? Currently, we are using a BI Publisher (B…
-
How to load employee into object group through HDLSummary: Client is asking bulk load of employee into payroll object Group any HDL simple .dat file Content (please ensure you mask any confidential information): Version…
-
Is there a way to limit access to the worker assignment real time subject area?Summary: Hello, We have a "Learning Course Owner View All" data role that is essentially a learning admin. They have access to view all learning data including courses, …
-
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…