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
-
"Supplier - Supplier Real Time"."- General"."Alternate Site Name" with Error: 14025Summary While developing an OTBI Report using two Subject Areas ( "Payables Invoices - Transactions Real Time" and "Supplier - Supplier Real Time"), "Supplier - Supplier… -
R13 Avaliable Cloud Reports in ExcelSummary Avaliable Cloud Reports in ExcelContent Hello : I was wondering if you can share with me the avaliable Cloud Reports in Excel. Thanks for your help Best Regards
-
In Oracle Fusion 20A update Data models will be discontinue or not?Content Dear All, In Oracle Fusion 20A update Data models will be discontinue or not?. And you have to migrate your reports which is created on data models. Can anyone k… -
Viewobjects used in OTBI RPDSummary Viewobjects used in OTBI RPDContent Hi, I've noticed that OTBI RPD queries view objects such as 'oracle.apps.financials.payables.invoices.transactions.publicView…
-
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 … -
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 …
-
Group by Due DateContent Hi, I have output of the report from RTF template as below Due Date Amount ---------------------------------- 01/01/2020 1000 01/04/2020 1000 01/05/2020 1000 01/… -
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… -
Displaying the PO MATCHED DATE from the Procurement Subject areaSummary Displaying the PO MATCHED DATE in PO Details report.Content I want to display PO Matched Date and PO receipt date in my PO Details report. for the receipt date i…
-
Convert number to wordsContent Hi, In the invoice report which has payment terms of 10 months it generates 10 invoices with payment due date, amount and the instalment number say 1...10 The in…
-
ODBC driver returned an error (SQLExecuDirectW)Content I tried to build a report on the subject area 'Payables Invoices - Installments Real Time', by querying the following 5 fields: Business Unit.Business Unit Name …
-
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19C
-
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…
-
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…