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
-
Is it possible to repete LOV(Data validation)to each row in BI Excel template outputSummary In the excel template row grouping we have created LOV for a single column, while generating excel reports and LOV applied to first row only, I need to repeat LO… -
General Ledger LOB SecuritySummary Creating LOB Security for General Ledger ReportsContent Hi I am reaching out to see if anyone has solution for creating Line of Business security for users to ru… -
OTBI: Receivables - Transactions Real Time Subject AreaSummary OTBI: Receivables - Transactions Real Time Subject Area don't show collectionsContent I am trying to develop a report on this subject area to show the customer a… -
Can't aple to run General Ledger Trial Balance ReportSummary error file after submit proceessContent Hi when create schadual process for General ledger trial balance report error log file attached is comming Thanks
-
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran… -
Creating Custom Account Analysis ReportSummary Create Account Parameter(Similar to Oracle seeded Account Analysis Report) in Custom BI report(ESS Job)Content Hello, I am creating a custom bI report similar to… -
Receivable Aging ReportSummary issues when selecing multiple ledgersContent Hello all, Did anyone manage to customize the Receivables to Ledger Reconciliation Report in order to select multipl…User_2025-02-04-08-34-10-102 57 views 2 comments 0 points Most recent by User_2025-01-23-21-21-21-128 -
BIP Report to read file from UCMSummary Need to read file in UCM using BIP ReportContent Hi Team, Could you please let us know whether it is possible to read file from UCM via BIP report ? If anyone ha… -
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R… -
How to stop notifications for PO's at instance level.Content How to stop notifications/transmissions for Purchase Orders at instance level? Version Rel 13 19A -
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… -
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, Nishanth -
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w… -
Is there a way to pass parameters to an Infolet?Summary Need to convert a report that passes a parameter into an infolet so I can easily share it with many users that are not familiar with running BI Publisher reports… -
EFF in Fusion ERPSummary EFF in Fusion ERPContent Hi All, What are EFF Flexfields in Fusion Financials and how to access them from OTBI subject areas and their tables. Thanks -
How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud? Please Find attached Screen shot explaining the issue in detail. Your re… -
19A UBL 2.1 XML format using CMKSummary Is this configuration needed if we are using Oracle Supplier Network?Content We are using Oracle Supplier Network with Collaboration Messaging Framework to recei… -
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… -
Any way to pull Previous year's generated 1099s?Summary Any way to pull Previous year's generated 1099s?Content We are reviewing our 1099 process and wanted to look at what we have generated in previous years... Is an…User_2025-01-29-23-00-32-611 42 views 3 comments 1 point Most recent by User_2025-01-30-17-50-55-360 -
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…User_2025-02-01-06-21-55-603 44 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142 -
OTBI Dashboard - Drilldown FunctionalitySummary OTBI Dashboard - Drilldown FunctionalityContent Can anyone provide me with guidance on the exact URL that should be used with OTBI dashboard to drill down from O… -
Learning Paths Course CatalogSummary Is there a way to export the learning paths course catalog to excel or word/pdf? -
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by row -
BI report parameter entries - allow manual entries or search a value in the drop-down listSummary Need to allow users to make manual entries or click on the drop-down list to search for a report parameterContent All of our BI reports are set up with a drop-do…User_2025-01-25-04-50-08-084 57 views 14 comments 3 points Most recent by User_2025-01-25-04-50-08-084 -
SOC-1 Qualified Audit Opinion - How Are You HandlingSummary How are you handling the SOC-1 Qualified Audit OpinionContent Hi Everyone, I was wondering how everyone was handling the Qualified Audit Opinion on the cloud SOC… -
Print Receivables Transactions: Email Delivery --Override email address for non prod instanceSummary How to override or block emails to customers in non prod instanceContent For Print Receivables Transactions-Email Delivery , Is it possible to have an override e… -
Auditing in Fusion FinancialsSummary Auditing in Fusion FinancialsContent Hi All, Need help on auditing: 1. What is Auditing in Fusion Financials(WHO has changed WHAT and WHEN) and why it is .requir… -
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 -
Descriptive Flexfields capabilities in FusionSummary Need to understand Descriptive Field Flexfields capabilitiesContent Wants to understand a point of view on the following points: 1. How security can be enabled a…