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
-
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg… -
User Logon IP AddressSummary User Logon IP AddressContent Hi Experts Is there any table where Oracle stores the IP Address of an user logon ? We are looking to putting some controls on the I… -
AR Transaction details with receipt details custom OTBI reportSummary Need to link Receipt Application subject area to transaction details subject areaContent Hi, I have created a custom OTBI report with all standard AR receipt det… -
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…
-
Monthly Scheduled report did not runSummary Monthly Scheduled report did not runContent Hi Experts We have a monthly scheduled report scheduled in March and has run fine for first 3 months. The report has …
-
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…User_2025-02-05-22-44-35-842 35 views 0 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter… -
White Paper | Using Seeded Data Extract Services for Oracle ERP Financial CloudSummary White Paper | Using Seeded Data Extract Services for Oracle ERP Financial CloudContent I come through this useful white paper and think it will be useful to shar… -
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 -
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?User_2025-02-07-08-53-49-914 37 views 0 comments 0 points Most recent by User_2025-02-07-08-53-49-914
-
Read Only AccessContent Hi, How to provide read only access to Analysis Report to end users. Please advise Thanks
-
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 …
-
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…
-
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…
-
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…
-
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… -
Unable to access oracle docsSummary Unable to access oracle docsContent Is anyone else facing issue with not being able to access the oracle docs links. We are unable to access the key pages such a…
-
Emailing report based on field on data model?Summary Send report to destination based on field on DM?Content Hi. I'm working on a simple report to show the quantity on hand of items based on subinventory. Each subi…User_2025-02-07-06-48-26-537 30 views 3 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
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…
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…
-
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…
-
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…User_2025-02-06-00-15-19-515 57 views 6 comments 1 point Most recent by User_2025-02-06-00-15-19-515
-
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…User_2025-02-07-08-55-07-914 78 views 4 comments 0 points Most recent by User_2025-02-07-08-55-07-914
-
Payments Subject AreaContent Hi, As attached in the screenshot please advise which subject area need to be used for Payments Thanks
-
Search ParameterContent Hi, How to have parameter with search icon as in Supplier or Party field in Analysis report. 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
-
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…
-
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
-
Extender log fileContent Hi, How to get extender log file of any analysis report, please advise Thanks
-
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.…