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
-
Conditional Logic in RTFSummary Conditional If-Then-Else and Looping logic in RTF TemplateContent Hi All, I am trying to add conditional logic, specifically using If-Then-Else statements, in an… -
BIP Data Sources accessSummary BIP Data Sources accessContent Hi Experts, Does anybody know if it is possible to restrict access to the Data Sources in the BIP data model UI? I appreciate any … -
Employees with Leave Status within a Specific MonthSummary Employees with Leave Status within a Specific MonthContent We are tracking leaves through Manage Employment using Action and Assignment Status. Our HRBPs would l… -
Audit DahsboardSummary Need help finding Audit DashboardContent I remember seeing Audit Dashboard. I can't seem to find it. Does anyone know is there a Oracle delivered Audit Dashboard…
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el… -
Department HierarchyContent Hi all - I have a great report that we use for Department Hierarchy through OTBI, but we need this report through BIP. We have users that will pull this data the… -
Compensation Components table for BIContent Hello experts, do you know the Oracle tables to extract compensation components values and components name? Thanks in advance for your time! Kind Regards, Valerio -
Requisitions with Inactive ManagersSummary Is there a report showing requisitions with inactive managers?Content Hi all, I am developing a report to identify requisitions with inactive managers, so that w… -
Payroll-Calculation Cards Real Time OTBI SA issueSummary Payroll-Calculation Cards Real Time OTBI SA issueContent HI, We have a issue with "Payroll-Calculation Cards Real Time" SA. I am picking the Calculation Card :'S… -
SQL Expression on column filter in OTBI reportContent Created a headcount report and looking for a SQL Expression for a column filter so I can generate the report based on current or system date employee start dates… -
Table(s) that store Persons Language, Degree, Prior Work Experience, Licenses/Certificate InformatioSummary Looking for the hcm tables that store Person info such as Language, Degrees, Prior Experience, LicensesContent Hi, We want to create data model(s) to pull the Pe…
-
Hours worked counted by Calendar Weeks LogicSummary Need help with logic to count hours worked based on calendar weeks worked for 401K vendorContent Hi Friends, We have a requirement where our 401K plan requires h… -
Query to fetch BIP report job historySummary Query to fetch BIP report job historyContent Hi Team, Is there any query from table to fetch the BIP report Job History. Thanks, Sourav
-
How to Add Sorting to Bar Graph ResultsContent When I create a bar graph using "Facts - Requisition Counts"."Number of Job Requisitions Currently Open" by "Job Requisition - Hiring Team"."Recruiter Full Name"… -
Document Delivery Prefrences User Entity DetailsSummary Document Delivery Prefrences User Entity DetailsContent hello Everyone, Do we have user entiry for person document delivery prefrence details. Thanks, Rasu P
-
HCM Quarterly Changes Impact on Reporting and AnalyticsSummary HCM Quarterly Changes Impact on Reporting and AnalyticsContent Hi all, Is there any other references for Quarterly changes on HCM that affects reporting? I have …
-
Manager name from Assignment Manager (Unsecured) does not work with event countsContent When I add Manager name from Assignment Manager (Unsecured), the hire/ termination count reduces significantly. How does the Assignment Manager (Unsecured) work?…User_2025-02-10-08-27-16-805 47 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Drill down and action link opening an email to the user - OLCContent Hi there, I have a table with users' names or email addresses. Can I add an action link with a drill down that will open an email to the user? Thanks Bobby -
How to sort Age BinsSummary Sorting Age Bins in a ChartContent Hello, I am trying to get my Age Bands to sort in numeric order but the Bin Labels with text keep defaulting to the end of the… -
Current status is "Interim"Summary Trying to report on all employees who are an interim assignmentContent I'm trying to report on all employees who are currently on an "Interim". Using the HR Acti…
-
Tracking new line managersSummary Identify line managers who have managed employees less than a yearContent Is there a way to identify line managers who have managed employees less than a year? W… -
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…
-
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…
-
How to mask data values?Summary In OTBI, how to display an * instead of a number or percentage where the results might identify peopleContent In OTBI I would like to mask identifiable data such…
-
Nee a delivered report path that triggers approval notification email for time and labor module.Summary Nee a delivered report path that triggers approval notification email for time and labor module.
-
Report Job History Page in OTBI IssueSummary Report Job History Page in OTBI Issue is BlankContent Is anyone else experiencing an issue accessing the Report Job History Page? I assume a browser issue, but h… -
OTBI Dashboard Layout for SectionsContent I have created a dashboard with two sections, one of the sections I need the two analysis to render side by side (horizontal) rather than vertical. However when …
-
List of all Scheduled BIP ReportsSummary List of all Scheduled BIP ReportsContent Hi Team Is it possible to extract the list of all scheduled BIP reports along with owner and schedule frequency? Which t… -
Need SQL query to fetch Balance Initialization/Balance AdjustmentContent Hi All, We are looking SQL query to fetch the Balance Initialization/Balance adjustment data. Please share SQL query if anyone is having in handy. Thanks, Visu
-
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …