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
-
25B REDWOOD INVENTORY MANAGEMENTIn 25B Inventory Landing Page - Reports and Analytics option is not available in REDWOOD UI but available in Classic UI. https://us.v-cdn.net/6034893/uploads/XYTS2KCTZ4Q… -
OOTB BIP Audit Report has date filters in UTCWe are using OOTB Audit reports that log a timestamp whenever a user Open,View or Download any BIP report in the system. Customer is using them to track which users are …
-
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in Requisitions
-
Schedule User and Role Access Audit Report with output destination as emailHi Team, We want to schedule "User and Role Access Audit Report" and its output file to be emailed to IT team email id. Currently, we are able to schedule report but una… -
Is there a report available for all transaction across all module for leadership prospective ?I am looking for a report available in Oracle Fusion for all transactional across all module for our leadership review ? For e.g. ESS and MSS links , how many time speci…
-
ERROR CODE OAMP2OPY:OPR4ONWYI am attaching the screenshot of an error - How to debug it? What could be the issue? Please help.
-
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj… -
Need a Report of all the approvers once the PR Approval is initiatedSummary: We have requirement to include display all the PR approvers in a BIP report as soon as PR approval is initiated. During the investigation found out that only th…
-
we have requirement to pull the data from Fusion Custom Apps Lookup. Is that same Fnd_lookup_valuesSummary: we have requirement to pull the data from Fusion Custom Apps Lookup. Is that same Fnd_lookup_values or do we need to pull differently? Content (please ensure yo…
-
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…
-
Getting error 401- Unauthorized error while calling WebService from Oracle Fusion BIPWhen we are calling Webservice from Oracle Fusion BIP , OIC is triggered but going into error 401- Unauthorized, however we are using the same User Name in OIC and BIP b…
-
I have build the report using service request object with custom subject area but getting error.Summary: I have build the report using service request object with custom subject area and trying to map the reference number to SR number (custom object custom field) b…
-
How to create Employee as a SupplierWe have a requirement to create Supplier records for all active Employees. Please advise on the best approach to establish a link between the Employee and the correspond…
-
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…
-
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct values -
BICC external storageSummary: We have to send bicc files to external storage allocated in a s3 site. wich kind of serviceName i'll request from my aws technician to make bicc get container n…
-
Why is country code "CZ" missing in fusion.psc_com_country_bSummary: Why is country code "CZ" missing in fusion.psc_com_country_b to convert country codes between ISO 3166-1 alpha-2 and ISO 3166-1 alpha-3 or ISO 3166-1 numeric. C…
-
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).…
-
In Cloud Fusion need ability to audit changes in the admin profile optionsI need the information whether it is the correct Oracle doc or just an answer on how to enable and then report on how to report on any changes made using manage admin pr…
-
Subject Area Related to CE_BANK_ACCOUNTS to get bank account Num & Asset Code Combination IDI am using "General Ledger - Journals Real Time" Subject Analysis & need to Join using Code Combination ID to get above bank account num
-
How to add date parameter while calling BIP Report using Custom ESS JobWe have created a BIP Report and calling it through ESS Job. The report is using a data parameter and we're trying to add the parameter in the ESS Job. The ESS Job is wo… -
Unable to Update an DataModel/Object in the BI Publisher Catalog Using the CatalogServicewe are trying to implement a solution to migrate BI(Data Model and Report) into oracle SAAS from Source to Target folder using Oracle standard WSDL- https:// /xmlpserver…
-
Is it possible to schedule ESS jobs in bulkWe currently have around 1,500+ ESS jobs, and we are looking for a solution that would allow us to schedule these jobs in bulk. All relevant job details are stored in an…
-
Time is being omitted in OOTB ESS Job Employee Vacation and Delegation Rules ReportHello, Does anyone know why the time from XML output of the report gets omitted? When we set a vacation rule in BPM, it includes both date and time. We need the time sin…
-
How to restrict the access folder level in BIP ReportsCould you please advise if there is an option to grant the permission only one folder (Eg: Pyables Custom) . We’re looking to ensure users cannot view or access for any …
-
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…
-
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.
-
Page Break function not working for excel(MHTML) output formatHi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We…
-
Can I know if there is a list of dashboards that is not part of Standard Fusion that is downloadableSummary: Is there a place where all the dashboards are available for download similar to the one available for expenses (provided by Andy in 2016) Content (please ensure…
-
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …