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
-
Political Subdivision Code (PSD Code)Summary Resident & Work PSD Codes!!Content Hi All, I am looking for Resident PSD Code & Work PSD Code in the "Payroll - Calculation Cards Real Time" Subject Area. I am a… -
Payroll Table and Column that Holds Element Entry Override CostingSummary I need to locate this using SQL not the Subject Areas in OTBIContent I've written an SQL query to pull off the element entries and their values from the various …
-
OTBI Security - What is an Application Role?Summary Finding custom job roles for Catalog and Dashboard PermissionsContent Hello Experts! We've created some Job Roles in our organization for various purposes but th… -
Clicking on Cancel on analysis inside Infolet is navigating to Detail linked Report on Infolet. HowSummary Is there any way to control Detail Linked Report on Infolet.Content Scenarios: 1. When you click cancel on the analysis inside the infolet, while the analysis st…
-
Employee list with Performance Document status - whether document exists or notSummary I'm trying to get one consolidated current employee list with the performance document status of a particular document with one row per employee.Content Hi all, …
-
Is it possible to get detailed deduction reporting in OTBI from analysis for Involuntary DeductionsSummary Needing to know if it is possible to pull element amount (dollars) for involuntary deductions per pay period in OTBIContent Hi everyone, We are in the HCM realm … -
Expense concatenated details with worker details.Summary I am using the right SA's but when trying to Cross Getting error.Content I am including the fact column it is still getting error. The intention to cross Expense…
-
How to get Matrix Manager email by OTBISummary How to get Matrix Manager email by OTBIContent Hi Experts, we are trying to create a report that will show also Matrix manager data, so we used the Matrix manage…
-
Find who a Requisition is sitting withSummary Want a Report that shows who a recruitment requisition is sitting withContent Hello all, In Oracle Recruitment Cloud, we have recruitment requisitions. I've been…
-
Duplicate RowsSummary duplicate rows with left outer joinContent Hello. I need to build a report that returns benefit information for everyone with a column indicating if someone is o…
-
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data… -
Rating ColumnsSummary Unable to find last four columns related to ratingContent Hi All, I'm facing difficult in BI Report while fetching the values of rating columns related to Perfor… -
Benefit Leave of AbsenceSummary BI Publisher table for Benefit Leave of AbsenceContent Hello. I am building a benefits/absence report and was wondering which table holds the field Benefit Leave…
-
Does anyone have a Gender Pay Analysis?Summary Looking for a gender pay analysisContent Hello - Wondering if there is a seeded gender pay analysis report in Reporting and Analytics (OTBI) or if someone has on…
-
Security for OTBI analysis dataSummary Data access for OTBI analysis performance reportContent Hi Team, One of the user (UserA) has access to custom line manager abstract role but another user (UserB)…
-
BIP Report giving errorSummary BIP Publisher report giving error : Report data size exceeds maximum limitContent Hello, I created a BIP report with 30 columns and ~50k rows but report is showi…User_2025-02-05-07-43-29-505 46 views 11 comments 0 points Most recent by User_2025-02-05-07-43-29-505
-
Oracle HCM Client ToolSummary Can we install and configure BI client tools? if we are on cloud platform to generate a Metadata DictionaryContent Hello Everyone, We are researching on how to g…
-
Selected Performance Goals Report Not Printing Success CriteriaContent Hello - Our goal plan is no longer printing Success Criteria. We noticed that the data now sits in SUCCESS_CRITERIA_TEXT and have update our BI document but it s…
-
Questionnaire data model for checklist taskSummary data model to show questions and responses from checklist task questionnaireContent Does anyone have a data model example to share on the checklist task for the … -
Browse Catalog icon for custom roleContent I have created a custom role copying the seeded Human Resource Analysis job role. But when navigate to the report & analytics can not find the 'Browse Catalog' i… -
Section 125 Balances and Excess Taxable Wages Audit - Year EndSummary In need of a report that audits Section 125 Balances and Excess Taxable Wages.Content Hi, I am in a need of a report that audits the balances for section 125 bal…
-
SQL to find jobs with Approval rules tiedSummary SQL to run in BI to find the jobs that are tied with approval rulesContent I would like to find the list of jobs that are tied or used in the Approval workflows.… -
Password Protecting BI Publisher Reports - Password ChangingSummary BIP Scheduled reports password changingContent Hi all, I've created a few BI Publisher reports with passwords and they've worked fine on the first part of the sc…User_2025-01-31-00-25-12-234 66 views 4 comments 2 points Most recent by User_2025-01-31-17-49-32-187
-
Line Manager to access previous worker too through reports.Content Hi Experts: We have this requirement where Line Manger should be allowed to access previous worker as well through the reports, analytics on the LM dashboard. Bu… -
Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any…
-
Analysis giving female managers as a percentage of headcountSummary Analysis giving female managers as a percentage of headcountContent Hi I've written an analysis that returns the assignment headcount for female managers for my …User_2025-02-06-09-29-18-902 63 views 5 comments 0 points Most recent by User_2025-02-06-09-29-18-902
-
When joining 3 subject areas in an OTBI report, is it better to add the common columns and hide themContent A client has requested help in joining 3 subject areas in OTBI: Talent, Recruitment, and Core HR. What we did was join all 3 subjects areas with common elements … -
Setting an 'As at' prompt for assignment data in OTBISummary I would like to be able to set a prompt that will bring back all the assignment data at a given point in time.Content I have some reports of worker data (grades,…User_2025-02-05-19-30-09-308 71 views 5 comments 1 point Most recent by User_2025-02-05-19-30-09-308
-
ORA-03113: end-of-file on communication channel error - Please HelpContent Hi All, In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are faci… -
I need help with building a report on Approved Job RequisitionsContent Hi, I have a requirement of building reports on all approved job requisitions. I have tried on my own but I can't really seem to get it right. Have any of you do…User_2025-02-05-16-50-03-083 29 views 2 comments 0 points Most recent by User_2025-02-05-16-50-03-083