Reports
Discussion List
-
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 23 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 16 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 8 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 28 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 3 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 38 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 43 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 26 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 74 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 207 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 25 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 48 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 364 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific usersMurilo Damasceno 44 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…Yordan Oliveira 20 views 4 comments 0 points Most recent by Yordan Oliveira Reporting and Analytics for ERP
-
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…Yogesh Mhalgi 770 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 69 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 73 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Field in form - how to find the corresponding attribute and tableContent Hi experts :) I have been working in many different ERP systems. Oracle Cloud is new to me. In some ERP systems it is possible in a form to access information ab…NajaBM 58 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 16 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557 Reporting and Analytics for ERP
-
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …Rama Pedamallu-193980 65 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
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…
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
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 …Sushan Peiris 1.1K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 1.8K views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP