Reports
Discussion List
-
How to merge OTBI rowsContent Hello experts, is there a way to merge OTBI information in a single row for each worker? For example, the highlighted employees appears five times. How can I agg…Valerio Curzi 118 views 4 comments 0 points Most recent by User_2025-02-06-06-09-22-949 Reporting and Analytics for HCM -
Filter analysis based on results of other fields which were based on a filterContent I created a report that will compare, by benefit, what should have been deducted from an employee's check vs what actually did get deducted. As a result I have t…Annette M 37 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Position OccupancySummary I'm trying to check a position occupancy report as I am not sure it is returni9ng the correct incumbent FTE value and showing staff that have left and are inacti…Lee_B 98 views 3 comments 0 points Most recent by User_2025-01-28-21-32-42-630 Reporting and Analytics for HCM -
Ranges for Geographic DifferentialsSummary Is it possible to pull a report of salary ranges for Locations that have a geographic differential?Content If possible, what subject area and field should be pul…User_2025-01-28-20-43-56-568 44 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dynamic list/ Alternate hierarchy for Period dimensionSummary Period dimension listContent Hello everybody, I'm facing an issue with the clients request for Period display in certain reports. The request is f.e. If April is…Mihajlo 43 views 3 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close
-
What Role i need to get data out of AnalysisSummary What Role i need to get data out of AnalysisContent Hi I have BI Admin / HR Specialist and manager / Application Developer roles. I can write sql on BI report an…Jagdish Varadraj 49 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
User Access to Journal ReportSummary User Role Access to Journal ReportContent The user role currently does not have access to the Journal Reports tab, how is it possible for the user role to view a…
-
Using Smart View Save Smart Form FunctionalitySummary This is the second in a series of articles exploring rarely used (or in this case newer) functionality in Smart View. Currently we will be exploring Smart Forms.…
-
Taleo requisitions data in Fusion OTBISummary How to get Taleo requisitions data in the fusion OTBI subject area (Human Resources - Recruitment)Content Hi We wanted to create a Human resources dashbard in fu…Mohit Gupta-45440 37 views 5 comments 0 points Most recent by User_2025-01-28-05-11-13-165 Reporting and Analytics for HCM -
OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Summary OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Content Hi All, I have a couple of queries around reporting on Wo…Richard Beet 153 views 14 comments 2 points Most recent by User_2025-02-04-17-55-40-189 Reporting and Analytics for HCM
-
Primary FlagSummary What does it actualy do?Content Hi, total N00b here, please bear with me! In our version of Oracle, we've always used five flags (below) in order to get 'active'…User_2025-02-05-15-09-04-091 92 views 7 comments 1 point Most recent by Chethana Kumari-Oracle Reporting and Analytics for HCM
-
Projects Standard OTBI reports with SampleSummary Projects Standard OTBI reports with SampleContent I am trying to find out if we have dump of all the standard report of PPM Cloud, the way its available for Fina…Lalkrishna Rath-Oracle 101 views 3 comments 0 points Most recent by Lalkrishna Rath-Oracle Project Management
-
Position ManagementContent All - we are implementing Position Management and I have some questions about reporting and hoping you can help direct me. I did search for this information, but… -
Employees & Line Managers without Work EmailSummary We are looking to audit all employees and all managers without a work emailContent Hi all, We are working on some audits and one of the audits we are having some…User_2025-02-05-05-51-12-049 51 views 5 comments 0 points Most recent by User_2025-02-05-05-51-12-049 Reporting and Analytics for HCM
-
New 'Security - Roles & Privileges Real Time' subject areaSummary Has anyone used the new Security - Roles & Privileges Real Time subject area yet?Content The new Security - Roles & Privileges Real Time subject area has been de…Elizabeth Docherty 119 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
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…User_2025-07-18-02-05-33-261 83 views 5 comments 0 points Most recent by Kevin Orze-43433 Reporting and Analytics for HCM
-
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 …Helen Bennallack 154 views 4 comments 0 points Most recent by Helen Bennallack Reporting and Analytics for HCM
-
What's New in 19.12?Summary ...last one of the year!Content Here we are again and for the last time this year (BTW, pet peeve, this isn't the last time in the decade... decade ends 31-Dec-2… -
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, …Gary Miller-39965 162 views 14 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Intercompany Reports SavingSummary Not Able to save Intercompany ReportsContent Hi All, I'm not able to save the "Intercompany Reports" (see attached Image). Regards, Antonio Version Version 19.11…Antonio Barbaro 42 views 10 comments 1 point Most recent by Antonio Barbaro Financial Consolidation and Close -
Font Reporting ListSummary Font Reporting ListContent Hi All, is it possibile to add other font type in the list of Reporting? Best Regards, AntonioAntonio Barbaro 19 views 4 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close
-
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…Praveen uppari 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…kobi 64 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…User_2025-02-06-00-01-08-606 55 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
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…Mohit Gupta-45440 936 views 5 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM