Reporting and Analytics for ERP
Discussion List
-
How to make the Field "Requester" Mandatory on AP Invoice- Form PersonalizationSummary How to make the Field "Requester" Mandatory on AP Invoice- Form PersonalizationContent Hello: Does anyone has a paper or instructions on how to make the Field "R… -
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Can we get the dynamic url in BI Publisher email notifications?Summary: When we schedule a custom BIP report, and once it is completed then system is sending an email notification with the status. In the email notification there is …
-
Give access of OTBI report to usersSummary: Hi We have build an OTBI report from a user who has BI Author role. And we need to give access of this report to other users. we have used Permissions in the OT…
-
Fetch large volume of data in BI publisher reportSummary Fetch large volume of data in BI publisher reportContent HI We have a requirement to extract data for GL code combinations using BI publisher and burst the outpu…
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details… -
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…
-
How to generate XML Positive Pay File in COS payments formatSummary HSBC bank needs XML Positive Pay File in COS payments formatContent ERP Cloud customer is engaging with HSBC for payment processing. Customer will continue to pr… -
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded… -
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the … -
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be… -
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, …
-
Is there a size limit for email attachment for BI reports?Summary BIP - Report size is 15MB, job succeeds but never sends email.Content My report generates 15MB excel file but fails to email the report every time. I limited my …
-
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …
-
Copying personal custom Dashboard to Shared Folder > Custom > Dashboards throws Error Codes: QM3V3HSummary: Moving a personal dashboard to shared folder throws error Content (required): User has a custom Dashboard created in My Folder >Dashboards They want other users…
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, … -
How quickly does Oracle make updates to federal reports?Summary: When the federal government makes changes to a federal form, such as the Federal Financial Report (FFR), how quickly does Oracle make this change to the report …
-
What are the steps to enable & implement SAML authentication in Oracle fusion & also at client sideSummary: We are using SOAP APIs host://idcws/GenericSoapPort operations - GET_FILE, GET_SEARCH_RESULTS, UPDATE_DOCINFO for consuming data from UCM that is extracted via …
-
How to move up one node in my xmlSummary: Getting data from one node up of xml Content (required): I have a template that gets the data from node . I need to also display columns from which is one leve…
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
Remove ability for users to edit FRS reportsSummary: Users have the ability to view and edit FRS reports through the "Launch Financial Reporting Web Studio". Content (required): We would like to know how we can re…
-
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…
-
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 …
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…
-
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…