To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
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 (…
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…
-
Table to get BICC job schedule detailsHi Team, I am looking for any table where i will get the BICC Job details for completed or Running.
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…
-
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…
-
Can I use output from one BI report as input to another BI report?Summary: Content (required): I know that I can create multiple templates for my output, but that would require me to run the data model again. I'm looking for a way to p…
-
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 Advice -
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…
-
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 …
-
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…
-
How to create a custom table in the Oracle Fusion BI analytics cloudHow to create a custom table in the Oracle Fusion BI analytics cloud
-
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… -
oracle.xdo.xdoexception: java.net.malformedurlexception: unknown protocol: xdoxslHi, We are facing an issue with a particular user for BI Publisher report where we have a sub template. However, When I run the report, I don't see any issues from my en…
-
Functional area for allocated to prepare OTBI ReportIs anyone aware of the functional area where we can find the quantity allocated.
-
How to create an analysis of SVC_CHAT_MESSAGE table?I would like to create a report/analysis with data fetched from this table, filter it, sort it, etc. I wasn't able to find the OOTB subject area for this table, so I'm g… -
Data Model not working properly.We are converting the standard report into Customize Report including data model, when we modify the data model it does not effect and don't make changes. We use the gro…
-
What is the table that stores error records for Depreciation Override of Asset using ADFDI?Hi All, We are using ADFDI to Override the depreciation of Asset. After importing the records we need to generate the error report for failed records. Which table stores…
-
BIP Report to Get Last 30 Days User Login DetailsSummary: The Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last l…
-
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…
-
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…
-
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…
-
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…
-
How to generate ESS Job output in multiple formatsHi, We have a requirement to send the output to the customer. We are able to send the output in PDF format without any issue. However; customer is looking for both PDF &…
-
How to access your Usage Metrics Drill-Through ReportSummary: Hi, I received an email that says that your usage report can be downloaded from My Services. This info is not clear for me. Kindly assist to access this report.… -
Invoice Print Template default format change from pdf to wordInvoice Print Template is customized and the default format is set to 'Word(*.docx) however when clicked on the view image button over the transaction the invoice genera…
-
Can we add a parameter in the standard payable invoice aging reportwhile doing the Standard report customization, Can we add a parameter in the standard payable invoice aging report? If yes please provide the step details. we tried it, …
-
OTBI Subject Area Security IssueSummary: For the subject area Workforce Management - Person Real Time, we have a user "Mark Eliot" who can view employee's personal information (eg: address) even though…
-
Table containing Candidate personal information(Recruiting module)Hello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. Need to create BI report on t…