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
-
Filter unique values in a custom object on a DCL fieldSummary: A custom object has one of the fields as DCL(Dynamic Choice List). This DCL is in turn dependent on a custom object (LOV custom object) which will have duplicat… -
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…
-
Drill Down in Reporting not workingSummary: My pivot table is coming up as not able to drill down into even though the settings are correct for it to be allowed to be clicked into, not sure what I'm doing…
-
Case Management/HR Helpdesk delivered OTBI reports not openingHi Everyone, I am facing issue accessing the delivered case management OTBI analyses that is found under Shared Folders > Service > Embedded Content > all Help Desk subj…
-
Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ? -
Inventory on hand report in FusionIs there a standard report in Fusion that has inventory on hand by subinventory, locator, lot?
-
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… -
25B REDWOOD INVENTORY MANAGEMENTIn 25B Inventory Landing Page - Reports and Analytics option is not available in REDWOOD UI but available in Classic UI.
-
Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …
-
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 …
-
Query to get the prepayment Amount ValuesSummary Dear All, I am creating a BIP report, In which I need to calculate the number of employees processed in the payroll run and sum of total amount in processed in p…
-
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…
-
Error adding PVO to BICCHave SR open—no useful response yet so looking for other response. Error adding an existing PVO in BICC shows this error " [BIACM0185] Error saving data store due to [BI…
-
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…
-
Unable to burst a BIP report for data model based on web service?I have created a data model based on web service which I have created in OIC(exposed a SOAP based web service). This pulls data from ATP database based on parameters sen…
-
Missing Data Repsonse using soap UIcould you please check this payload--> csv P_START_DATE…
-
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).…