Analytics
Discussion List
-
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 40 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 89 views 3 comments 0 points Most recent by Muhammad Asif R 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 35 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Edit incoming email filter - Add Rule NameSummary: Id like to see the name of the Workflow Rule that rejected the email. Content (please ensure you mask any confidential information): I currently use the incomin…Marissa Gonzales 46 views 1 comment 0 points Most recent by mai fukumura-support-Oracle Reporting & Analytics for B2C Service -
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 40 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 29 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 48 views 7 comments 1 point Most recent by Sudheer YN 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 28 views 1 comment 0 points Most recent by ASHOKKUMARFUSION-Oracle Workforce Management
-
GL Drill Down to Work OrderNeed a query to drill down from GL to Work Order. We need details of PO, Work Order Number, Quantity, Amount when starting from Journals. We are using Source = 'Cost Acc…Sharmava 87 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
where to find the comments (Transaction Console Page) in backend?Please help me to find the tables for above snapshotSATHISH REDDY 16 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 238 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Organization name need to be replaced with department name.Summary: Hi All, Can some one help me on changing the Organization name instead of Department name in below query Content (required): In the query its is fetching old or…RamkumarKadhiravan 36 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 23 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Query to get the element entries and the pay period datesHello, Requesting your help to get the sql query to fecth element entry details and the associated pay period start dates and end dates. The elements are recurring eleme…Regunanthan 1.3K views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to convert primary ledger currency balances to USD currency balance in Oracle FRS reports?Need to get the primary ledger currency balances to USD currency balance, based on 'Period Average Rate.'Fredrick Ignatius 27 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Report to identify terminated employees in BPM workflowSummary: Content (please ensure you mask any confidential information): Hi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle wo…Nidhi Chhajed 14 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Cannot find table in Oracle BIP that stores the Organization (Department) of usersHi all, In order to complete a movement Request report, I am required to include the Department of the user that created the movement request. I have not yet been able t…Mariyam129 14 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Is there way we can get the "Import Asset and Assignments Process" import errors detailswhen we run the "Import Asset and Assignments Process" to import the Capital assets the load interface file import success and errored at import job and we are trying to…Saadiq 29 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Subledger Accounting - Journals Real TimeHi, We're experiencing an issue in an OTBI Analysis where we are unable to pull back data from any columns relating to Supplier, Purchase Orders, and Receipt Numbers at …John Aitken 17 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to personalize Schedule process screen?i am trying to personalize Schedule process screen but none of the filed is editable.TejasUphade04 26 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Looking for PVOsSummary: Looking for PVOs under biacm for the below tables msc_sr_assignments msc_customers msc_customer_sites_msc_v msc_items msc_sr_source_org msc_sr_receipt_orgGeorgina Sawyer 15 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Audit eventSummary: Event type and Attributes required to audit Role/Priv creation and maintenance Content (please ensure you mask any confidential information): We would like to r…User_2025-12-05-00-49-06-629 28 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
BIP Output delivery Details to SAAS and UCM detailsHello All, Could you please help us with details on following points if you have any inputs regarding BI reports delivery: 1. BIP output shown in report history is hoste…Pooja K 27 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Enable Data Stores in BICC OfferingsWe observed that there are some oracle delivered data Stores which are not enabled for extraction e.g Customer for given offering like Financials or Customer Data manage…Oracletechnofunctional 40 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service
-
Please let us know, can we use excel template with xlsx extension for getting outputs in BIPPlease let us know, can we use excel template with xlsx extension for getting outputs in BIPNagendra Chitra-Oracle 26 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
We need a API SOAP or REST to trigger a specific BICC jobs from OICWe have a requirement to trigger BICC jobs through API rather than doing it on cloud connector manuallyAmritaDash 137 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
how to find source to disable autorun for an OTBI report?Customer is getting a delivery report but now they don't want to use it further, We are trying to find a way to disable the autorun of the report. FYI: We were not able …Sushant95-Oracle 14 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
Report Analysis adding multiple subject areas (more than 2) errorHi there, we have a scenario where we have added a new subject area to an existing report that is already set up with the Dimensionality flag, so one would assume adding…
-
Nagendra Chitra-Oracle 22 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service