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
-
Moved: BPM Workflow Invoice Approval - Standard ReportThis discussion has been moved.
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …
-
Give us your feedback - OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…
-
OTBI Report filter for first and last date of current monthSummary: Hi Team, I am scheduling an OTBI report. We have accounting date between parameter in report. I am adding filter to OTBI report and want system to take first an…
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
Calculated measure questionSummary: Building multiple columns based on aging Content (required): I have defined a report that gives me the amount due on an invoice and it's related aging value. I …
-
Calculated Measures issueSummary: Calculated Measures when null value exists Content (required): I have two measure. The one being invoice amount and the other being invoice paid amount. For bot…
-
Borders are not displaying in Word(.docx) outputSummary: Borders are not displaying in Word(.docx) output Content (required): Hi Experts, We develop RTF with borders, but when we run the output as .docx borders not di…
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su…
-
Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time"Summary: Role required for viewing otbi subject area "Project Costing - Actual Costs Real Time" without allowing them to run Import Costs and Import Commitments schedule…
-
AR Transaction status in OTBII am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Recei…
-
OTBI QuestionsSummary: Content (required): In "Payables Invoices - Transactional Real Time" subject area, why do we have so many invoice currency fields and why some of them are givin…
-
Digitally Sign BIP report sent to SFTP server using BurstingSummary: Hi Team, Once we set up the SFTP server in fusion as a delivery option, there is a checkbox to sign output. So does it digitally sign the file and it will use w…
-
Oracle Fusion Cloud - SQL script logic to calculate Period to Date (PTD), Quarter to Date (QTD) andSummary We are working on Custom Trial Balance Report development and need logic to calculate PTD, QTD and YTD Balances into Oracle Fusion Cloud.Content Hi Team, We are …
-
API to manage BIP Catalog ObjectsSummary: Content (required): We have a CatalogService WSDL to download and upload catalog objects, however, that API asks for passing the username and password in the Bo…
-
REST API to schedule and run report in Oracle Fusion BIP reportsSummary: REST API to schedule and run report in Oracle Fusion BIP reports Content (required): Version (include the version you are using, if applicable): 22D Code Snippe…
-
Need help in understanding the BIP SQL query (new to SQL and BIP)Summary: Hi Experts I'm new to SQL and BIP reporting. I'm working on one BIP report and I have added parameter to an existing BIP query to filter based on item number, a…
-
How to add customer number field in Manage and create receipt screen?Summary: How to add a customer number field in Manage and create receipt screen? Content (required): How to add a customer number field in Manage and create receipt scre…
-
Invoice History Report for a given supplierHi All Is there any standard report which allows to drill down open closed invoices per supplier and also drilldown to the individual invoices via deeplinks ? Thanks Mur…
-
Has anyone use SplashBi or Orbit Analytics before?Summary: We are reviewing some external vendor tools to work with Oracle EBS and want to know if anyone has used this before and can make some recommendations. Content (…
-
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…
-
Customizing Print Receivable Transactions: Invoices ReportSummary: We have this seeded report "Print Invoice Template" (Defaultinvoice.xdo) which has a corresponding ESS job "Print Receivable Transactions: Invoices" which is a …
-
FRS report duplicating parent when opening in BI catalog, but does not when opening in WebStudioSummary: Content (required): Hello: Does anyone have an idea why a row would duplicate for a parent when opening the report from the Catalog, but not when opening viewin…
-
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…
-
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…
-
Is it possible to group pages members to create a new structure in Financial Reporting StudioSummary: Within Financial Reporting studio , I would like to create a balance sheet for different cost centres , but have a collection of cost centre grouped for each pa…
-
Grouping Columns into oneSummary: Is it possible to group different members into one column in financial reporting studio Content (required):Financial reporting studio Version (include the versi…
-
Report on Report Usage in FRSSummary: I am trying to gather information on which users run which reports in FRS. I have created an OTBI Usage report but that report does not include reports in the F…