OTBI
Discussion List
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 193 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP -
How to exclude one PO item cost in work order costsSummary How to exclude one PO item cost in work order costsContent We have an OSP PO with multiple items, we need to exclude one item of the PO in the work order. The re… -
Compensation - Salary Details Real Time Subject Area Security OTBISummary What type of security roles/responsibilities are needed?Content Hello, We are attempting to make an OTBI report with the following Subject Area: Compensation - S…User_2025-02-05-07-37-39-271 116 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display VAT for an expense line/reportContent Hi, Between EXM_EXPENSE_REPORTS and EXM_EXPENSES how do I get to display the VAT paid for an expense line/report? Either through a data model/SQL or with an anal… -
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 95 views 3 comments 0 points Most recent by User_2025-01-28-21-32-42-630 Reporting and Analytics for HCM
-
Performance Tile - Changing Totals?Summary Returning to a page with Performance Tiles shows incorrect aggregated values.Content I have a dashboard that has a first, summary page with several KPI/counts as…
-
How to fetch payroll relationship number in OTBI?Summary How to fetch payroll relationship number in OTBI?Content Hello Experts, I have a requirement where to fetch all the assignment details and payroll relationship n…Harish Kumar Kovi 178 views 3 comments 0 points Most recent by Harish Kumar Kovi 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 43 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 55 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
Transaction Date on receipt what database table stores this info?Summary Transaction Date on receipt what database table stores this info?Content We back-date receipts on PO's and I can't find the transaction date in any receiving tab…Michelle Haynes 209 views 3 comments 0 points Most recent by Lynn Warneka-Oracle Inventory Management
-
Report to fetch all the employees who is missing Home address/ work address using OTBI?Summary Report to fetch all the employees who is missing Home address/ work address using OTBI?Content Hello Experts, I have a requirement where to fetch all the employe…Harish Kumar Kovi 147 views 2 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
Learning items pushed out via Learn Assignment Vs Learning items pushed out via initiativeSummary Learning items pushed out via Learn Assignment Vs Learning items pushed out via initiativeContent Is there a way to know in the database if a Learning item was p…
-
Reporting ESS and MSS transactionsSummary Reporting ESS and MSS transactionsContent Is it possible to report on Employee Self Service (ESS) and Manager Self Service (MSS) transactions? What defines a ESS…Andrew_Schmitz 91 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Value Conversion through Mapping sheetSummary Value Conversion through Mapping sheet in OTBI reportContent Hello, I have created a new column in report with the values coming from another column using "Case …User_2025-02-05-07-43-29-505 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tables Summing Budgets IncorrectlyContent Hello, I'm created some custom columns based on Case When Statements to calculate our budgets. I've tried both of the case statements below, but the column/pivot…User_2025-01-31-00-25-12-234 29 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting Capability for Field HR Reps (OTBI)Summary Need to understand how Reporting (OTBI) capability can easily be issued to field HR reps.Content Hello, We have 55 plants across the U.S. In each plant there is …User_2025-02-04-11-13-27-138 35 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …User_2025-02-06-00-02-39-946 53 views 5 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
otbi reports - how do i find out you last modified report?Summary otbi reports - how do i find out you last modified report?Content otbi reports - how do i find out you last modified report? i only see owner and that is person …Angela.Ahrens 227 views 3 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
SCM Item PVOsSummary SCM Item PVOs Definition or explanationContent Hi, I am using BICC to extract data from ERP Cloud for downstream integration with a client's data lake. We are in…Bradley Q-Oracle 118 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for SCM
-
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 89 views 7 comments 1 point Most recent by Chethana Kumari-Oracle Reporting and Analytics for HCM
-
Dependents Turning 26 Report SchedulingContent Hi All, Our benefits team has a business requirement to have a report generated at the beginning of each quarter that lists all of the dependents who will be tur…Lauren Owen 54 views 5 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
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
-
R13 Performance Management - Comments in CLOB formatSummary Does anyone have a sample report that would show comments in the new CLOB format?Content Hi, all, I'm trying to pull a report that shows sections comments from w…Karen Disney 87 views 4 comments 1 point Most recent by Kalyan Amaravathi 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