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
-
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 21 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 161 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 132 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 26 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… -
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…
-
Report on Performance Document AcknowledgmentSummary Is there a table or Subject area to report on employee acknowledgement?Content Is there a table or Subject area to report on employee acknowledgement? We need a …
-
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio…
-
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti… -
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…