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 and Analytics for ERP
Discussion List
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de… -
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…
-
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
Pricing List ReportHi, I am looking to create BI publisher report on Pricing List. If you can share the query and RTF template if any available please do share Thanks -
Is it possible to generate a list of Oracle Fusion users and the method they use for authenticationSummary: Is it possible to generate a list of Oracle Fusion users and the method they use for authentication (SSO or Local authentication)? Content (required): Is there …
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
How to print "All" value in the output if BIP report is run for all parameter valuesHello Oracle Gurus, I have a requirement where the user is running the report with all parameter values. The parameter is Source. Currently if the user runs the report f…
-
Showing Payables Invoice Lines with Amounts for Net, VAT and GrossSummary: Users require indirect taxes for payables invoices to be shown against each line, thus for each invoice line they want to see line amounts for Net, VAT, Gross. … -
How to call an OIC integration from BIP reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Can BI Publisher be used to send XMLs in UBL 2.0 format? If yes, please elaborateSummary: At my client all financial transactions in Receivables are subject to archiving at a 3rd party. The client wants to be able to leverage the Generate Bill flag o…
-
Audit log for the Manage Audit policies setupSummary: The Auditors wants to know when the Manage Audit Policies was enabled and the when the Audit policies were updated latest. Content (required): Log for Manage Au… -
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
How to apply font color conditionaly in BIP ExcelSummary: We are currently building an audit report in which changes should be highlighted. The report contains values before and after. If value after is different from …
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…
-
How to add sequence number & date in BI excel templateHi, I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence numb…
-
Can we add attachments using sandbox?Summary: We have a business requirement that the users wants to attach documents in the Supply Request Form. Can we add attachments '+' using sandbox? kindly guide us ho…
-
How to Zip BIP output containing multiple output filesSummary: Content (required):We are trying to download zip file(containing all output files for particular schedule) using Compress output prior to delivery. Version (inc…
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
Filter function in case statement in otbi columnIn my otbi analysis, I tried to add this formula in my column CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet…
-
How to hide parameters in csv output and change data formatHi All, I'd like to create a report which output type is csv. After the output file was generated, I found the parameters of report are included in the output file and o… -
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D… -
In OTBI GL- Balances Real Time subject area 1 segment is missing from the Subject AreaSummary: Since second balancing segment label doesn't have the BI Object Name, we have created the custom label and given BI Object Name to add the Fund segment along wi… -
SFTP bursting to home directoryHi All We have an issue delivering files to "\" directory for a vendor.. There are no sub directories and oracle documentation mentioned \ should not be used. and when n… -
Limitations on number of Invoice lines that can be printed / generatedSummary: Business has a requirement to print Aggregated Invoice via ESS Scheduled Process/ Reports Business wanted to know if there would be a technical limitation on th…
-
Attaching BI Report to OTBI DashboardSummary: Hello, I want to attach a BI report to OTBI Dashboard and connect it with dashboard's prompt. Question 1: Can I attach and view a report made from FSCM Tables (…
-
Template for large BIP reportHi Which template is it recommended to use if we need to generate reports which require layouts with many columns. Using the wizard for creating .xpt reports, it is diff…
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23… -
Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties… -
Can we create custom table in Oracle Fusion without PAAS license?Summary: Is there any way to create custom table and store the data in Oracle Fusion Order Management or any other supply chain application without PAAS license? Client …
-
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…