Reporting and 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 54 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Understanding the Sales Pipeline FunnelSummary The Sales Pipeline funnel is attention grabbing, but at the same time could prove to be intriguing until you understand it.Content So, what is the sales funnel ?… -
Can I use FND_BPM_TASK_B table to fetch approver detail in leave transaction report?Summary: Does this table have all the relevant information updated in real time? Is it recommended to use it for approver details of absence entries? Please assist. Than…Vaishnavi Agrawal 21 views 6 comments 0 points Most recent by AnnaMorelli Fusion Applications Administration
-
SQL query for Time Entries with Payroll result for the selected periodHi All, I have a requirement to fetch the columns as attached in the excel screenshot. The challenge i'm facing is i'm not aware how to join the Time Entries with Payrol…Dilip.Murugan-Oracle 32 views 0 comments 0 points Started by Dilip.Murugan-Oracle Reporting and Analytics for HCM
-
Is there an automated way we can view the updated date of standard texts?Summary: I am trying to get a list of all of our Standard Texts along with the date each was last updated. If I go into the Standard Text editor in the .NET console, I c…Andrew! 12 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 53 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
Looking for a way to limit/disable the use of the refresh button on the BIPublisher rep executionMy client has a report that runs based on a date range. However, after running the report, when they immediately click the Refresh button, it triggers the data extractio…Oscar Chahestian-Oracle 1 view 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting & Analytics for Sales
-
BICC Reset to Full Extract FunctionalitySummary: If we perform a Reset to Full Extract, does this mean our incremental data replication job will perform a full data load by default when we reset to a full extr…Carlo Orolfo 34 views 5 comments 0 points Most recent by Ankita Biswas-Oracle Reporting & Analytics for Sales
-
The email is not visible in the UI, but it is still triggering the validation scriptSummary: We have a validation script that queries active contacts where Status = 'A' and Internal Flag = 'N'. This validation is triggered in both scenarios — when a use…
-
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 41 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
25B Sales Dashboards ConfigurationSummary: We went through one of your demos in below link for 25B. https://community.oracle.com/customerconnect/events/606473-cx-sales-oracle-sales-25b-roadmap-update We …JainS 31 views 3 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
Reporting capabilitieHi Team, Posting this on behalf of Customer. We have a business requirement to generate a monthly SET Score Card for each Sales Representative, capturing performance met…
-
Is there a functionality called 'Active Primary Key' that retrieves a list of primary keys in a PVO?Summary: Is there a functionality called 'Active Primary Key' that retrieves a list of all primary keys in a PVO? we will be using this for performing soft deletes in ou…Carlo Orolfo 11 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Error on workpsace after adding a reportHi, Iam getting this error after adding report in workspace tab The report contains the following errors: -found flat branch for grouped parent You will need to edit the…Meera Saseendran T 12 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 82 views 2 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service -
Is there a way to verify emails via REST API?Summary: We need a report with the status of delivered emails, Content (please ensure you mask any confidential information): Hi, We need a report with the status of del…
-
Add Sign Key in BI Analytics for reportsHi Team, We have a requirement of adding Encryption and additionally sign the file using keys for a report output while placing the file in SFTP directory using Bursting…Sandipan Pal 11 views 1 comment 0 points Most recent by Sandipan Pal Fusion Applications Administration
-
audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Need Work order audit Backend tableSummary: Greetings, We need to extract report on the Work order audit record to understand several updates done on the Work order for data analysis. We are looking for t… -
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 21 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service -
Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co…MD-JMS 204 views 3 comments 1 point Most recent by Ashwin GSC-Oracle Reporting & Analytics for Fusion Service
-
how to add actions in reportHi, How we can add actions like open and delete ina report ? like below: Regards, MeeraMeera Saseendran T 31 views 2 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get import/update customer in Oracle Fusion based on load request IDI am trying to import/update customer and wanted to get import error messages for those customer through the BI report. But getting few error messages even the customer …Zaid123 24 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Change Order Summary Report QueryHi, Previously, there was a built-in customized report in Oracle PLM titled "Change Order Summary Report", which provided details of Change Orders along with redlining i…Ramsha Zameer 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting and Analytics for SCM -
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 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
FDI versioned dataset -- how many versions are kept in the database?In Fusion Data Intelligence Data Augmentations there is an option to select versioned dataset. Documentation states this fully extracts the object from Fusion with each …JDC 1 view 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 61 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Capacity chartHi, I need to create a capacity chart. •For incidents without a task, use the Due date to allocate the effort into the weekly intervalFor incidents with tasks, use the t…Meera Saseendran T 11 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service