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
-
What is and when should the "Synchronize Transaction Workflow Status" process be run?Summary Listed in Scheduled Processes is "Synchronize Transaction Workflow Status" with description "This process ensures that the workflow status is updated correctly i… -
Scheduling ESS JobsSummary Scheduling ESS JobsContent When scheduling ESS jobs to run periodically, it is a good idea to save the seed process ID. That way, if you need to change the sched… -
ESS Job Definition Table NameSummary Which Table Stores the ESS Job Definition Table NameContent Good People, I am just asking the Table Name / View Name that stored the ESS Job Definition Details ,… -
Financial OTBI Index ColumnsSummary This workbook documents index columns in R13.17D Financials OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use d… -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …
-
Multiple Pillar Oracle Cloud implementation whitepaperSummary Leading implementation and configuration best practices for multiple pillar Oracle Cloud ERP implementations Content We have all heard the adage "A chain is onl… -
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. … -
R13 Risk Management OTBI subject area Description documentationSummary R13 Risk Management OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides users a…
-
How to remove the Edit link of an Dashboard when calling it from an Action Link within Fusion ApplicSummary How to remove the Edit link of an Dashboard when calling it from an Action Link within Fusion Application?Content How to remove the Edit link of an Dashboard whe…
-
OTBI Reporting for Project Portfolio Management (PPM) Cloud - Tips and TechniquesSummary The white paper addresses frequently asked questions in OTBI reporting for Project Portfolio Management (PPM) Cloud. It also includes tips to enhance report perf…
-
OTBI Dashboards for AP and AR AgingSummary Graphical dashboards with summary aging of AP and AR debt, with drill-down to invoice detailsContent These dashboards provide a graphical summary of AP/AR debt w… -
Financial reporting center errorHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add… -
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e… -
BI Parameter IssueSummary ORA-01795: maximum number of expressions in a list is 1000Content I have a BI Publisher report with a parameter that gets its list of values from a sql query. If…
-
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying … -
Pulling reports dataContent Hi, Is there ways to pull data from BI report say Payables Register Report using any API and push to staging tables from the external application. I have require… -
Page wise totalContent Hi, I have report which runs for multiple pages assume 20 lines in each page there is requirement to sum page wise total of the amount (which means sum of the am…
-
minimum bandwidth requirement for fusion application to runSummary what is the minimum internet speed / bandwidth requirement for fusion application to run.Content Few of our customers are facing performance issues while using t… -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo… -
How to access Custom ESS Job SetContent Business Users are not able to access the Custom ESS Job Set. We checked the below Oracle notes, but nothing works. How to Grant Execution Privileges to ESS Cust… -
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…
-
Safest/default Path to Publishing changes to GL (Essbase) Trees: Publish Chart of Account DimensionSummary We have been experiencing issues in making changes to GL tree structures in OTBI, so I wanted to be clear on what the options are for each step, to eliminate the… -
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP…
-
OCI – ERP Analytics: Getting Started With Oracle Fusion ERP Analytics, 30 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – ERP Analytics: Getting Started With Oracle Fusion ERP Analytics session to have them answered during the live event. Post you… -
Updating KFF tree versions causes OTBI Analyses to fail when created in “General Ledger – Balances RSummary We are testing changes to the KFF segment values and hierarchies (aka trees). All seems fine with all changes, and GL OTBI reporting until ‘something’ happens an…
-
Page Break in ReportsContent Hi, In he invoice report which is run for range of invoice I am able to print each invoice in new page . For example if the invoice number 100 has two lines the …
-
Financial Reporting Studio Desktop - DecommissionSummary Transition from Desktop to Web toolContent Hi, We are using Financial Reporting Studio Desktop tool since 5 years ago for development of ERP Financial Reports, a… -
Table name of Remit to AddressContent Hi, When I look for remit to address for a country I get the details populated as in screenshot please let me know the underlying table name associated. Thanks
-
ERP – Oracle Digital Assistant: Investment Strategy Update, 03 February 2021, 9 a.m. PT - Submit QuContent Submit your questions for the ERP – Oracle Digital Assistant: Investment Strategy Update session to have them answered during the live event. Post your questions…
-
Which Table Have Review Completed Transactions DataContent Dear , I want to know that which table have review completed transactions data for inventory. if any have query and know the table name please guide me. Kindly c…