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 21 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for SCM -
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 23 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …Nalsoft Pvt Ltd 13 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …Dhanusia 1 view 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting and Analytics for ERP
-
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex…Viswarupachari 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Helpdesk Requests that have Journeys assigned to them on an OTBI**This post was created as part of a How to Service Request (SR) Release: [Version] 11.13.24.04.0 Summary of the question: Can we identify Helpdesk Requests that have Jo…Bodhisattwa Mukherjee-Oracle 1 view 2 comments 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Is there a simple way to create a report based on Service request, Work Order and Debrief?we are working to create a report that will include information from the Service request and all the work that was done by the engineer. the entity structure we need (or…Boaz Hayon-Oracle 1 view 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Does anyone have an idea on how to Call Third Party API from Fusion via ESS JobSummary: We have a standalone Oracle DB and and API that exposes the data from a specific table. Since we can't connect OTBI to other DB, we just want to be able to call…PeterXavier 12 views 2 comments 0 points Most recent by user4590662 Reporting & Analytics for Fusion Service
-
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 11 views 1 comment 0 points Most recent by RajuT Reporting & Analytics for Fusion Service
-
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…MD-JMS 31 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Report who all are using Fusion Cloud applicationsSummary: Report who all are using Fusion Cloud applications Content (please ensure you mask any confidential information): Version (include the version you are using, if…SathishVellampalli 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
Table to fetch HCM Extract name and delivery optionsHi Team, Please let us know the tables required to fetch submitted extracts and its status in fusion HCM. Thanks, Jahanavijahanavi metta 36 views 1 comment 0 points Most recent by Abdulrahman2k Reporting & Analytics for Fusion Service
-
What would the formula to convert decimal to hours be?We're creating a new infolet in OTBI for users to see their flexi balance, however it currently displays the balance in decimal (e.g. 30.8, 1.2, etc.) when we need it to… -
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…Madushan Fernando 11 views 1 comment 0 points Most recent by Madushan Fernando Reporting & Analytics for Fusion Service
-
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…Colin M 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Is the Workforce Learning - Learning Management Real Time subject area being deprecated, and when?Can you help me understand if this SA is being deprecated in OTBI or if it will remain? This Customer connect article seems to indicate it was announced in 2021 that it …
-
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 51 views 3 comments 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
In which subject area I can find Site details to create an OTBI report?I need the following fields in my OTBI report related to site to know their subscription status: 1) Oracle Fusion Site Name 2) Oracle Fusion Site Number 3) Oracle Fusion…Vishal Thakur 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Load Data from FAH(fusion Accounting Hub) to FAW, need more details?Summary: Data load from Fusion Accounting Hub(FAH -Fusion Applications) to FAW(Fusion Analytics warehouse) Content (please ensure you mask any confidential information):…NsanthoshK 31 views 2 comments 0 points Most recent by NsanthoshK Reporting & Analytics for Fusion Service
-
Cloud Bi Publisher - BIP bursting not sending emailsHi All, I am using Oracle Analytics Publisher and have built a report and associated data model, with a bursting query. I want to schedule the report to be sent to email…NZ-user999 296 views 2 comments 1 point Most recent by NZ-user999 Reporting & Analytics for Fusion Service
-
Legal Disclaimer check box field under the External Career Site cannot be obtained from the reportThe Legal Disclaimer or Privacy Statement column under the Recruiting Career Site cannot be obtained from the BIP and OTBI report. We would like to ask for your help bec…
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…kalyan gade 214 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service
-
Oracle fusion database table for Context based DFF segment API namesWe need to extract API names of context based serial numbers DFF attributes from database table. However, we can't figure the appropriate table which holds these details…
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.Mohammad Borghol 70 views 3 comments 0 points Most recent by Muhammad Asif R Reporting & Analytics for Fusion Service
-
Can we get employee ID of salesperson in reportsHow can we get employee ID of salesperson in reports, From Opportunity, when we pull employee ID, its giving the employee ID of the Opportunity owner, but can we get emp…Pavan_Ketha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
SQL query to fetch employees holiday applied on during employees is on maternitySQL query to fetch employees holiday applied on during employees is on maternityManikanth Kumar 31 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service