Analytics
Discussion List
-
BIP to burst the file to SFTP Server with 0 KB in case there is no data extractedSummary: We have requirement to burst BIP report output to SFTP server with 0 KB size in case there is no data extracted after data model query being executed. Content (…Hitesh Jasuja-Oracle 49 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service -
How to show Average First Response Time and Average Handling Time on a graph for Service RequestsSummary: We have a detail report by service request that uses certain calculations to take into account the number of hours worked a day by CS. We have the following wor…Crystal Pace 16 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Need to Stop Showing Business Unit Code in Report HeaderHi All, I have created Report using Oracle FRS and in the report output i need to stop appearing this BU code. Please AdviceNavindu Amarasinghe 14 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 16 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service -
Authentication issueDear All, I am currently utilizing basic authentication (username, password) to invoke a report and retrieve data from Visual Builder through the SOAP API. However, we h…George Mattar 15 views 3 comments 0 points Most recent by Narendra More-Support-Oracle Reporting & Analytics for Fusion Service -
Functions/Query in OTBI report to seperate concatenated segmentsHi, I'm trying to separate the concatenated segments into individual segments. I would like to separate 6 segments. I found a few Oracle documents which have solutions f…Varalakshmi 18 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service -
Joining Two Standard Subject AreasHi team, We are joining two subject areas "Costing - Receipt Accounting Real Time" and "Costing - Landed Costs Real Time". Bu not getting data. Can anybody help me under… -
Is there any documentation available in how FAW Custom Schema access/security works?Can someone point me to any documentation on how access/security will work on FAW custom schema. I understand FAW will inherit the Fusion schema for the standard dashboa…VAM 5 views 1 comment 3 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service -
Oracle BI Catalog ReorganizationWe are planning a reorganisation of the Oracle BI Catalog folder structures and will much appreciate knowing about any standard processes or best practices that are in p…ks1075 15 views 2 comments 1 point Most recent by Clare Murtagh Reporting & Analytics for Fusion Service -
how to display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is…Anusha716 30 views 1 comment 0 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service -
how to make goals dashboard embedded on the goals screen in fusion to take parameters from the goalsCustomer has created OTBI Analysis report based on the Workforce Goals - Goal Status Overview Real Time subject area. A graph has been created based on this analysis. Th…ElTawil 50 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting & Analytics for Fusion Service -
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 260 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Argument/Parameter descriptions and the sources for "Trial Balance Report" ESSJob in FSCMHi Everyone, I have a query regarding the "Trial Balance Report" ESSJob. Application details: Oracle Fusion Cloud Applications 23D (11.13.23.10.0) Please elaborate on th… -
BICC extract PVO for talent management.Hi All, We are looking for PVOs that holds transaction data for talent management. Please assist.Sushant95-Oracle 24 views 3 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM -
I want to be able to access the to address/recipient used in a delivered workflow notificationHi I want to be able to access the to address/recipient used in a delivered workflow notification from back end tables I tried using FA_FUSION_SOAINFRA.WFMESSAGEATTRIBUT…Aysha Yasmin M 29 views 2 comments 0 points Most recent by Aysha Yasmin M Reporting and Analytics for ERP -
Is It possible to get out put In JSON Format for BIP Reportscurrently we do not see JSON Format In BIP Reports out put format section, Please help!Nagendra Chitra-Oracle 12 views 0 comments 0 points Started by Nagendra Chitra-Oracle BI Publisher Learning Center -
workflow notification customizationHi, We have business requirement to change the layout of Approval notification related to Global Transfer & Global Temporary assignment, The standard forms as shown belo…mshehab 15 views 1 comment 0 points Most recent by Sahil Kathuria Reporting & Analytics for Fusion Service -
How to use phone numbers (Work phone, Mobile phone and home phone) in OTBIHi Oracle Community, The customer needs to report the Contact (Person) phone numbers (Work phone, Mobile phone and home phone) in OTBI, but these atributtes are not avai…Daniel Pérez Acevedo 176 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service -
Metric Descriptions - Service Subject AreasSummary Descriptions of all the out of box metrics found in the 'Service - CRM Service Requests Real Time' and 'Service - CRM Service Request Lifecycle' subject areasCon…Anand DN-Oracle 60 views 2 comments 2 points Most recent by Jenny Truong-Scognamiglio Reporting & Analytics for Fusion Service -
Calling an external image in bursting.While calling an external image in bip Busting its throws an error on the image. Error: The linked image cannot be displayed. The file might have been remove/renamed or …Shanmukhi 38 views 1 comment 0 points Most recent by Shanmukhi Reporting & Analytics for Fusion Service -
Requirement to validate National IdentifierHi Team, We've a requirement to validate National identifier based on Gender and Date of birth input value. For example If an Employee is Male and Date of Birth is 01/01…Sridevi patlolla 246 views 3 comments 0 points Most recent by Danny Cusnir-Oracle HCM Experience Design Studio: Autocomplete Rules -
We need to download the report for the audit purposeSummary: We need to download the report for the audit purpose. System changes log Authorization change log; add modify, delete. From where we can get this detailed repor…Arbaz Nakade 14 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service -
How to setup monthly report generation and sending to mail address every month?Hello, I have a question for monthly generation report and scheduled sending to mail address, how to setup it? Can you please help? Kind RegardsAmina Fajic 15 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
ZX_REP_TRX_DETAIL_T not giving any dataSummary: I need accounting information for the transactions. zx_lines is not helping since it does not have history data. Tried using ZX_REP_TRX_DETAIL_T, but its not gi…Sharmava 608 views 1 comment 0 points Most recent by Gopal Reddy-Oracle Reporting & Analytics for Fusion Service -
Table/Tables to find the "Cost Center Owner" Name/ID in OTBISummary: We are looking for the exact table name/set of tables through which we may find the Cost Center Owner Name or ID. Any information on the Subject Area where we m… -
Questions on BICCSummary: Questions on BICC Content (required): Hello Experts - We are planning to pull some of the entities from Oracle ERP Cloud to our external DW tables for reporting…Sanin Antony T 91 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting & Analytics for Fusion Service
-
BIP report output file encoding is changing in different ERPC environment, why this is happening?Summary: We developed a BIP report and for that BIP report client requirement is to send data in particular format and it should be in UTF-16LE encoding . file is in .tx…maroti.n.pawde 131 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto…Richard_Page 36 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service -
What is the limitation for how large of an XML string Oracle/BIP can handle?Summary: **This post was created as part of a How to Service Request (SR) Release: 23A Content (required): Customer is getting data from external source using web servic…Suri Natarajan-Oracle 81 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service