Reporting and Analytics for ERP
Discussion List
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Outstanding Corporate Card Transaction ReportSummary Need to determine who has not processed card transactions through expenses.Content With the corporate card administrator role, we can see there is $xx amount of … -
Using Oracle Database Cloud Schema Service to access Oracle Fusion DatabaseSummary: Using Oracle Database Cloud Schema Service to access Oracle Fusion Database Content (required): in MOS article 1910762.1 it states "If the SaaS / Fusion service… -
FA Asset NVB report output languageSummary: I want to download FA Asset NVB report in Chinese, but it came out in English. How can I change the language even though my preference setting prefers English a…
-
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter …
-
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio…
-
Need a query to get the project actual cost ,committed cost and actual revenue of the project (PPM)Summary: we are developing a BIP report which gives project-wise budget details and actual cost and revenue details. we were able to get the project budget cost and budg…
-
How to select multiple members in one of the dimension? FRS reportsTeam - how can I select multiple values of one of the dimension in FRS report(s)? -
SQL query to generate Fiscal Classification Code on customer profile & site levelSummary: Need help in determining SQL query to retrieve fiscal classifcation code from customer profile & site level. Content (required): Hi all, What SQL query should I…
-
Tables not available for BICCC extraction - what is the alternative?Summary: While configuring data extract from BICCC, we notice that within a data store many tables do not have equivalent PVO. Below are few examples where I could not f…
-
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…
-
How to send the BIP Report Output to Customer without Scheduling Cloud BIP ReportWe need to send BIP Report output to a mail id which is passed as parameter. We have enabled the Bursting it is working. But customer is not accepting to schedule the Re…
-
Data modelling in OTBI?Summary: Hi In Payables (and therefore also in the Procurement subject areas such as Procurement - Spend Real Time) it sometimes happens, that an invoice is matched with… -
How to put current financial year filter to date columnSummary: hi we are developing an Otbi report to find out the revenue recognition amount for the current financial period, can any one suggest us, how to put the filter o…
-
Having issues with BI Report. Wont pass multiple selections on ParametersSummary: I have the following attached report where when attempting to select multiple parameters such as Expense Status or departments I encounter the ORA-00909 error. … -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are… -
Open FRS report using a URL link from BI Tile or similar?Summary: Fusion Financials: How to open a FRS report via a URL link from a BI reporting tile or similar? Content (required): Is there any way to open a FRS report via a …
-
Bi Publisher - How to read the content of an attachment using sql script in data modelHi, We have a requirement in BI Report, to check for the attachment at Supplier Profile and if the attachment is present then we need to read the content of the attachme…
-
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…
-
How to fix envelope section in the first page when there are more than one page output in RTF?Summary: How to fix envelope section in the first page when there are more than one page output in RTF? Content (required): We have a requirement to fix the bottom secti… -
Calling runReport in xmlpserver/services/v2/ReportService Webservice with SSO enabled user(Azure AD)Summary: Hi All, I am working on calling a BI Publisher report from a custom application using xmlpserver/services/v2/ReportService webservice. The requirement is to use…
-
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…
-
Getting the error 'ORA-31011: XML parsing failed' when calling the SAAS report through webserviceSummary: I am getting the below error when calling the SAAS report through webservice call from my pl/sql procedure. 400 Bad Request 400 Bad…
-
"FAWService" Oracle Account is consuming Oracle Cloud Fusion LicenseWe have ran order built "UserPrivilegesByService" report and found "FAWService" which is an Oracle Account is consuming licenses due to "Supply Chain Planner" role. Plea… -
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…
-
Oracle Fusion - Trying to recreate an OTBI analysis using a custom reportWe have created an OTBI analysis that displays the following categories: Account Code, Invoice Distribution Amount, Accounted Amount CR, Accounted Amount DR, Invoice Num…
-
How do I get my .csv output columns in same order as ExcelHow do I get my .csv output columns in same order as Excel? Thank you. Esmeralda -
Editing a page using sandbox subjected to a user roleSummary: Content (required): Hi All, We have a requirement to publish the dash boards created using OTBI analysis in the 'My Dashboard' page. However, the published dash…
-
Connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data SourceSummary: Is it feasible to connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data Source ? If yes, can you provide us with any white paper docu…
-
ERP Cloud - Export Table Using Saved QuerySummary: is there functionality in ERP Cloud similar to OTM Cloud Export Table using query? Content (required): OTM has ability to run custom SQL query and extract resul…