Reports
Discussion List
-
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 996 views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP -
Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj… -
Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21…User_2025-02-10-15-12-48-631 44 views 6 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…Rohit Kumar Singh 36 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…Rohit Kumar Singh 51 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 187 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
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…Sushan Peiris 364 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…Kaushal Gathani 27 views 2 comments 1 point Most recent by User_3EZDP Reporting and Analytics for ERP
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined …Vinay Gharge 40 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…Robinson Antunez 52 views 3 comments 0 points Most recent by Robinson Antunez Reporting and Analytics for ERP
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 47 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Passing a Dashboard Variable to all BI reports on dashboardSummary Passing a Dashboard Variable to all BI reports on dashboardContent Hi All, I am preparing a dashboard to show multiple charts / reports embedded. I would like to…
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 28 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
Oracle Procurement withholding tax problem - sqlSummary Oracle Procurement withholding tax problem - sql - see no tax code at line location, but populated norec / rec tax at distribution levelContent Hi, this is a sql…User_2025-02-10-15-12-48-631 19 views 0 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP
-
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances … -
Contracts Deliverables ReportContent Hello, Does anyone have a Contracts Deliverables Report that they can share? When I am building a report using OTBI Subject Area - I am getting many different st…Troy Collard 16 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP
-
Source Safe - Oracle Fusion BIPSummary Source Safe - Oracle Fusion BIPContent Hi, Can you please guide me on how to and best tools for setting up Source Safe for Oracle Fusion BIP (ERP/HCM), as we wou…Rakesh Sreenivasa 30 views 0 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP
-
Include 'Comments' from Contract Risks into Subject Area "Enterprise Contracts - Contracts Real TimeContent Hello, I am wanting to include a field called 'Comments' from Contract Risks into an OTBI report that uses the Subject Area "Enterprise Contracts - Contracts Rea…Troy Collard 8 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP
-
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 50 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
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 …Umamaheswara Reddy Karri 57 views 9 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 31 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP
-
OTBI multi-language support Release 13Summary Multi-language support for OTBIContent Hi Has multi-language support been enabled for OTBI Release 13? ThanksUser_2025-01-28-07-00-38-043 82 views 7 comments 2 points Most recent by Hari Thyagaraj Reporting and Analytics for ERP
-
Received Not Invoiced Liability ReportSummary Need an OTBI report for Received Not Invoiced LiabilityContent I am looking for an RNI report that will tie out the uninvoiced receipts to my GL liability. So fa…Neal Foley 231 views 8 comments 0 points Most recent by Craig Higgins Reporting and Analytics for ERP
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…User_2025-01-28-16-10-52-033 34 views 1 comment 3 points Most recent by User_2025-02-06-21-15-08-830 Reporting and Analytics for ERP
-
Due Date Calculation Formula based on Terms Date and Terms Name in OTBI ReportSummary Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI RepoertContent Hi All, I have a requirement to derive Invoice Due Date based …
-
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 53 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 377 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP