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
-
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in Requisitions -
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…
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…
-
MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…
-
Option to ZIP PDF files generated from BIP Jobs on Fusion platformOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): JPMorgan Chase Description (Required)…
-
Steps to add page break and print BIP report output splitting page wise through RTF templateI have BIP report with N number records and added RTF template to print the output in HTML format in fusion. When running the report, I want to view the output with pagi…
-
1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev… -
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…
-
How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li… -
Is there any documentation for the setup of FDI/FAW Fusion Analytic ?FDI Fusion data intelligence FAW Fusion analytic warehouse
-
Is it possible to zip multiple template layout outputs from a single report into a single file?I'm looking to understand if there is a way to consolidate multiple template layout outputs from a single report into a single zipped file. If anyone has experience with…
-
ERROR: [94744] Failed to convert RPD to SMMLI was using Oracle BI Admin Tool to work on RPD and then upload to OAC. I was trying to upload RPD to Semantic model in OAC and I am getting below error. ERROR: [94744] …
-
Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.
-
Cloud Bi Publisher - BIP bursting not sending emailsHi All, I am using Oracle Analytics Publisher and have built a report and associated data model, with a bursting query. I want to schedule the report to be sent to email…
-
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
-
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le… -
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 add new table extract in BICCSummary: Hi Experts, We noticed some tables are missing in BICC console and below table is an example. May i know if there is a way to extract the missing tables using B…
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…
-
In which Fusion DB tables SaaS usage details are stored?We are trying to build an custom report similar to SaaS Service Usage Metrics Report for our Fusion instance. The report will need to display region wise/country wise li…
-
Audit Reports Through REST APISummary: Where is possible to find list of business objects type for CRM. Content (required): Hi, I'm trying to generate Audit Reports trough REST API. The purpose it's …
-
How To Restrict Access To Custom and Other Folders in Reports and AnalyticsSummary: We would like to restrict access to reports and analystics folder or Custom folder under reports and analystics. Pelase advise. Content (required): Version (inc…
-
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…
-
Can we fetch login data of all users for a year with Login Date and not LAST LOGIN DATE? All loginsWe have a audit requirement to present them with data of all users and all their logins in the past 1 year. For eg if a user XYZ has logged in 10 times into the instance…
-
Will a version of SQL Developer that can connect to a SaaS instance be released?Summary: We see other products that are being marketed to allow users to query the tables in the SaaS database. Just wondering if a version of SQL Developer might be dev… -
Markie Awards- We want to put YOU in the spotlight- Nominate now!This year marks the 16th year Oracle will celebrate customer experience (CX), innovation, and excellence in advertising, marketing, sales, service, and e-commerce.It’s a… -
BICC PVO is extracting same delta extract every time irrelevant to Last Extract DateSummary: BICC PVO is extracting the same delta extract every time irrelevant to the Last Extract Date. Below are the two PVO for which we are encountering this issue: 1.… -
Sales Analytics DashboardHi, Kindly help me out where does the configuration need to be done to setup the hierarchy to be displayed in Sales Analysis Dashboard report For eg I need John in Globa… -
Need all the columns with CLOB data type in the BICC Extract along with the PVO NameSummary: Hi All, We need all the columns with CLOB data type in the BICC Extract along with the PVO Name in Excel Format. Thanks in Advance :) Content (required): Ricoh …
-
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …