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
-
How to get Request Id at runtime for the BI-Publisher ReportSummary How to get Request Id at runtime for the BI-Publisher ReportContent In the custom reports, the business users are expecting to capture the Request-Id/Report-Job-… -
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp… -
Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g… -
How can i find BI Tables easily?Summary How can i find BI Tables easily?Content How can I find BI tables where specific data is stored, I spend so many times trying to map and also get a table I want f… -
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…
-
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… -
How to get Projects Cross Subject Area Analysis to show projects both with and without Billed AccounSummary How to get Projects Cross Subject Area Analysis to show projects both with and without Billed Account NameContent I have created a simple analysis using Projects…
-
ce_available_transactions_vSummary Recreate ce_available_transactions_v in OACContent Hello all I'm trying to recreate 'ce_available_transactions_v ' in Oracle Analytics Cloud (either via replicat…
-
Audit Policy Performance ImplicationsSummary Will enabling Audit have any performance or other implications?Content We are looking to define Audit Configuration for Business Object Attributes. I am wonderin… -
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…
-
in otbi create analysis from 2 subject areaContent can i create analysis from 2 subject area ? if yes i need an example
-
on otbi create conditional format for rows not columnContent can i create conditional format to become a row is green ? not for column
-
last item costContent i need a query , to get last item cost.
-
How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…
-
FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …
-
FRS search members by description starting with, Ending with, ContainsSummary FRS search members by description starting with, Ending with, ContainsContent Our client doesnot have specific values for each row. Instead they have conditions …
-
generating more than 75k record in OTBISummary generating more than 75k record in OTBIContent Is it possible to exceed the limit of 75k records in OTBI by importing an OTBI report as a data model in BI? Versi…
-
Publish reference document within Oracle FusionSummary Is there a way to publish reference document or link to a reference document within Oracle FusionContent Our Finance department is currently engaged in a project…User_2025-02-03-23-21-35-207 38 views 3 comments 0 points Most recent by User_2025-02-03-23-21-35-207
-
Exclude a column in XML Report output formatSummary My select query has two columns. I want to have only one column in my report output which is in XML format. Is there wa we can achieve this.Content My select que…
-
How to migrate the Common lookup from one instance to another instanceSummary We have created a Comoon lookup and need to migrate into another environment. Can you please help me by providing steps for migration
-
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…
-
Differences between running Reports Online vs Schedule/ESSSummary Can anyone list the differences in terms of restrictions of running Reports Online from BI Catalog vs Schedule / ESS DefinitionContent Hi Team, Our customer is a…
-
Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…
-
Probation Questionnaire ReportSummary I wanted to develop a probation questionnaire report using BIContent I couldn't find the table in which probation evaluation is found while developing a probatio…
-
BI Publisher Report Outputs to OCI - Cloud StorageSummary is it possible to send the BI Publisher Report Outputs to OCI - Cloud StorageContent We are working on a customer proposal and need to validate the feasibility o…
-
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t… -
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…
-
Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsSummary Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsContent Hello Team, I am looking for the source code or Data base tables w… -
Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme…
-
Dec-XX Balance for Qtr4-XX balance in FRS StudioSummary Dec-XX Balance for Qtr4-XX balance in FRS StudioContent Hi We need to populate QTD balances. The accounting calendar has 2 Adj periods. Adj 0 - XX before Jan-20X…Swapnil Mangnalikar 26 views 3 comments 0 points Most recent by Cezar - Fusion Oracle Support-Oracle