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
-
Table and Field to show date role was added to a userSummary Table and Field to show date role was added to a userContent looking for the sql table and field to show the date a role was added to a user. thanks. -
Webservice for Fusion Data ModelContent Hi, Is there any Web API (SOAP or REST) to access Fusion Database objects as read only mode Thanks -
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…User_2025-01-30-23-00-53-497 81 views 2 comments 1 point Most recent by User_2025-02-04-13-08-33-519
-
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…User_2025-02-04-18-03-15-131 39 views 3 comments 1 point Most recent by User_2025-02-04-18-03-15-131
-
How to extract all project parties via a report?Summary Looking for a way to extract all project parties information via an analytics or bi publisher report.Content In the Project Financial Management web page, throug… -
Web API for Financials/SCM ReportsContent Hi, Is there any webservices SOAP/REST available to access seeded ERP Financial reports Thanks
-
How to Add notifications to already scheduled ESS jobsSummary is it possible to edit the scheduled ess job to add the notifications ?Content Hello Guru's is it possible to edit the scheduled ess job to add the notifications… -
how to get xml data for process Create Settlement Batches in AR Collections?Summary how to get xml data for process Create Settlement Batches in AR Collections?Content Hi Experts, I'm modifying template for Create Settlement batches program whic…Pradvin Heggar Prabhakar-147626 40 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626 -
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…
-
Scheduling Cash to GL Recon BI Publisher ReportSummary Has anyone had any success with scheduling the Cash to GL Reconciliation BI Publisher Report?Content We have a request from business users to schedule this repor…
-
NEW Analytics for ERP - 20ASummary NEW Analytics for ERP - 20AContent Hi, We have now 20A, but Oracle new buit in Analytics for ERP is not available, any idea on ERP analytics. Regards, -
SmartView/FRS Alias names for Financial StatementsSummary SmartView/FRS Alias names for Financial StatementsContent We are a fairly new cloud customer and have some questions about how everyone is handling creation of s…User_2025-02-04-18-03-15-131 33 views 0 comments 0 points Most recent by User_2025-02-04-18-03-15-131
-
Export FRS reports as *.DES extension fileSummary Export FRS reports in 19D as *.DES extension fileContent Hi, Does anyone know how to export FRS reports as *.DES extension file ? Thnx Version R13 - 19D updates
-
NUX - Newsfeed UX Layout mandatory change for FINANCE?Summary HCM clients are requested to move to NUX layout by 20B... how about FinanceContent Oracle HCM (in OOW19 and also via some HCM consultants) are mandating clients … -
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…
-
Budgetary Control Analysis Report Sample - Projects High VolumeSummary This is a sample budgetary control analysis report for projects control budgets.Content This is a sample report that is a based upon the standard budgetary contr… -
OTBI Action Link not passing parameter when complex logical query is usedSummary OTBI Action Link not passing parameter to another BI Content when complex logical query is usedContent In general, if we create OTBI analysis from a single subje…
-
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
OTBI -Report OutputSummary OTBI -Report Output- GL Subject AreaContent We are trying to create a report using Subject Area "General Ledger - Journals Real time". My requirement is that the… -
In oracle fusion 19D Direct Database query option disabled.Content Dear , We recently updated oracle fusion 19D . In which we can not see Direct Database query option. We give privileges to Direct database query in Bi Presentati…
-
show project number on GL reportsSummary we building a report to show subledger details like invoice number , supplier etcContent we would like to figure a way to show project number on the GL report we…
-
rtf template - summarize column within groupSummary rtf template - summarize column within groupContent Hi, I created simple table ( see attached files ) and i want the column values to be presented on one row. wh… -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary Smart View error using ExcelContent Hi, I'm using Smart View version 11.1.2.5.910 with Microsoft Office Standard 2016, I'm constantly receiving this error "Smart… -
BI publisher - controlling developer access to folders - write access to My Folders only but not toSummary We need to be able to control report developer access so that they can only create reports, data models etc in their local (My Folders) folders; everything else …
-
Planning & forecasting in oracle fusionSummary Planning & forecasting in oracle fusionContent Hi, Is there any financial planning & forecasting feature (like hyperion functionality )in oracle fusion. Regards,…
-
Carriage Return in scheduled jobSummary Manual run of report has no Carriage return - scheduled run of job does - Tab delimited file.Content Hi all, Has anyone seen this behavior and overcome it? we ar…
-
Report that List All Users and Assigned RolesSummary Looking for a report that provides a list of all users and their assigned roles.Content Hi. Does anyone know of a report that list all users and their assigned r…
-
Customer Balance ReportSummary Customer Balance Report show me balance for All customerContent Hello i need report show customer,Transaction Type(Invoice,Credit Memo,Debit Memo,Receipt),Debit,… -
Drill down GL to subledgerSummary Drill down GL to subledgerContent Hi all, Is there any standard OTBI reports to drill from GL to subledger like AP and AR? or not possible customize is the work …User_2025-02-04-05-26-22-197 145 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197
-
Lookup Details from Subject AreaSummary Custom Lookup Details from Subject AreaContent Is it possible to fetch any custom lookup information from any Subject Area? The use case is like below: An analys…