OTBI
Discussion List
-
Need report answers to an assessment that has both single choice and open ended questions?We created an assessment in Oracle Learning as a survey and needing to pull the data out. I am having trouble getting a report to pull all the answers in mass. Here is a… -
User Preferences in OTBISummary: Is there a subject area to report on user preferences under "My Account" in OTBI? Would this area report the same data as the user's "Correspondence Language" u… -
Procure To Pay real time Subject Area issuesSummary: Need help to triage Procure To Pay real time Subject Area issues Content (please ensure you mask any confidential information): I am currently validating the da…
-
OTBI Dashboard to search purchase orders and drill down to view purchase order detailsSummary OTBI Dashboard for Line of Business Users or AP Specialists to search purchase orders and drill down to view purchase orders using deep linksContent Purchasing h…
-
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…
-
Issue with Retrieving "Workforce Scheduling - Workforce Schedule Real Time" subject area in OTBIHi , We have a client requirement to identify the scheduled number of working days using OTBI. For this purpose, we are utilizing the subject area: Workforce Scheduling …Nithin Nannuri 11 views 0 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Nannuri 21 views 2 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…MariaStanciu 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
RVIE Report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) Not Showing Any InvoicesHello everyone, I’m currently facing an issue with the RVIE report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) in OTBI. When executing the report for… -
OTBI Dashboard passing prompts with url link.Hi, I am creating a OTBI dashboard and i want to generate a link with an url which would be passed through tthe prompt directly. i tried this link but it did not work…MYassikaya 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Development.…Noelle Bartlam-Oracle 3.8K views 15 comments 11 points Most recent by Sachin Bhadange Reporting & Analytics for Sales
-
Pick Confirmation by Work Order - Trying to locate the pick time on WO'sSummary: Work Order Release Date: KnownExisting Report Location Date/ Time Stamp of PickConfirmation by Work Order: Unknown Report Location ???? Date/ Time Stamp of PO C…
-
Standard functionality to check Purchasing staff workloadSummary: Standard functionality to check Purchasing staff workload Content (please ensure you mask any confidential information): Do we have any seeded Oracle purchasing…
-
OTBI: HR HelpDesk Request Real Time - Line ManagerSummary: We are creating an analysis report using HR HelpDesk Request Real Time Subject Area with the ff goals: 1. If the Line Manager runs the report, the report should…Garry Parta 12 views 2 comments 0 points Most recent by Vishal Purohit Reporting & Analytics for Fusion Service
-
IS there any existing report for Project Accounting details and related Journal information?Summary: Show Journal information with Project Accounting Content (please ensure you mask any confidential information): There is a requirement to add Journal informatio…
-
Enable Report in Administrator DashboardSummary: Hi Experts, How can we enable the below reports things in our client instances on Administrator Dashboard ? The above dashboard is available in Oracle instances… -
Consolidated Document via REST API/Integration ServletSummary: For a business requirement, we need to create a Consolidated Document in OTM via Integration, associated to different Order Release. Is this possible with the c… -
Future dated benefit groupsSummary: I am trying to create an OTBI report that shows the effective start date and end date of Benefit Groups. The only subject area that I can find that has the bene…
-
How do I remove the measure labels from my bar chart so it doesn't show in the legend?I have a horizontal bar chart and have noticed that the "measure labels" is in the Vary Color By section of my chart. I can move it to Group By, Sections, and Graph Prom…Tonya H 61 views 6 comments 0 points Most recent by Vikrant Tripathi Reporting & Analytics for Sales
-
OTBI Custom Subject Areas using Application ComposerSummary: Can Customer create custom Subject Areas for OTBI in Fusion HCM using Application Composer? Content (please ensure you mask any confidential information): Highe…AVorster-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to change the date format in OTBI promptSummary: How to change the date format in OTBI prompt. currently we are trying to change the accounting date column to mm-dd-yyyy format but we are getting syntax issue.…User_U4A6A 71 views 4 comments 1 point Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 342 views 6 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Join multiple subject areas in AnalyticsSummary: Join multiple subject areas to have an outer joint result. Content (required): My users want a dashboard to show the percentage of the employees who set up annu… -
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…
-
Which table stored Request type of Sales orderSummary Which table stored Request type of Sales orderContent Hi Guru's I am trying to find the Request type column which come under line level when we click on Ship to …
-
Conditional Signature Printing in Disbursement Payment File Formats Based on Fusion InstanceSummary: In the Oracle Fusion ERP seeded report “Disbursement Payment File Formats”, I need to conditionally print a signature in the check template based on the Fusion …Basavaraj Navalagi 12 views 0 comments 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management -
SQL Query - Pending Benefit Transactions that would prevent Employee TerminationHello, Hope you are well. Does anyone have a SQL query available, that displays any Active/In-Flight/Pending Benefit Transactions which would cause the Termination of an…David Oldfield 1 view 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Performance Task Status data is emptySummary: Workforce Performance - Performance Task Status Real Time returns the 'No Results' error. I checked and confirm that my role has the FBI_PERFORMANCE_MANAGEMENT_…George Chernikov 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce …Andriampeno Odilon 85 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Locate and Open Positions when Redwood Search FailsLocate and Open Positions when Redwood Search Fails When the Redwood search fails to display a known position, and reasonable means to fix the issue fail, the following …