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
-
Display OTBI DashboardContent Hi, I have dashboard report called P2P OTBI Dashboard and to invoke from Procurement Tab I created new page from Page Integration and make it visible from Struct… -
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste… -
Cross subject area - on which facts are they joined?Content Hi there I have joined two subject areas - Expenses - Expense Transaction details real time - Workforce Management - Work Relationship Real time to get level 2 d… -
How to add more descriptive flexfields in Business UnitsSummary How to add more descriptive flexfields in Business UnitsContent Hi We would like to ask if there is a way to add more descriptive flexfields in Business Units? T…User_2025-02-11-12-30-38-982 34 views 1 comment 0 points Most recent by Vaishnavi Aryasomayajula-Oracle -
SQL STATEMENT FOA FIXED ASSET DETAILSContent I NEED A SQL STATEMENT FOA FIXED ASSET DETAILS. -
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…
-
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers … -
Subledger Details resulting in Duplicate LinesContent I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a piv…
-
EBS Data Extraction SQLContent Hi, I am in the process of migration data from EBS to Fusion can someone help me to get the EBS data extraction queries for Finance (AP, AR, GL) and SCM modules …
-
Mapping Oracle eBS (12.2.8) tot Oracle CloudContent We are currently investigating moving from Oracle eBS on premise (12.2.8) to Oracle cloud. We have quite some customizations and reports build on the old datamod… -
Cancelling other users scheduled processesContent Hello: We have been looked at documents 1467664 & 1980772 for viewing other Users' scheduled processes, but what our IT has tried, is not enabling a User to open…
-
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …
-
Recap of Ideas related to Audit Policies and audit logging abilitiesContent Following is a list of over 40 Ideas related to Audit Policies that we and others have logged. Most of these are essential to have complete audit logs; what we w… -
create data model using web serviceContent i need an example for creating data model using web service i need to create a report using data model using web service , how i create a data model and report ?…
-
How to create lov field in fusion reportsContent Dear , We have some location so we need lov paramter on report so user select specific location but how i create lov in reports. I tried to create in manage list… -
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh… -
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…
-
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r… -
i need a query to get available to reserve to item at subinventory levelContent i need a query to get available to reserve to item at subinventory level
-
LedgerSummary All transaction detailContent Hi experts, I need a report of all single detail of all transactions. Is there any report at "Scheduled Process"? Muhammad Amir Ver… -
New ideas for this month - Working Group on Audit, Security, and Compliance issuesContent We have a group of over 100 companies that meet on a regular basis to identify and review Ideas relevant to Audit, Security, and Compliance. We are tracking over…
-
BI Publisher domain whitelisting - creating exceptions to send out supplier communications?Content We've created a whitelist of Allowed Email Recipient Domains for BI Publisher which is working well for restricting communications and enforcing our Data Loss Pr… -
Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Summary Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Content Is it possible to run BI Publisher reports from excel ( Oracle ERP Cloud SAAS ) ? if so then… -
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …
-
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…
-
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking … -
Location of the Standard Account Analysis ReportContent Hi all, Are there any direct way to find the location of the standard report ( Account Analysis Report ) in the report and analytics section. Current it shows ma…
-
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve…
-
Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR AgContent Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR Aging report from scratch but lot of logic is hidden in stored … -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei…