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
-
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…
-
How to provide the secure access to folder using custom role to employeeSummary How to provide the secure access to folder using custom role to employeeContent Hi Expert, Want to provide the report folder access to the set of employee who is…
-
Which table stores the Manage Set Assignments detailsSummary Which table stores the Manage Set Assignments detailsContent Hi Team, Can some one point me to the table which stores the Manage Set Assignments details. Go to M…
-
Issue with Annualized Salary in OTBISummary Anunaluzed Salary not showing up in OTBI analysisContent Hi - We are in the process of building/moving our BIP reports to analysis but have been encountering iss…
-
I can't see any secured reportsContent Hello Guys,The technical department has secured the reports in BI. My users cannot view the reports anymore, it seems as if they no longer exist. Is there any ro… -
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 98 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Improvement Ideas for BI Catalog UI / NavigationSummary BI Catalog UI ImprovementsContent Hi All, We at DHL are using HCM for few years already and we are looking to further exploit our data to provide intelligence an… -
Create a report for Areas of ResponsabilitiesContent Hi Guys, I need to realize a Report in order to extract: Person ID, Employee Name, Area Of Responsibility Name , Responsibility Type and Scope Of Responsibility.…
-
how do i pass HR assignement no to balance feed querySummary how do i pass HR assignement no to balance feed queryContent Hi Members, I need a help. There is an employee having two assignment no at the same legal entity. I…
-
Adding metadata to PDF output generated through BIP burstingSummary Can we add metadata/Properties such as author, tags to a PDF output file through BI PublisherContent Can anyone tell me if I can add metadata to pdf output gener… -
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties… -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…
-
HCM Subject Areas - Field ListSummary List of fields within HCM Subject Areas - and DescriptionContent Hi, I am new to reporting within HCM OTBI so this may be a silly question and may or may not hav…
-
Error on Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationSummary Getting data model error while running Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationContent Hi All, Does anyone know what…
-
Attributes of Pay ElementsSummary Taxable, Niable and Pensionable flags associated with each pay elementContent Hello, I am trying to develop a report in Oracle Fusion to obtain every payroll ele…
-
Making Changes to Standard Notification TemplatesSummary Is there a delay between a customized BIPublisher report and the workforce Notifications?Content Hello Experts! We've recently started venturing into changing so… -
Weekly & Monthly Team Calendar View for Employees & ManagersContent Hello! I don't think a day goes by where we are not asked for weekly and monthly team calendars to allow our managers to make informed decisions around holiday r… -
Report -Review Period,Goal Plan and Goal Approval status reportSummary Report -Review Period,Goal Plan and Goal Approval status reportContent Report -Review Period,Goal Plan and Goal Approval status report
-
Dashboard Prompt using BI Publisher/DataModelSummary Using a prompt on a dashboard for a BI ReportContent I have placed a BI Publisher report on a dashboard. This report is built from a data model that contains a p… -
Report sorting based on supervisor hierarchy 1 followed by hierarchy 2Summary Requirement: Report sorting logic required to sort based on Supervisory Hierarchy 1 followed by Supervisory Hierarchy 2 as displayed in the table above. Kindly l…
-
Perfomance managment -In Overall manager rating field two rows of data is displayed.Summary Perfomance managment -In Overall manager rating field two rows of data is displayed.Content Perfomance managment -In Overall manager rating field two rows of dat…
-
How to get readiness level in reportContent Hi Everyone. I am trying to get the data of the succession plan in a report however I got all data except Readiness level. In HRM_PLAN_CANDIDATES table, the Read…