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
-
BudgetSummary Is there a Actual versus Budget trial balance report already created in Oracle? -
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… -
Copy Oracle Standard Report as Custom ReportSummary Copy Oracle Standard Report as Custom ReportContent I am new to OTBI in cloud version and have tried to create a very simple OTBI report. However, how to copy ex…
-
OTBI - COA HierarchysSummary Only child level of hierarchy's are visible in OTBI - General Ledger - Balances Real Time Subject AreaContent Hello, I want to use the General Ledger - Balances …
-
Configuring Invoice/Payment approval emailContent Dear all, We got an requirement that demo how to configure AP invoice or payment approval template with desired information e.g. add related invoice/PO numbers t…
-
Consignment SalesSummary Consignment SalesContent Hi, We have a requirement consignment sales to be captured/mapped in the Oracle fusion. The business requirement is, they are manufactur…
-
R13 Fuison Financials report listContent Dear all, I'm looking for a list of R13 Fusion Financials all standard reports/analysis. Could anyone kindly share? Thanks a lot Angie
-
Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Summary Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Content Hi, Is there any report in Oracle cloud ERP for Foreign currency transl…User_2025-02-04-13-13-10-537 66 views 4 comments 0 points Most recent by User_2025-02-04-13-13-10-537
-
EFF (Extensible Flex Fields) Business Use CasesSummary EFF (Extensible Flex Fields) Business Use CasesContent Hi, Would like to know EFF (Extensible Flex Fields) Business Use Cases if implemented on any projects. Wha…User_2025-02-04-13-13-10-537 103 views 2 comments 0 points Most recent by User_2025-02-04-13-13-10-537
-
Remove Header from BI Publisher CSV fileSummary Is it possible to remove the header row from a csv file in BI PublisherContent All, We are using BI publisher to extract GL data. We have setup a tab delimited C…
-
OTBI - To Display Sum of a column based on other column in New ColumnSummary OTBI - To Display Sum of a column based on other column in New ColumnContent Hi, I want to Display Sum of a column based on other column in New Column in OTBI An…User_2025-02-03-21-08-45-135 972 views 8 comments 1 point Most recent by User_2025-02-03-21-08-45-135
-
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…
-
ERP Cloud Support - What's Available & How to SucceedSummary Slide deck from the UK OUG session covering tools, procedures, and tips available to Cloud subscribers.Content There's more to support than just creating and man…
-
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 58 views 2 comments 0 points Most recent by User_2025-01-23-21-21-21-128
-
Learning Paths Course CatalogSummary Is there a way to export the learning paths course catalog to excel or word/pdf?
-
ERP Checklist for 19 ASummary Need ERP Checklist for 19 AContent Hello Can some one share the latest pre/post upgrade to do list for ERP R13.19 A I have found one for HCM (R12 -> R13) https:/…User_2025-01-30-02-57-36-931 82 views 8 comments 5 points Most recent by User_2025-02-01-08-03-13-309
-
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… -
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
-
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by row
-
premature availability of BI Output files in SFTP causes problemsSummary BI Output files found in SFTP are available for download before being completely writtenContent I am using BI Publisher within our deployment of Oracle Fusion Fi…
-
Fusion Financials: Configuring Accounting Segments for OTBI reportingSummary This document describes how to configure the accounting segments in Fusion Financials cloud to facilitate consumption of the accounting segments in Oracle Transa…
-
FX Rate Reports from FusionSummary Extract of given days' FX RatesContent Hi There, We are trying to use a report to see what FX Rates were used in Fusion on a given day in the past. The provided …
-
How to open a Financial Report in SmartviewSummary Using FRS- report in SmartviewContent Hi all, We have created a few reports in Oracle Financial Report Studio in Oracle Fusion R11.1.7 We are able to open the re…
-
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
-
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 43 views 3 comments 1 point Most recent by User_2025-01-30-17-50-55-360
-
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 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…
-
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…
-
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 34 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142
-
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