To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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 …User_2025-02-06-12-21-36-377 15 views 0 comments 0 points Most recent by User_2025-02-06-12-21-36-377 -
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 … -
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…
-
Standard Functionality Regression Testing after patchset applicationSummary How much standard functionality testing you do after patchset application such as 19A, 19B, 19CContent Hello everyone, Just wanted to get a gauge of how much sta…
-
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…
-
Oracle Will Not Support Internet Explorer 11 After Update 19DSummary Oracle Will Not Support Internet Explorer 11 After Update 19DContent Oracle Will Not Support Internet Explorer 11 After Update 19D.Since the release of Microsoft… -
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…
-
Tools for backing up, managing version history of BIP ReportsSummary Looking for tips on how others are backing up or managing versions of BIP reports.Content Our team is exploring the idea of using BitBucket or GitHub (or another… -
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 …
-
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 …
-
Report on Chart of Account Additions/Revision and CancellationSummary Report on Chart of Account Additions/Revision and CancellationContent Hi, Do we have any seeded report in Fusion Financial which gives details information Chart …
-
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… -
manager data access for usersSummary manage data access for users - users without data accessContent On Manager data access for user page what sql or tables do i use to get USERS WITHOUT Data Access…
-
Reports based on SaaS extensions built in PaaSSummary How to created reports consolidating data from JCS-SX and ERP CloudContent Does any one have a documentation or experience on what's is the best way to achive th… -
Barcode in ReportContent Hi, I have requirement to print barcode in the invoice report and let me know how to progress on this Barcode number in invoice report will be in the format of …
-
created_by or last_updated_by - how to find username on those fieldsSummary created_by or last_updated_by - how to find username on those fieldsContent in gl.created_by and gl.last_updated_by I get a number or email address. How do i get…
-
otbi procurement subject areaSummary Has any one used procure to pay real time and pruchasing real time subject area togetherContent I am trying to get po number ,invoice number from procure to pay …