Reporting and Analytics for ERP
Discussion List
-
How to group and show as one figure the "Cost". At present its coming as two linesSummary How to group and show as one figure the "Cost". At present its coming as two linesContent How to group and show as one figure the "Cost". At present its coming a… -
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… -
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…
-
FRS - best practice for drilldownContent We are building a reporting tree for Natural Account using the Segment Hierarchy Interface, in which parent/child is not 1:1 since some accounts fall into multip…
-
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 …
-
Substitution Variables in FRSSummary Substitution Variables in FRSContent Can anyone please direct me to documentation on how to set and administer substitution variables for use in Financial Report…
-
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…
-
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 …
-
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…
-
Scheduled Report increment dateSummary CAn we schedule a report with incremented date?Content Some reports require a date parameter. In EBS, there is a way so that a scheduled report’s date parameter … -
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 … -
Reporting on ReceiptContent Hi, I'm looking for two reportson receipts: Actual Receipt Report: A report displaying all purchase orders and every receipt (including date of receipt, amount o…
-
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…
-
OTBI - Display the row of SUM onlySummary How can I edit the OTBI report to display the row of count and SUM only?Content I built a report to display the 'count of invoice number' and 'SUM of invoice amo…
-
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…
-
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…
-
Error in BI Desktop InstallationContent Hi, During BI Desktop installation I finding the error as attached any inputs will be helpful Download URL : https://www.oracle.com/middleware/technologies/busin… -
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…
-
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…
-
eText Template for Payment BatchContent Hi, In the delimited eText Template it works fine when payment is made for single invoice for a supplier. If invoice batch is submitted (which has more than one …
-
Validation in eText TemplateContent Hi, I need to have validation on the payment date if the payment is made after 17 00 on Friday it should print Monday as payment date For example if the payment …
-
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…
-
ORDSSummary Ad Hoc Question on Oracle REST Data ServicesContent Is ORDS free if you use Fusion SaaS? I went to a presentation on Oracle Rest Data Services at Open World and …
-
SQL Table to bring in Audited by from the AP module to a BI reportSummary SQL Table to bring in Audited by from the AP module to a BI reportContent I am searching for the SQL table to bring in Audited by from the AP module to a BI repo…
-
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… -
In Fusion Applications Update 19D, Oracle will discontinue the Direct Database QueryContent Dear , In Fusion Applications Update 19D, Oracle will discontinue the Direct Database Query. meaning you will no longer be able to create, modify or run these ty… -
Drill to Fusion from a BI Publisher ReportContent Hi, I have created a very useful data model that will allow our users to search for payments, what I would like to do is link the invoice numbers to oracle fusio…
-
ESS Jobs to be run to create Cube'sContent Hi Team, Can you please let me know the list of steps to be run to publish the data to cube, so that we can design FRS reports. I'm working on FRS reports, when …
-
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…