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
-
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 -
Our Client want to whitelist the URL https://*.fa.em2.oraclecloud.com/publicFinancialCommonErpIntegrSummary we are using the URL https://*.fa.em2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL to submit the Bulk Import for the Finanacial… -
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…User_2025-02-04-12-49-58-154 82 views 6 comments 1 point Most recent by User_2025-02-04-23-19-40-290
-
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…User_2025-02-06-00-02-39-946 59 views 4 comments 0 points Most recent by User_2025-02-06-00-02-39-946
-
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…User_2025-02-05-10-39-37-202 36 views 1 comment 0 points Most recent by User_2025-01-28-16-10-52-033
-
ERP – Things to Know About Updates, - 13 November 2019, 8 a.m. PT - Submit QuestionsContent Submit your questions for the ERP – Things to Know About Updates session to have them answered during the live event. Post your questions by posting a new commen…
-
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 …
-
Is there any Localization Reports for EcuadorSummary Is there any Localization Reports for EcuadorContent Hello I was wondering if there is any localization reports for Ecuador ? Please Advise
-
Newsfeed layoutSummary Newsfeed layoutContent I got mixed reactions from the customers when enabling the newsfeed layout. Some like the look and feel others prefer the more efficient n…
-
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…
-
GeoCoding for locations attached to business unitsContent Hello, This might not be the right forum but not sure where to post it. We have a requirement where we would want to know the latitude and longitude information …
-
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 29 views 4 comments 1 point Most recent by User_2025-02-06-12-21-36-377
-
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 …User_2025-02-06-12-21-36-377 14 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…