OTBI
Discussion List
-
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…vikram khengare 31 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM -
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th… -
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion… -
Capability to add CSP Progression Comments in OTBI analysisHi All, Currently, it is possible for a recruiter to add the comments while moving a candidate to different phase / state. The comments are visible in Progress tab under…PranitSawant 11 views 2 comments 0 points Most recent by PranitSawant Reporting and Analytics for HCM -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Payroll OTBI with Balance Definitions, Names, Feeds and Element names with Input Value NamesSummary We have a Balance Name called Net Pay with a Balance feed of multiple combinations of Elements and Input Value Names but I cannot find this relationship in the m… -
How to create Custom Dashboard in Order ManagementSummary: How to create Custom Dashboard in Order Management Content (please ensure you mask any confidential information): We are looking to create custom interactive da… -
How to join Transaction ID with Assignment IdentifierSummary: We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so t…Michelle Hughes 21 views 8 comments 1 point Most recent by Michelle Hughes Reporting and Analytics for HCM -
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…Debasish Saha 22 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM -
OTBI Report isn't showing all employees' dataSummary: OTBI Report isn't showing all employees' data. shows only Person number and name. Content (please ensure you mask any confidential information): When creating O… -
Is it possible to embed OTBI report and BIP report in one dashboard?Summary: Hello, I would like to confirm if it is possible to embed OTBI report and BIP report in one dashboard wherein both reports share with the same dashboard prompt?…Hazel De Castro 721 views 24 comments 0 points Most recent by Yves Chassein Reporting and Analytics for HCM -
Subject Area for Question in Question LibrarySummary: Hi Experts, I am trying to look for OTBI subjects areas for reporting on question which are present in Question Library. Main focus of reporting would be time o…Saurabh Pratap Singh 221 views 10 comments 0 points Most recent by K Trubenbacher Reporting and Analytics for HCM -
How to get average years of service by company and gender in OTBI?Summary: I need to create an OTBI report to calculate years of service by company and gender. Content (please ensure you mask any confidential information): This is my s…Stefano_Mazzocca 31 views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to customize standard OTBI ReportSummary: How to customize standard OTBI Report Content (please ensure you mask any confidential information): I need to customize one of the standard OTBI reports in Fus… -
Cost Center from subject area "Payables Invoices - Transactions Real Time"Content Hi. I'm struggling to figure out how to find the field, where I can see the cost center, outside the concatenated segment... Whenever I use the Cost center descr…Anders W. Langholm 79 views 13 comments 0 points Most recent by Piyush_Sinha Reporting and Analytics for ERP -
Create Infolet option not visibleSummary: Hi Everyone, We are trying to create Infolet for an OTBI report in 25B. When we enable sandbox and try to add infolet on Home screen under analytics than system… -
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo… -
Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per… -
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content…Maxime Pignot-Oracle 1.6K views 14 comments 16 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Birthday In Next 7 Days (Birthday THIS WEEK)Summary: Could someone please share an OTBI Birthday report that can be scheduled to run every Monday, showing Birthdays that week (Monday thru Sunday). For example, whe… -
Extract System vs Counted Quantity for Physical Inventory (Before/After Approval - not yet posted)Hi, Is there a way to generate or extract a report in Oracle Fusion Cloud that shows both the system on-hand quantity and the counted quantity for a physical inventory b… -
Enabling SMS alert and mobile push notification is LearnSummary: Customer has requested to enable SMS alerts and push notifications for various conditions such as course expiry, reminder to take action and enroll, learner ass… -
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 134 views 1 comment 1 point Most recent by Rakesh_Kumar_Sahu Reporting & Analytics for Fusion Service -
Unable to Embed a Parameterized Report via Guided Journey - RSSPThe business would like to retain the embedded report from RSSP classic page to redwood. This is possible though the use of Guided Journey. Report is only displaying 'No… -
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?LeonardoNogueira 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
LACLS NFSESummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Camila Lima-Oracle 1 view 0 comments 0 points Started by Camila Lima-Oracle Receivables & Collections -
BICC PVO for FND_FLEX_VALUES_VLSummary: Need PVO for FND_FLEX_VALUES_VL table Can someone please share the BICC PVO for table FND_FLEX_VALUES_VL. Content (please ensure you mask any confidential infor…Sateesh Lakkireddy 32 views 1 comment 0 points Most recent by Harsha Sannappanavar-Oracle General Ledger & Intercompany -
Absences created in Advanced modeSummary: It appears that the OTBI report splits out absences created in Advanced Mode onto separate lines by work week but gives the total absence duration for the leave…Stephen Jones 92 views 3 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Absence Detail AnalysisSummary: I'm looking to create an analysis which will show a detailed list of all absence entries in our system. I've created the following using Workforce Management - …