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
-
Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionSummary Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionContent Can we still use API - APPS.iby_fd_extract_ext_pub to add… -
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks. -
line feed when displaying getclob() using data model in oracle cloudSummary line feed when displaying getclob() using data model in oracle cloudContent select sysdate, rtrim(xmlagg(xmlelement(e,id,',').extract('//text()') order by id).Ge…
-
How to Pass parameter from ess job to BI Publisher reportSummary How to Pass parameter from ess job to BI Publisher reportContent Hi, I created BI Publisher report with the following parameters: P_BUSINESS_UNIT P_CUSTOMER_NAME… -
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …
-
Lineage document for Oracle Analytics For Fusion ERPSummary This document provides the lineage report from Subject Area to data warehouse table and column.Content Enclosed Oracle Analytics For Fusion ERP subject area to d…
-
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
Risk Management Global Conditions ReportSummary A listing of global conditions including the filter definitions.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and … -
Generate file name at runtime in BI publisherSummary Generate file name at runtime in BI publisherContent Hi We have a requirement to generate the output file name with some custom name appended with timestamp in B…
-
Purpose of BICC Incremental Prune time in MinutesSummary Look for real world advice, or best practice use of setting BICC Prune timeContent Hi, We are just starting to use BICC to extract incremental data from Fusion F…
-
Drill down in fusion BIP ReportsSummary Using drill down functionality in BIP Reports (using BIP template and output in excel)Content Hi, Does anyone use drill down functionality in BIP Reports (using …
-
Payments and Batch details should pull into single row with eText templateSummary Payments and Batch details should pull into single row with eText templateContent Hi Friends, eText payment template file using different groups where always hav… -
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the…
-
BICS migration to OACSummary BICS migration to OACContent Hi All we have BICS on Paas which is not implemented yet and Oracle recommend to migrate to OAC. We need to know do we really need t… -
Generate Summary Metrics for Expenses - Scheduled Process & OTBISummary Seeding Data for OTBI Subject Area: Expenses - Employee Expense Overview Real Time via Scheduled Process - Options and FrequencyContent While working through rep… -
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 … -
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 86 views 6 comments 1 point Most recent by User_2025-02-04-23-19-40-290
-
Data Access by Legal Entity instead of Business UnitSummary How to assign data access to users by Legal Entity using custom Database ResourceContent A client has a requirement for billing managers to manage receivables ac… -
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… -
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…
-
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19C
-
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
-
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…
-
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 … -
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…
-
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…
-
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 …
-
Quarterly Patching - TestingSummary Quarterly Patching - TestingContent Hi I was just wondering what other customers do around the quarterly patching for financials? We tend to read the notes for a…