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
-
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi… -
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - …
-
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…
-
OTBI DocumentationContent i need a documentation in OTBI , or videos . -
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO … -
Daily Journals Report (Standard Report) in Oracle Fusion does not show Some ParametersContent Dear, Daily Journals Report (Standard Report) does not show Some Parameters it works perfectly but issue is it does not show some parameter which are mentioned b… -
Set background color on subtotal lines in OTBIContent Hi, I would like to set background color on subtotal lines in OTBI Analytics. Does anyone know how to configure about this? regards, Version BIP 11.1.9 bundled w…
-
Fixed FooterContent Hi, Please suggest how to have set of fields fixed to be displayed at the bottom of the page as the report can have single to multiple pages. In all the pages th… -
Any add on to connect oracle Fusion DBContent Hello, Is there any add on to connect Oracle Fusion DB. Because direct database query option is no more 20A update. So how can i query to extract data. I used cl…
-
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at…
-
Payments Subject AreaContent Hi, As attached in the screenshot please advise which subject area need to be used for Payments Thanks
-
Notes field not availableContent Hi, I am not able to locate the field Notes which is available in Payables Invoice Screen in the subject area Payables Invoices - Transaction Real Time Thanks
-
Attribute1 is not foundContent Hi, I am not able to find ATTRIBUTE1 in the subject area Receivables Transactions Real Time. ATTRIBUTE1 definition screenshot is attached Thanks
-
Parameters for custom reportContent Hi, I am registering custom AR report as ESS job but need to have parameters is there any documents/configuration to achieve please suggest Thanks
-
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Unable to add repeating groupContent HI, In the template when I try to add repeating group I get the error as attached in the screenshot Thanks
-
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…
-
Tax Registration from Supplier Address out of Supplier Real Time OTBISummary Looking for Supplier's Tax Registration Linked to AddressContent I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempt… -
Supplier Registration Requests Error tableSummary Supplier Registration Requests Error tableContent We are trying to build a BI Report to send out a notification to the Supplier creation requester whose Supplier…
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Standard report shortcut icon by name on dashboardSummary Seeded Report icons by namesContent There are multiple reports in the Report and analytics Based on client need can we make shortcuts of reports as icon on the d… -
Invoice AttachmentContent Hi, When I have three instalment and when I click View Image from Invoice screen and it would print PDF with three pages which is seeded functionality. The templ…
-
Web API of BI ReportContent Hi, For any custom OTBI or Analytical report is there any Web API (SOAP, REST) as this can be integrated to show the output in other applications. Thanks
-
FTP BurstingContent Hi, I am looking for FTP Bursting in BI report if anyone has done this requirement please provide your inputs to achieve Thanks
-
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…
-
Using parameter within data modelSummary Using parameter within data modelContent Hi, I am using the following parameter within a BI Publisher data model sql where clause : AND PARTY.PARTY_NAME IN DECOD… -
Webservice for Fusion Data ModelContent Hi, Is there any Web API (SOAP or REST) to access Fusion Database objects as read only mode Thanks
-
Financial Tax Register Report Region Wise ESS JobSummary Ability to have a Custom ESS Job for Financial Tax Register Report to associate custom FTR reportContent Hello All, We modified the standard Financial Tax regist…
-
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…
-
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based…