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 … -
Table for Bursting Output ResultsSummary: Does anyone know what table has the results of an individual bursting output from a scheduled BIP report? From the screenshot above you can see that we have one… -
Query on Retained earningsSummary: Retained Earning adjustments in Secondary Ledger Content (required): I have gone through this doc id Oracle General Ledger Year End Closing Process (Doc ID 6653…
-
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…
-
Download the zip file (Authorized Hosted Named Users.zip) does not workSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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 …
-
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…
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, Ramu
-
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… -
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… -
Report for License ConsumptionSummary: Simply do not know how to pull a report that tallies license consumption by user. Content (required): Can someone provide the report or directions for reporting…
-
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…
-
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 add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…
-
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…
-
Month end closure jobs in Oracle ERPSummary: I have a requirement to run the below jobs on demand in serial (one after another with single job set) Translate General Ledger Account Balances (Multiple Ledge…
-
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. … -
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):
-
ERP Adaptor service to get Parameter Values of ESS JobHi, Is there an out of the box service (in ERP adaptr or REST API) to get the parameter details of the ESS Job if we provide the ProcessID ErpIntegrationService --> getE…
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…
-
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…
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …
-
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… -
-
Cost Center wise access to different users to view Financial ReportsSummary: We have a requirement where the client is expecting access to Financial reporting on the basis of Cost Centers authorized for the user. Content (required): For …
-
What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"?Summary: What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"? Exist Fixed Assets role for Self Service Cloud Service? Exist Payables r…