OTBI
Discussion List
-
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 JohnCap 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 13 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 70 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 173 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 34 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 …CJALSPAC 5 views 1 comment 0 points Most recent by CJALSPAC Reporting & Analytics for Fusion Service
-
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 115 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 23 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 42 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 795 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 545 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 84 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 32 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
How to integrate the analytics between Oracle Digital Assistant's skill and Oracle FusionSummary: So we have beautiful data in Oracle Digital Assistant and Oracle Fusion Service. We want to put them in the same dashboard. Content (please ensure you mask any …Calin Pavel 37 views 2 comments 0 points Most recent by Calin Pavel Reporting & Analytics for Fusion Service -
What table holds partial time entries from the Web Clock?In summary, if a web clock entry is incomplete AND it has no time type attached, then where is that stored on the backend tables. You're welcome to read more for details…ElijahHopkin 23 views 1 comment 0 points Most recent by ASHOKKUMARFUSION-Oracle Workforce Management -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 105 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service
-
OTBI Report - Effective Start Date UnionI am creating an OTBI report to extract Union member, Union of the employees and the date from which the employee joined the union. I am using the following subject area…Greta S 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
DFF values not appearing in OTBIHow do you get a DFF LOV results values to appear in OTBI reports and analytics? Seems as though I am able to return every value and DFF results value field into the rep…Tina T 213 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Looking for sql to find day/timestamp of employee's policy acknowledgmentI am looking for the table(s) to find the signature day/timestamp for a policy that was 'signed' during an onboarding journey. I started in PER_ALLOCATED_TASKS - is that…Wendy G 33 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le…Satyam Roy 21 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service