Reporting and Analytics for ERP
Discussion List
-
Subject Area for BMP Workflows / How long to approveSummary Subject Area for BMP Workflows / How long to approveContent Is there a subject area for BMP workflow? I'm looking for a query to tell how long project related ap… -
Goals Report - Quarterly reviewSummary Unable to find columnsContent Hi, I've been asked to build a Goals report that contain the following fields that I cannot seem to find in any of the Goals Subjec…
-
Parameters not available in favouritesContent Hi, If any analysis report is displayed under Favourites it is not displaying with parameters. Is this the actual behaviour please advise Thanks -
on cx how i get table for custom table ?Content in cx in service when create a work order , we created a field assign to and setup it in custom table. i need to create a report and get value for field assign t…
-
How to Extract Approval Rules Created for Contract Created in BPMContent Hello, We need to extract Contract approval Rules created in BPM. How to achieve that? -
Logo in OTBI AnalysisSummary Getting error when uploading images into OTBI analysis from local driveContent Hi All, I am getting below error when uploading logo image into an OTBI analysis u…
-
Subject Area for Receivables Recurring Bill PlanSummary Looking for debit authorization number in bill planContent Hello: I am looking for the subject area that will house the debit authorization number (bank account …
-
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
-
Add Period Date to Parameter Default ValueSummary How to add current 'MMM-yy' in Parameter Default ValueContent Hi, I would like to set my default value for my Parameter as current 'MMM-YY', so in today's instan…
-
In what table is stored the transaction reference?Content Hi. Where is stored the inventory transaction reference accessed via the "Edit details" button in the "Create Subinventory Transfer" form? Thanks! Version Fusion…
-
Best practice to control the folder permissions in Reports and AnalyticsContent We have the same requirement, or at least the same issue as described in this topic (https://cloudcustomerconnect.oracle.com/posts/b07532cb8d) , but prefer to ma… -
Lines Getting RepetedContent Hi, I created receivables lines analysis report using Receivables Transaction Real Time and found that having duplicate lines getting displayed why is this so ca…
-
convert column data to rows(pivot)Content i create sql statement and the result is customer period No_of_invoices Cust1 Jan-2020 7 Cust1 feb-2020 9 Cust1 mar-2020 4 Cust1 apr-2020 6 Cust1 may-2020 3 Cust…
-
Subject Area - Payables Invoices - Transactions Real TimeSummary Not able to find taxes - Transaction Tax section under Subject Area - Payables Invoices - Transactions Real TimeContent Hi All i was building OTBI report for bus…
-
Oracle R12 Customer wise Partno wise backorder query in Oracle Fusion.Summary Customer wise partno wise backorder query.Content Hi, We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Orac… -
Can a BI report be scheduled to email an excel attachement using Schedule Report JobSummary Email an excel attachement of BI report OutputContent Can a BI report be scheduled to email an excel attachment using Schedule Report Job? When scheduling via th…
-
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
-
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage …
-
Where to find customer GST number field and from which tableSummary Where to find customer GST number field and from which tableContent I need to find customer GST number field and from which table to get it
-
Page Entry For OTBI DashboardsSummary How to Create page Entry for OTBI DashboardsContent Hi There, We have a requirement where in we want to have the page entry created for our dashboards. We dont w…
-
Search ParameterContent Hi, How to have parameter with search icon as in Supplier or Party field in Analysis report. Thanks
-
Procurement - Pending Change Order - Pending ApproverSummary Procurement - Pending Change Order - Pending ApproverContent Hello All, I am trying to get the the "Pending Approver" of a pending Change Order. Let me know if a… -
Extender log fileContent Hi, How to get extender log file of any analysis report, please advise Thanks
-
Scheduling Reporting & Analytics Analysis reportsSummary Need information on invoking an action to change subject description of emailed reportContent Hello: Can someone help with detailed information on how to change …
-
No ResultsContent Hi, When I view the results of the report using subject area Payables Invoices - Transactions Real Time I am not able to fetch any records as it says No Results.…
-
Two Subject AreaContent Hi, Is it possible to create analytical report using two subject area as I found few column values in different subject area Please suggest Thanks
-
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…
-
Amount Column MappingContent Hi, In Receivables I would like to know under which subject area and folder does the two fields are available Invoice Amount, Balance Amount Thanks
-
OTBI Analysis Agent - Enable to see Email ToSummary OTBI Analysis Agent - Enable to see Email ToContent The OTBI Analysis Agent when send's the extract based on the analysis, the recipients list is not showing in …
-
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