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
-
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).…
-
Watermark in PDF reportsHow do we edit a watermark from a PDF report in Oracle, now it only shows "Draft" but with some conditions (not all of them). Is it done through the query database? Or i… -
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 …
-
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…
-
which field should I use for the Validation Status of AP Invoices?I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status.
-
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…
-
Sp HTTP 500/504 errors when using SOAP API in using BI PublisherSummary: My team makes calls every 30 minutes to BI Publisher through a SOAP API to retrieve information we need to update tables on an on prem database. We are making t…
-
April 23,2025 webinar: Customer Roundtable – Achieving Success with Oracle Fusion Data IntelligenceHear how your fellow customers using Oracle Fusion Data Intelligence are benefitting from unified applications and analytics, thousands of out of the box KPIs, prebuilt … -
May 21 upcoming webinar: The Future of Customer Experience: Product Strategy Statement of DirectionWe believe 2025 is a line in the sand for customer experience. Envision a world where: Customer experience transcends front (sales, service, marketing) and back-office d…
-
item inventory availability quantitySummary: how could build an report to retrieve the item availability quantity based on organization_id, sub_organization, item_inventory_id and lot number. Content (requ…
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…