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
-
Analysis or Report not returning any resultsContent I'm hoping there is something obvious I'm not doing right, but every time I try and run an Analysis or Report in BI Publisher, it returns No Results as per the s… -
Multiple lines of dependent dataSummary Report not providing latest data only but multiple lines for dependentsContent Hi, I have created a report to provide the age, disability and Student Status of c…
-
Absence plan usageContent Hi, We have an absence plan in OTBI called 'Sickness 3 Day Waiting Depot'. We are trying to get information on this plan using an OTBI analysis from the "Workfor… -
HR_ORG_UNIT_CLASSIFICATIONS_F not aligned with HR_ALL_ORGANIZATION_UNITS_FSummary Some fields are empty in HR_ORG_UNIT_CLASSIFICATIONS_F although populated in HR_ALL_ORGANIZATION_UNITS_F for some departments onlyContent We are using OTBI for s… -
Benefits Pending Action Item Report - Incorrect DataSummary I've created an OTBI to report on Pending Benefit Action Items, but it pulls in employees that have already completed them.Content I have created the attached an…User_2025-01-31-00-25-12-234 194 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Succession PlansSummary I need to report number of Plans without CandidatesContent Hello, I can see the plans without the candidates (highlighted in the attached), but once I add the Co… -
HR Help Desk - Organizational hierarchySummary Need to add "Level 3" to an exciting help desk reportContent Hello, I wonder if anyone can help me out. I need to add "Level 3" of the organizational hierarchy t…
-
Reporting in Working days when absence UOM is hoursSummary I need to know how to convert a duration from hours into days using WPContent We are on 19D and our UOM is set to hours so when i report on absence, the duration… -
Probation End DateSummary Is Probation End Date available in OTBI?Content Hi, Is the Probation End Date available in OTBI? If yes, which Subject Area is it located in? Many thanks, Andrew…User_2025-02-05-22-44-35-842 46 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Headcount in Fusion ProfileSummary Do you know what table does Headcount belong to in Fusion>Person Management>Manage Person.Content Do you know what table does Headcount belong to in Fusion>Perso… -
Looking for Subject Area to return terminated workers in AnalysisSummary Looking for assistance in locating subject area to create analysis for terminated workers in last twelve monthsContent I’m currently redeveloping our existing EB…
-
Manager Name not updating in Absence ReportSummary Manager change not reflected in reportContent Hi, I have an absence report that has a legal entity prompt that end users use that has worked perfectly fine until…User_2025-02-05-22-44-35-842 28 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
field that pulls number of direct reportsSummary I am working on a report that requires a field to pull 'Number of Direct Reports'. A non-manager would have 0 or null. Manager will pull active direct reports.Co…User_2025-02-06-07-21-22-662 64 views 4 comments 0 points Most recent by User_2025-01-28-20-36-10-715
-
OTBI Report Shared to Supervisor does not show parameterContent Hello Everyone, I have added a tab to 'My Team' to show reports to Line Managers. I have added an OTBI report to this tab using personalization. However, when ru… -
how to send the Salary Slip email PDFSummary we need to send the Salary Slip email PDFContent is there any option to send the Salary slip PDF with password protected. -
Default Cost Center in Expense AccountSummary Default Cost Center in Expense Account when entering Department information on Employee AssignmentContent Hi, we are storing Cost Center information on the Depar…
-
Employees who had their job changed?Summary OTBI report for all employees who had their job changeContent Hi Experts, Is it possible to create a report in OTBI which gives me a list of all employees who ha… -
OTBI reports not working in 20ASummary All OTBI reports are erroring out in 20AContent We recently got our test instances upgraded to 20A over the weekend and all our OTBI reports are not working. We …
-
Track hours for ACA requirementsSummary Looking to find details to track hourly employees to see if they meet hours for ACA eligibilityContent Hi all, Client is outsourcing ACA administration, however,…
-
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…
-
Returning data based on two columnsSummary Data must be returned if either of the criteria satisfiedContent HI all Any ideas how to do the above. I am working in Absence Calendar and have the start and en…
-
HR Help DeskSummary Subject area details/mappingContent Good afternoon, i was wondering if we have any supporting documents for the "New" help desk subject areas like "Service - CRM…
-
Workforce Map - ReportSummary Looking to see if the Workforce Map we use can be replicated in OTBI or BIPContent Hello We are soon to move from a partial cloud installation to a full cloud of… -
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…
-
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer… -
Changing Security on A BIP Report so that it displays whole organization data instead of just the daContent Hi All, Does anyone know the best way to modify a BIP report that's built to show manager's hierarchy view only so that the report shows full organization data? …
-
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…
-
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.
-
ORA-01489Summary error when running a reportContent Hello. I built a report in BIP where I had to concatenate columns into rows and it runs as expected. However when I try to for…
-
RetirementSummary Eligible to RetireContent To be eligible for the pension plan an employee has be to be aged 65 or meet the “magic 80” rule which is the employees’ start date + a…