Reports
Discussion List
-
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 899 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
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 …Santosh V-228136 632 views 8 comments 0 points Most recent by Khassham Khan Reporting and Analytics for ERP -
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…Service Desk Claremont 31 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
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, …Swapnil Kashid 266 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
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 … -
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…SireeshaJaladi 31 views 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP -
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 …Robert of STAU 81 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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…Jeff Hainsworth 41 views 3 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for ERP -
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…Sharas Vitalapuram 81 views 2 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for ERP -
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…SivaRamaKrishna-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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…Abhilash K - Deloitte USI 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 212 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
Clubbing of SOA Instances while Invoking a web service using BIP reportSummary Clubbing at SOA instance instead of creating new instance while calling a external web service from SaaS BIP report as a Webservice type of BIP report.Content We… -
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
Oracle Fusion - Process monitor - Process "NAME"Summary: Hi All, I am working on creating a report to have the list of job failed in a specific date range. I am able to get the required information from the ess_reques… -
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…Paul Younes 523 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 132 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
User unable to create report in OTBISummary: User unable to create report in OTBI Content (required): Is there a request that must be submitted for users who have access to various subject area, but are un…CraigX 111 views 5 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…User_2025-01-30-23-52-10-842 163 views 2 comments 0 points Most recent by Mirela Tomoiu-Oracle Reporting and Analytics for ERP -
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …Pritam Das 262 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, …Anders W. Langholm 139 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP -
Payables Multi-Period ReportSummary: HI, Anybody have AP multi-period invoice reports with amortizations? Content (required): Version (include the version you are using, if applicable): Code Snippe…