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
-
Roles for BI Analysis ReportContent Hi For an user EMPLOYEE and RESOURCE role is provided is there any other role required to run the BI Analysis Report of the reports related to subject areas of A… -
Read Only AccessContent Hi, How to provide read only access to Analysis Report to end users. Please advise Thanks
-
Create Advanced Financial Controls Report with Deep Link to AP InvoiceSummary This video shows how to create an AFC report in OTBI with a deep link to drill to an AP Invoice. The documents referenced describe the various deep links that ca… -
BIP Report: How can I make default output to open in ExcelSummary BIP Report: How can I make default output to open in ExcelContent Hi Gurus, I am new to reporting.. I have just created a BIP report and I want the default outpu… -
Check In / Check Out Functionality in BIP/OTBI?Summary We are looking for a function that allows code to be 'locked' if checked out by another user.Content Does anyone have ideas on how to 'check out' a data model or… -
Power BI with Oracle CloudContent Hi, Has anyone worked on integrating Power BI with Oracle Cloud. Kindly share details if any Thanks
-
Group by Due DateContent Hi, I have output of the report from RTF template as below Due Date Amount ---------------------------------- 01/01/2020 1000 01/04/2020 1000 01/05/2020 1000 01/…
-
eText Template for Payment BatchContent Hi, In the delimited eText Template it works fine when payment is made for single invoice for a supplier. If invoice batch is submitted (which has more than one …
-
Validation in eText TemplateContent Hi, I need to have validation on the payment date if the payment is made after 17 00 on Friday it should print Monday as payment date For example if the payment …
-
Barcode in ReportContent Hi, I have requirement to print barcode in the invoice report and let me know how to progress on this Barcode number in invoice report will be in the format of …
-
List of Seeded OTBI reports in Oracle ERP CloudSummary List of Seeded OTBI reports in Oracle ERP CloudContent Hi, Is there a way to get the list of seeded OTBI reports from our instance? I would also like to query th… -
OTBI Report on Cross subject areasSummary PPM-AP Cross subject area reportContent We are implementing fusion Financials and PPM. The current practice is, project managers in PPM get to know the details o…
-
Remove SpaceContent Hi, Below is the query which concatenates all the category names and provides in single column value which works fine. I have registered this report as ESS Job w…
-
Drill to Fusion from a BI Publisher ReportContent Hi, I have created a very useful data model that will allow our users to search for payments, what I would like to do is link the invoice numbers to oracle fusio…
-
19C - New FeaturesSummary The 19C - New Features documentation is availableContent Available today - https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/relea… -
Bi Reports Does not Show LOV CorrectlyContent Dear , I created a user defined lov in (Manage List of Values Sources) and then defined into my reports . Reports run correctly with lov but issue is lov filed i…User_2025-02-04-12-49-58-154 55 views 2 comments 4 points Most recent by User_2025-02-04-12-49-58-154
-
Conditional Columns based on ParameterSummary Report Layout change based on ParameterContent Hi , I am using the "Receivables - Payment Schedules Real Time" subject area I want to have a parameter of Entered… -
XML file for Disbursement Payment FormatsSummary XML file for Disbursement Payment FormatsContent All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need…
-
How to change the Quarterly upgrade patch schedule in CloudSummary How to change the Quarterly upgrade patch schedule in CloudContent We are on 18C presently. Can someone help in knowing the process to change the quarterly upgra…
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar…
-
Uprade to Rel 13 (update 18B) common issues and solutionSummary Our Envrionment Recently got upgraded from Update 18A to 18B. Looking for Common issues and solution post upgradeContent Hi Experts, Our Fin/Proc/HCM environment…
-
Suppliers on Purchasing Hold by Supplier Type ReportSummary Dashboard Displaying Active Suppliers On Purchasing Hold By Supplier TypeContent This dashboard will allow you to retrieve a list of your active suppliers that h…
-
Tips and Tricks: Fetch Large Volume of Data using BIP in Oracle CloudSummary Tips and Tricks: Fetch Large Volume of Data using BIP in Oracle CloudContent Hi Experts, Recently I encountered a situation where I was trying to fetch entire Wo… -
R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …
-
BIP Report Output To Content ServerSummary Need to burst BIP Report Output to Content ServerContent Hi As per the oracle doc, I need to add a content server by navigating to Administrator--> Manage BIP --… -
BIP - Asset Details ReportSummary Asset Details ReportContent This report can help in getting extract of Assets from Fusion Assets for reporting , conversion data compare etc.
-
AP Aging reportSummary AP Aging reportContent Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current da…
-
OTBI Report for Change Order Status and StageSummary This report highlights the complete/inprogress/termination statuses of the Change Orders in Project Execution.Content Summary: This report shows the Change Order… -
Linking from a dashboard to ERP pageSummary Linking from a PPM dashboard into PPM pageContent We have a built an OTBI dashboard to display various analyses from the Project Portfolio Management data. The d…