Reports
Discussion List
-
Is there an option or XDO function to print country name using Country code?Summary: Currently, Client is using a DFF to capture country code for Invoices when the payment is made for a foreign professional. These are of type Payment requests an…Abhilash K - Deloitte USI 22 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an… -
Limiting access to folders in custom folderSummary: We want to provide access to only expense folders to expense auditors/expense managers within Custom/Financials and to AP Managers to AP folder and so on. AP Ma…Dibyanshu_Shekhar 31 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…Mickel.Rmeily 54 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
Security Reporting: Who Logged in and When and did whatSummary: Content (required): We need to report on the following areas: Who logged in/out and When? What actions the user has done? Which Pages the user accessed? Which T…
-
Backend table for Payment process request statusSummary: Need to fetch payment process request status from backend Content (required): Hi There, we are building a report where in the customer needs the payment process…
-
Steps to Create BIP Reports type ESS Job with Table type value setSummary: Steps to Create BIP Reports type ESS Job with Table type value set Content (required): Hi All, We have a requirement to create ESS Job for BIP Report with multi…RupaliGahalot 133 views 2 comments 0 points Most recent by RupaliGahalot Reporting and Analytics for ERP
-
Excel generated from RTF template is giving wrong valuesSummary: Excel generated from RTF template is giving wrong values Content (required): I have developed a query to get TransactionDr field from GL Lines table. For a spec…Jaeyshree K K 97 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 52 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 175 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…Donald 401 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
OTBI Report parameters and export optionsSummary:. 1.Check to have the parameters section display always after report is run instead of having to go to catalog and come back again to rerun the report. Update OT…
-
Need the Backend Table Details for Oracle SubscriptionSummary: I want to build a report to get what module/functions are used for my organization/company. Content (required): need the query if any one have handy. Attached i…
-
How can i connect to Essbase in PowerBISummary: We used oracle fusion cloud and able to connect to Essbase using Smartview in Microsoft Excel but when i try to connect to PowerBI using url it gives me error. …Ibrar.bajwa 435 views 2 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Privileges required to view output on a custom version of a seeded reportSummary: Privileges required to view the output of the Import Project Budget report when a custom copy of the seeded report has been created (relevant to any seeded repo…LawrenceKillick 132 views 3 comments 2 points Most recent by LawrenceKillick Reporting and Analytics for ERP -
Bank Payment File FormatSummary: Bank Payment File Format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACC…
-
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us…
-
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 943 views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 71 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Dynamic Logo in FRS reportsSummary Dynamic Logo in FRS reportsContent Hi All, Can we have company logo derived dynamically in FRS reports ? Thanks Version 19CUser_2025-01-30-02-57-36-931 50 views 1 comment 0 points Most recent by Hemalata-Oracle Reporting and Analytics for ERP -
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…Akbar Ahmed 91 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Report to have budget transfers (Control budget)Summary: Content (required): We have a requirement to have a report to include the Budget transfers. We tried to get it from the standard reports however, there is no re…
-
Is it possible to set up automated reports splitting data by cost centre or spare 1 field?Summary: Business has the requirement of splitting a report by cost centre or spare 1 field and sending to different receipts based on the cost centre. This is to send a…
-
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…
-
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…Gene Garcia 1.8K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
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, …
-
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…ks1075 891 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP