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
-
we have the BI admin role,however, we encounter an issue the Reports and Analytics option missingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to personalize Schedule process screen?i am trying to personalize Schedule process screen but none of the filed is editable.
-
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_org
-
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…
-
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…
-
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…
-
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 BIP
-
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 manually
-
Cant use the Oracle Analytics Publisher error "menu2007.logon"Hi installed in my machine the Oracle Analytics Publisher for word, but after install showing in tab "Publisher" in login "Menu2007.logon". I used this link to download …
-
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 …
-
How to add a specific offering to BIACM extract in Fusion?Hello all, I am unable to locate and add the below data store. FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvEventsExtractPVO Can you please help? Thanks
-
Sql to find weekdays between two DB dates in fusionI want the query for Fusion to find weekdays between two dates skip the saturday and sunday and give the subtracted days dates may be have differnce of 1 day or 10 days …
-
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…
-
-
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.
-
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…
-
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…