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
-
In which table is the issued by field for license and certificate for talent profileSummary issued by field for license and certificateContent In which table I can see the full entry for issued by field for license and certificate ? I can only see the a… -
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere… -
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h… -
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …
-
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…
-
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro… -
Individual prompts for two analysis on a dashboardContent Hello, I've been working on a dashboard where we need to have two analysis. There is one column which I wanted to use as prompt individually for each analysis. I…
-
FPPA ReportSummary FPPA ReportContent Does anyone have an FPPA report in BI that they would be willing to share? We are new to Oracle and struggling with Reports. -
Calculating Difference from Headcount factContent I am trying to calculate difference between Headcount (Fact from Assignment Real Time) by work location and the number of employees that uploaded a document type…
-
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
OTBI Analysis with EIT fieldsSummary Need to display current Parent Position Code for the record but EIT causing duplicationContent HI all, I need some help with an Analysis - I have paired the anal…User_2025-02-04-08-51-08-912 151 views 4 comments 0 points Most recent by User_2025-02-04-08-51-08-912
-
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp…
-
Out of control sessions since upgradeSummary SessionsContent We're mid-upgrade and while investigating performance in reporting I noticed that we have an unreasonable amount of active sessions. We have +400… -
Trend Lines in OTBI ChartsContent Hello, Is it possible to add trend lines to an OTBI bar graph? We are creating a dashboard for HRHD and want to add a trend line on top for number of cases. I've…User_2025-01-31-00-25-12-234 84 views 10 comments 1 point Most recent by User_2025-01-31-00-25-12-234
-
Requisition HistoryContent Hi, does anyone know how I can create a report which shows the history of a recruitment requisition? Currently I can only successfully make one which looks at th…
-
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!
-
Help required to find the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS to use in extractContent Can anyone please tell me what is the User Entity for the table ANC_PER_ACRL_ENTRY_DTLS so that i could use the columns in extracts. Version Oracle Cloud Applica…
-
ORC Candidate Diversity - SummarySummary Getting to one row per job requisition?Content I've created an analysis that uses the delivered counts of applications, veterans, gender, and disability status t…User_2025-02-10-15-34-12-310 146 views 2 comments 0 points Most recent by User_2025-02-10-15-34-12-310
-
Adding Action link on Performance Document Created vs Not createdSummary Adding Action link on Performance Document Created vs Not created Content Hi, We have requirement to add an action link and display the employee populations in t… -
How to calculate time from different eventsSummary Calculate time difference between different phases (events) in a recruitment processContent Hi, I´m trying to create a report where I can report on the different… -
Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusSummary Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusContent Hi, Our scheduled BIP reports are stuck on "Waiting" or "Running" status, even the one…
-
Report on Transactions that failed in BPMSummary Report on Transactions that failed in BPMContent Hi Has anyone worked on creating reports based on BPM tables. I have requirement to fetch the failed termination…User_2025-01-30-21-52-52-008 130 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle
-
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 110 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534
-
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805
-
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…
-
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805
-
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…
-
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the … -
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac…
-
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a…