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
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the … -
How to check Agent HistorySummary: How to check Agent History Content (required): As JOb history in BI shows executions of BI reports, do we have similar place to see executions of Agents ? Versi… -
OTBISummary: Hi Experts, I want to measure the performance for last 5 years, the year should be consist the data from July to Jun, instead of Jan to Dec. how I can convert t…
-
Getting an error while trying to open Supplier Master OTBI reportSummary: Unable to open Supplier Master report created in OTBI Content (required): Hi, I have created a supplier master report in OTBI with the fields such as Supplier N… -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is … -
Custom sort OTBI ColumnI have a column in my otbi analysis. They return me the values Exceeds Performance Expectations, Inadequate, Meets Performance Expectations ,Nearly there, No PMS Rating.…
-
Add Segment Description to OTBI ReportSummary: We have a report that uses the subject area General Ledger - Journals Real Time subject area, and we want to add the segment description for our 5 segment. We k… -
Setting Tab Names in Excel When Downloading an FRS ReportSummary Setting Tab Names in Excel When Downloading an FRS ReportContent I have 60+ Company (Balancing Segment) values. When I generate a report in FRS and then download…
-
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …
-
Can the Workflow Transactions Listing report show workflows other than related to invoices?Summary: There is a Scheduled Process called 'Workflow Transactions Listing' which shows pending and rejected transactions related to invoices. Is there something simila… -
Some Prepayment Invoice amount showing doubleSummary: Content (required): Dear All We have an query which will fetch the Prepayment Invoice details , the query is working fine , but it is noticed that some of the i…
-
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…
-
If I have multiple PVOs available for a table column, which one should I select?Summary: While mapping table columns to PVOs, I found in most cases we have multiple PVOs present. What should I consider while choosing a PVO? Content (required): Attac…
-
Moved: What is the subject area of Project Definition DFF on OTBI on Projects module?This discussion has been moved. -
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):
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…
-
Legitimacy of SQL Writing Softwares like Cloud MinerSummary: Content (required): Hi Gurus, Recently, we heard that softwares like Cloud Miner is helpful in writing SQL query in Fusion BI without the need to create a repor…
-
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…
-
How to create deep links with parameters for supplier qualification moduleSummary: As a business requirement, we should create custom Overview page in supplier qualification module. we built a analysis on the new page and when we click on resu…
-
How to use the "is based on the results of another analysis" filter operatorSummary: We created two analysis in OTBI and put them in a dashboard. The one report drills to the second report via action links. The second report is using the filter …
-
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. … -
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…
-
query to get maturity date and cleared date for ar receiptContent in ar receipt i need a query to get maturity date and cleared date
-
Exporting OTBI dashboards in PPT FormatSummary: Content (required): Hi Team, We have a requirement to explore alternative formats to export OTBI dashboards, other than Excel and PDF. One of the potential expo…
-
-
How invoke an Web service using an Analysis in OTBI?Summary: Use an Invoke web service get and push the information in another system Content (required): We have a proposal to active an web service when a field in Transac…
-
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…
-
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…