Analytics
Discussion List
-
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 36 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 181 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Invoice summary details table for APWhich table stores Invoice summary details in Fusion cloud. I am looking for the column which stores Accounting informationKavya Gururaj 13 views 4 comments 0 points Most recent by Salu Prabhakaran Payables, Payments & Cash Management
-
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 32 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
The US Periodic Tax Filing ext- why New version does not work; Old version renamed to Obsolete work?Change title to The US Periodic Tax Filing ADP Quarterly Extract - New version does not work; Old version renamed to "Obsolete. This is a follow-up email to our conversa…Pamela Price-Oracle 32 views 3 comments 0 points Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI) -
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 12 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service -
How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…Ritu123 51 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Receivables & Collections
-
How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 2 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to solve this below errorI have received this error notification from oac. I am new to it and not sure where to go to check this. What I am able to understand here is that there was some failed …Neelotpal01 26 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…SHRUTI PRIYA 43 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to generate BIP report bursting output in PDF and HTML bothThe requirement is to get the email notification through bursting BIP report as an attachment and email body both. The template of the report contains tables , company l…
-
Need to find argument 56 of Account Analysis Report ESS JobI need to Submit Account Analysis Report ESS Job using SOAP, how can I find where is argument 56 value is getting fetched from? When I am entering Account filter that ti…Aditi Agrawal2650 12 views 1 comment 1 point Most recent by Aditi Agrawal2650 General Ledger & Intercompany
-
Does Oracle Analytics publisher desktop needs licensing?We are already using Oracle Fusion cloud. For creating BI report templates, we would require Oracle Analytics publisher desktop. Do we need additional license to downloa…Piku 42 views 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ?KabirB 32 views 3 comments 0 points Most recent by Z-Man-Oracle Reporting & Analytics for Fusion Service -
Tables which stores the details of Request More Information for CandidateWould like to know which table stores the details that will be entered by the candidate when he/she is requested for More Information. The details may also include attac…Nalsoft Pvt Ltd 12 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Query to get supplier details along with bank details associated with that supplierSummary: Query to get supplier details along with bank details associated with that supplier Content (please ensure you mask any confidential information): Version (incl…Ritu123 1 view 1 comment 0 points Most recent by Sunil Jami-Oracle Supply Chain Planning and Collaboration
-
How to show a BI Publisher report along with an OTBI reportHi, I have a requirement to show a BI Publisher report along with an OTBI report. Is it possible to attach or embed a BI report inside an OTBI report? Also, if this is p… -
Issue with dependent parameters of report in fusion HCMHi Team, We have a requirement to create a report which would fetch the latest extract flow name w.r.t Legislative data group. Currently we have two parameters of LDG an…
-
OOTB BIP Audit Report has date filters in UTCWe are using OOTB Audit reports that log a timestamp whenever a user Open,View or Download any BIP report in the system. Customer is using them to track which users are …Anubha Vijayvergiya-Oracle 31 views 2 comments 0 points Most recent by Anubha Vijayvergiya-Oracle Reporting & Analytics for Fusion Service
-
Would it possible to extend the sql quey time limit.Hi Team, There is an BIP report scheduled and it was taking more than 1800 secs to run. While it was crossing 1800secs the report is failing. Is there any way we can ext…
-
How to filter analysis date within current dateHi Experts, We're currently using "Receiving - Transaction Real Time" to create an analysis. and we want to filter on transaction date field that only display date on cu…Wang Yuan-Oracle 4 views 0 comments 0 points Started by Wang Yuan-Oracle Reporting and Analytics for ERP
-
Query to get the prepayment Amount ValuesSummary Dear All, I am creating a BIP report, In which I need to calculate the number of employees processed in the payroll run and sum of total amount in processed in p…VaibhavChavan20_ 93 views 1 comment 0 points Most recent by VaibhavChavan20_ Reporting and Analytics for HCM
-
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 22 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM
-
Need to pass value from SaaS page To BIP ReportSummary: Hi We have added Highlighted Hyperlink to Call BIP Report. We are able to call BIP report but need few points in it. Need To pass Request from SaaS to BIP Repor…
-
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and… -
Where can I find reference Columns of Supplier site purposeCan anyone help with query to find out the above red marked field for oracle site purpose flag as sourcing only. Thanks in advance -
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…MaheshRayudu7 2 views 1 comment 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM