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
-
Using My Oracle Support (MOS) site as an OTBI Knowledge ResourceSummary Using 'search' box on MOS as additional resource to seek Reporting and Analytics answers/find documentsContent Many a time the issue you are encountering would a… -
Sample OTBI Reports Available - Payables, Receivables, Budgetary ControlSummary OTBI reports covering Oracle Fusion Payables, Receivables, and Budgetary ControlContent In case you do not subscribe to the Business Intelligence and Reporting F…
-
Fusion Financials: Configuring Accounting Segments for OTBI reportingSummary This document describes how to configure the accounting segments in Fusion Financials cloud to facilitate consumption of the accounting segments in Oracle Transa…
-
Linking 2 or more subject areas in an OTBI reportSummary We would like to build OTBI reports but will require to use 2 or more Subject Areas in some reports. What are the key fields to linking subject areas and are the… -
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine…
-
OTBI BIP - Secured List Views for ERP and SCMSummary: With reference to the Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1) - (Refer the document sectio…
-
Which Oracle DB packages are provided in BIP datamodels?Summary: Hello, actually we are looking for an Oracle provided db package with a standard function to convert item weights between item_weight uom codes. I want to use t…
-
TIP: Dynamic deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content… -
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically … -
Is there a plan to deprecate the SOAP webservices related to BIP report & ERP Integration in future?We wanted to check if the SOAP webservices 'ScheduleReportWSSService' and 'ExternalReportWSSService' for BIP reports and 'ErpIntegrationSevice' be deprecated in coming f…
-
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…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…
-
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…
-
Tables for BPM worklistSummary: Let me know the tables which store the below information under BPM Worklist. 1.Task Configured 2.Approval Group 3.Rule Name Content (required): There is "fa_fus…
-
Error in Financial reporting centerHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add… -
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each… -
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly excuted) Is there any way to find. Thanks -
Is there an Archive and purge Strategy for Cloud ERP?Summary: Is there any document or reference guide for Archive and Purge strategy for Cloud ERP and EPM? Content (required): For EBS, we had excellent resources in form o… -
Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i…
-
Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you… -
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…
-
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances …
-
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th…
-
Set Date FormatContent Hi, In OTBI reports is there way to setup the date format globally for all users ? Thanks
-
Display OTBI DashboardContent Hi, I have dashboard report called P2P OTBI Dashboard and to invoke from Procurement Tab I created new page from Page Integration and make it visible from Struct…
-
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …
-
How to create lov field in fusion reportsContent Dear , We have some location so we need lov paramter on report so user select specific location but how i create lov in reports. I tried to create in manage list… -
BI Publisher domain whitelisting - creating exceptions to send out supplier communications?Content We've created a whitelist of Allowed Email Recipient Domains for BI Publisher which is working well for restricting communications and enforcing our Data Loss Pr…