Reporting and Analytics
Discussion List
-
What if an instance has been created on analytics cloud instead of FAW ?Hi guys, What's the difference between creating an instance on Analytics Cloud and FAW on OCI ? What if some work has been done on an instance (let's say Instance 1) cre…Lauriane Massin Whitaker 21 views 2 comments 0 points Most recent by Lauriane Massin Whitaker 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 51 views 3 comments 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…NicolaosDerr 1 view 2 comments 0 points Most recent by NicolaosDerr Reporting & Analytics for Fusion Service
-
recruiting events analyticsHello, I would like to have some analytics or dashboards for metrics regarding recruiting events and campaigns in Recruiting. Is there any predefined dashboard, or a way…Carolina Oberti 21 views 2 comments 0 points Most recent by Chaitanya J.J.-Oracle Reporting & Analytics for Fusion Service
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to …Shikha_Singh12 2 views 1 comment 0 points Most recent by Sowmya Bonala-Oracle Reporting and Analytics for ERP -
Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud?Can BI Publisher Data Models query the table SYS.DBA_COL_COMMENTS in Oracle Fusion Cloud? I need to query this table to see the purpose of various fields in various tabl…
-
Unarchiving Custom folder after refresh fails without any error messageWe have been backing up the Custom folders (under shared folders) before the refresh on all non-prod pods. After the refresh is complete, we import back the custom folde…Vijay Ramani VJ 11 views 0 comments 0 points Started by Vijay Ramani VJ Reporting and Analytics for ERP -
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
-
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report BI of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications throu…Camilo Martinez-114335 6 views 1 comment 0 points Most recent by User_4XX09 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 32 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 273 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 export single offering of BICC for migration between instancesSummary: Ideally now we have have the bulk dump irrespective to specific offering that was modified exported and then imported to different instance. Content (required):…Dipendra 23 views 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
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 204 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service
-
Cannot open .xls output for a BI report with Excel Template when scheduling itHello, I have a report which uses an Excel Template and when executed it generates a .xls file. If I schedule this report then this .xls file is corrupted ie. user is no…Vigneshvaran KJ 38 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service
-
Project Status Change History tracking tableHello All, We have a requirement where client wants incremental run of the report to have all the project where explicitly status is updated to be extracted in the runs.…
-
How to get user login history or user wise application usage of Oracle fusion applicationsHow to get user login history or user wise application usage of Oracle fusion applicationsSaroj Kumar Dash 47 views 3 comments 0 points Most recent by User_YOFW3 Reporting & Analytics for Fusion Service
-
In which Fusion DB tables SaaS usage details are stored?We are trying to build an custom report similar to SaaS Service Usage Metrics Report for our Fusion instance. The report will need to display region wise/country wise li…Antony Davidraj 21 views 3 comments 1 point Most recent by April Sulapas 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 69 views 3 comments 0 points Most recent by Muhammad Asif R Reporting & Analytics for Fusion Service
-
How to extract more than 65000 records per excel sheet with BIP ReportSummary: Hi, Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, w…
-
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 2 views 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
-
Additional Information for Leave PlansDear All, Unable to find table/column value of "Additional Information" field regards absence accrual details Kindly let us know/share the table or column details which …Uma Jegadeesan 11 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 31 views 2 comments 0 points Most recent by Calin Pavel Reporting & Analytics for Fusion Service -
Bursting report in procedure call data setSummary: Content (please ensure you mask any confidential information): I have a requirement to insert/update the lookup code and print and deliver the PDF through email…Mayur_Gidwani 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
How to add new table extract in BICCSummary: Hi Experts, We noticed some tables are missing in BICC console and below table is an example. May i know if there is a way to extract the missing tables using B…Sudheer YN 44 views 7 comments 1 point Most recent by Sudheer YN Reporting & Analytics for Fusion Service
-
Can we hold the Oracle SFTP for the scheduled BI report jobsWe have few integrations directly using Oracle SFTP to send the file to various vendors. Wanted to check is there a way to hold the Oracle SFTP delivery alone for the sc…Karthik Soundarapandian1 31 views 5 comments 0 points Most recent by Sandeep19rm 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 21 views 1 comment 0 points Most recent by ASHOKKUMARFUSION-Oracle Workforce Management