Reports
Discussion List
-
OTBI Customer SurveyContent Oracle BI development is planning OTBI feature improvements. To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting …User720640-Oracle 25 views 0 comments 0 points Most recent by User720640-Oracle Reporting and Analytics for ERP -
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 89 views 0 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for ERP
-
Deprecating BI Publisher connectivity to the Oracle Fusion TablesSummary Restricting access to Fusion Cloud database via BI Publisher Data ModelContent Heard that Oracle is planning is to restrict the access to Oracle Fusion cloud tab…Senthilrajan V 70 views 7 comments 3 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19CTony Roff 47 views 1 comment 1 point Most recent by User_2025-02-06-00-59-55-679 Reporting and Analytics for ERP -
Table name that stores purchase order attacmentsContent Hi all, please, we are developing a report that should retrieve the purchase order's attachment name. Do you know the table name where attachments are registered…Caio Zioli-Oracle 62 views 1 comment 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Can we have an alias in OTBI Analysis Subject AreaSummary Can we have an alias in OTBI Analysis Subject AreaContent Can we have an alias in OTBI Analysis Subject Area like below, or is there another way. SELECT SubjectA…
-
Reporting: Can we use Nitro in Oracle ERP Cloud as an alternative to PDF Adobe AcrobatSummary Reporting: Can we use Nitro or any other reporting product in Oracle ERP Cloud as an alternative to PDF Adobe Acrobat.Content Instead of using Adobe Acrobat for …User_2025-02-06-12-21-36-377 28 views 4 comments 1 point Most recent by User_2025-02-06-12-21-36-377 Reporting and Analytics for ERP -
Create smart view report using querySummary Create smart view report using queryContent Hi All, We have created an Oracle BI report to display PO related details using query. And we would like to implement…Anjali Ravichandran 52 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Reporting: Can we use Nitro in Oracle ERP Cloud as an alternative to PDF Adobe AcrobatSummary Reporting: Can we use Nitro or any other reporting product in Oracle ERP Cloud as an alternative to PDF Adobe Acrobat.Content Instead of using Adobe Acrobat for …User_2025-02-06-12-21-36-377 12 views 0 comments 0 points Most recent by User_2025-02-06-12-21-36-377 Reporting and Analytics for ERP
-
are there any SOAP/REST services available to Execute Report using JWT token instead of username andSummary are there any SOAP/REST services available to Execute Report using JWT token instead of username and password?Content Hi Team, Are there any SOAP/REST services a…
-
SQL gives me wrong purchase order number for invoiceContent Hi, When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753 When I do … -
Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one rowSummary ORA-01427Content I am using Oracle Fusion, the finance/payables reporting side of things I have the following code: SELECT DISTINCT PHA.SEGMENT1 FROM AP_INVOICES…
-
Which table stores 'Transaction Number' in Project CostsSummary Looking for backend table that stores 'Transaction Number' in Project CostsContent Hi All, I'm looking for backend table that stores 'Transaction Number' in Proj…Sumanth Kunimakki-21932 302 views 7 comments 0 points Most recent by Rasu P Reporting and Analytics for ERP
-
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat…
-
Change Order History on POSummary Status, Amount and Qty of POContent Hello, How and what fusion tables can I get the status, calculated amount and quantity of a change order? Basically get the l…
-
Policy Predicate ErrorSummary When querying some tables and views we are getting Policy Predicate ErrorContent Selecting data from per_person_names_f or hz_parties is giving a policy predicat…User_2025-02-05-18-28-58-388 27 views 12 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
OBIEE 12c / Financial Reporting Studio usage with Oracle Fusion Financial CloudSummary Financial Reporting Studio for Customized Reporting needContent Hi, With earlier releases of on premise ERP products from Oracle we used OBIA for any seeded / cu…User_2025-01-29-01-36-29-977 135 views 4 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Financial Reporting Studio will not work after installationSummary FRS installed, but error message says it is not installed.Content FRS was installed according to Doc ID 2051105.1, and computer shut down and rebooted. Get the f…User_2025-01-31-00-03-48-847 49 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Oracle BIP Report RTF Template - Distribution Accounting Date DisplaySummary Oracle BIP Report RTF Template - Distribution Accounting Date DisplayContent Hi All, Hope you are doing well. Could you please suggest me on below rtf template r…OraFusionworld 40 views 4 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
Balance Sheet totals different for different usersSummary Balance Sheet totals are different for two different users, same reportContent Two users in our office have opened the same Balance Sheet report, same parameters…User_2025-01-31-00-03-48-847 34 views 5 comments 0 points Most recent by User_2025-01-28-21-13-11-074 Reporting and Analytics for ERP
-
Error while customizing BI Publisher ReportSummary We are trying to customize the Account Analysis Report (ESS Job Name - Account Analysis Report) but getting error while trying to modify the data modelContent Hi…Sudha KOVURU 91 views 10 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
Public Sector - budget to actualsSummary Budget to Actuals reports in Public SectorContent Hello, Have any other public sector Oracle Cloud users developed a good budget to actuals report? We have one t… -
OTBI computed field and graphSummary creating computed field and graphContent Hi all, I am very new to Oracle Fusion business intelligence. Background: * Fusion 19C * try to analyze the company's em…User_2025-02-06-11-24-12-541 40 views 0 comments 2 points Most recent by User_2025-02-06-11-24-12-541 Reporting and Analytics for ERP
-
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has …Jennifer Wolfe 56 views 5 comments 1 point Most recent by Michael Cook Reporting and Analytics for ERP
-
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…User_2025-02-05-07-46-04-895 110 views 3 comments 2 points Most recent by Rasu P Reporting and Analytics for ERP
-
What role can be assigned to give a user OTBI access for report writing?Summary What role can be assigned to give a user OTBI access for report writing?Content What role can be assigned to a user for OTBI access for report writing? I can see…User_2025-01-31-00-03-48-847 105 views 6 comments 1 point Most recent by User_2025-01-31-00-03-48-847 Reporting and Analytics for ERP
-
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t…Thiru Vedantham 530 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Journal Entry Reserve LedgerSummary Customization of the Journal Entry Reserve LedgerContent I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change…Elliot Hall-Walker 76 views 1 comment 1 point Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…User_2025-02-05-07-37-39-271 55 views 4 comments 0 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP