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
-
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which… -
Report on Invoice coding approval flowContent Hi, Is there any seeded OTBI report for invoice coding approval flow. If not can you please help with the SQL query to view using BI publisher Thanks -
How do I find the OTBI Analysis behind a standard Infolet for Project ManagementContent Hi, My understanding (from other posts on this forum) is that I should be able to find the path to a standard Infolet by activating a Sandpit in Page Composer mo…
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
BICC PVO Join ConditionsSummary How do we define joins between PVOs and is there any easier way of doing joins between PVOsContent On the older version of EBS one could have written their own q… -
ERP – Introducing U.S. Federal Financials, 13 January 2021, 8 a.m. PT - Submit QuestionsContent Submit your questions for the ERP – Introducing U.S. Federal Financials session to have them answered during the live event. Post your questions by posting a new…Maria Centeno-Cloud ERP-Oracle 31 views 2 comments 3 points Most recent by User_2025-02-10-19-28-21-270
-
Remove last page and logoContent Hi, In the AR invoice report which is run using Print Receivables Transaction the report runs for 132 pages everything is fine but found that it is printing last…
-
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT… -
How to upload Value Set Values which has attribute1 (DFF) ?Summary Needs to upload values which has attribute1(DFF) in Manage ValuesContent Dear All, Good day. Need advice, Would it be possible to upload values which has DFF (At… -
Do BICC and OTBI have access to the same data?Summary Wondering if there any differences in what data can be accessed via BICC vs OTBIContent Am wondering if there any differences in what data can be accessed via BI…
-
Are the tables related to OTBI reports available to report on in OTBI?Summary Would like to monitor changes to OTBI reports at the table level until OTBI reports are being monitored via Audit PoliciesContent Would like to monitor changes t…
-
View ImageContent Hi, View Image from the receivables page is not working for couple of invoices as 90% of the case is successful. This is custom data model and custom template. W…
-
Converting Parameter Timezone on Input - UTC Database vs BST Local IssueSummary Converting Parameter Timezone on InputContent Hi All, We have an issue relating to the database time being on UTC, where our current local time is BST, though I …
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba… -
Fixed Page LayoutContent Hi, In the report the header display customer and invoice header details and the below table display invoice lines. I would like to restrict displaying number of…
-
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…
-
Search ParameterContent Hi, How to have parameter with search icon as in Supplier or Party field in Analysis report. 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.…
-
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
-
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
-
Invoice LinesContent HI, The invoice has 12 lines but in the output I can able to view only 10 lines and I have not set any condition to print number of lines. The output XML has dat…
-
Email BurstingContent Hi, After submitting the Print Receivables Transaction report I found that the table AR_BPA_DELIVERY_DETAILS return no records due to which email bursting is not…
-
OTBI Dashboard to Monitor AssessmentsSummary Includes deep drills to control and assessment records in Risk Cloud pagesContent This dashboard is useful for monitoring and acting on open assessments as well … -
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T…
-
Payment Remittance AdviseContent Hi, I need to customize Payment Remittance Advice report for which please help me the underlying data model and the path of the report attached Thanks
-
Creating Custom Infolets for ProcurementSummary Creating Custom Infolets for ProcurementContent Hi All, Is there a way of creating custom infolets for procurement? If yes, then please let us know the details a…
-
Tax Registration NumberContent Hi, I would like know in which table the tax registration number is stored which is available under Miscellaneous tab in Invoice Header and please find the attac…
-
Risk Management dashboards for COVID-19 recovery, business continuity and surveysSummary Risk Management dashboards for COVID-19 recovery, business continuity and surveysContent * Download the catalog file attached to this post * Within the BI Catalo…