Reports
Discussion List
-
Function for selecting Level0 members for a parent account is not available in FRS.Content Hi All, I'm just wondering why the function of Lvl0Descendents doesn't appear in the function list in the member selection panel in FRS. We have a simple require… -
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…Andrew Braid 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…User_2025-02-06-07-21-22-662 59 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Request to provide information on Depo repiar process flow in 19DSummary Request to provide information on Depo repiar process flow in 19DContent Hi All, Request to provide information on Depo repiar process flow in 19D. Would like to… -
Changing how burden costs are generated after go-liveSummary Implications of changing how the burden costs are created after go-liveContent Has any one come across this situation? As part of the initial implementation all … -
Defaulting user currency preference in OTBISummary Can the currency preference in OTBI be set at system level?Content Currently users need to update the currency preference to see the data from Projects related s… -
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…User_2025-02-05-01-04-36-989 28 views 3 comments 0 points Most recent by Thiru Ch Reporting and Analytics for HCM -
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…Roy Paolo Paunlagui 49 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 92 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
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… -
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…User_2025-02-05-22-36-27-300 39 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
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…Aloka Bhattacharya 642 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
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…Aloka Bhattacharya 112 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
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…User_2025-02-05-10-44-58-756 70 views 3 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
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…User_2025-02-04-17-55-40-189 43 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
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…Kevin M Storrie 98 views 2 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
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…Shelly Feyerherm 61 views 2 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
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… -
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…Misbahul Khair 45 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
How to embed a an OTBI report in the Skill and Qualifications pageSummary How to embed a an OTBI report in the Skill and Qualifications page?Content Hi, I want to embed an OTBI report in the Skill and Qualifications page, in order for …Silvia Guido 68 views 2 comments 0 points Most recent by Silvia Guido Reporting and Analytics for HCM -
HR Help Desk - SR`s out of SLASummary Can we report on how many SR`s go out of SLAContent Hello All, i was wondering if anyone knows how i would go about creating a report on how many SR`s per period…Mitch_123456 47 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Organisation Hierarchy treeSummary Organisation Hierarchy treeContent Hi, We have a requirement to pull the report of manger hierarchy in top and down. Suppose if I give employee number it should …Reddykrishna Chidella-Oracle 104 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
BI Publisher data model filter manager typeSummary Recently implemented second manager type which is causing multiple lines on BIP reportContent We have a daily BIP report that sends employee data based on action…Rob Stahly 25 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Data Source changes when migratingSummary What is the best way to handle data source changes when migrating from test to prodContent We're running into issues with the data source when we migrate a repor… -
Report showing changes to key fields onlySummary I have been asked to develop a report that will extract data changes onlyContent Hi, I have been asked to develop a scheduled report on based on the following fi…User_2025-02-05-22-44-35-842 36 views 8 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
How to count NULLS - OTBI Analysis reportSummary I have a basic employee extract and would like to count the number of nullsContent Hi, I have a basic employee extract report that has 12 columns from Workforce …User_2025-02-05-22-44-35-842 49 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM