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
-
How to center align a custom bip notification with an rtf templateHello, Can anyone tell if there is a possible solution to center align a custom bip notification in the user's end. We are using an RTF template. While viewing it on the… -
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
Is it possible to generate a txt file in UNIX format?Summary: I need to export a txt file from BI Publisher and currently it has the Windows format. I need the file to be in Unix format. How can I do? Content (please ensur… -
get sickness plan entitlement values 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…
-
"Last Logged on" Audit clarificationContent (please ensure you mask any confidential information): Summary: Wanting to understand where the "last logged on" value is derived from in the audit tables. For e… -
How to add manager’s manager in OTBIWorking on a requirement to setup a report for any managers with incomplete performance documents. Eventually this will be sent as an alert to the manager and the 2nd le… -
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th…
-
Cannot get specific element entry values from XML data cache column for pending transactionSummary: We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entrie…
-
Tracking Timely TerminationsHi Does anyone have or is aware of a report or dashboard that tracks the termination submitted for processing? We are having issues with overpayments to employees have s… -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…
-
vacation plan accrual balanceHi Team, Please find the attached screenshot below. I’m looking for the balance days of the Accrual Plan Balance in the Vacation Plan. Could anyone please let me know th…
-
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En…
-
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…
-
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…
-
Address Change Notification Not Reflecting the Changes in the NotificationSummary: New fields have been added to the Address Change Report (Report Name: PersonalInformation_AddressReport). While the changes are being pulled into the report cor…
-
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?Hi everyone, I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to b…
-
Which Subject Area holds Management Level, Retention Risk, Vacancy Risk and MobilitySummary: I'm trying to create a Talent report, but unable to find few attributes in any Subject Area, and those attributes are Management Level, Retention Risk, Vacancy …
-
need Sql Query of the balances with the below shown fieldsneed the SQl query which as fields like FIT Reduced subject witholdable FEDERAL TAX MARITAL STATUS FEDERAL NUMBER OF EXEMPTIONS STATE JURISDICTION INDICATOR YTD STATE TA…
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…
-
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable… -
query for exit and entry dates of positions occupied by each employe that applied for a requisitionSummary: Hi all , I came across a requirement : to pull the position entry and exit dates in the date range of application submission date of all the persons who applied…
-
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat…
-
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…
-
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…
-
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…