Fusion Project reporting
Discussion List
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter …Rohan Lobo-Oracle 10.7K views 62 comments 22 points Most recent by Nikhil Bidwaikar Reporting and Analytics for ERP -
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o…Abhishek Shukla 1 view 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
No data in subject area Project Management - Task Management Real TimeSummary: Content (required): I cant see data in the OTBI subject area Project Management - Task Management Real time. Despite I can see the milestones the application. I…
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh.Kumarasamy-Oracle 55 views 10 comments 2 points Most recent by Shyam_Patel Reporting and Analytics for ERP -
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 21 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Did You Know? Accounting Period Close Exceptions DashboardSummary Sample dashboard that gives you an overview of your accounting period close exceptions Content The attached sample dashboard gives you an overview of your ac… -
Award Project amountsSummary: Award Project amounts Content (required): Can you please help me with table name or query to extract amount on Manage Award --> Open award --> Financial Perform…Nidhi Chhajed 2 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…Ganapathi Venkanna Raja 37 views 2 comments 0 points Most recent by User_LNRAG Reporting and Analytics for ERP
-
How to find latest record in table PJO_PLAN_VERSIONS_B for projectSummary: Hi Team, I want to know how to find the most recent record in PJO_PLAN_VERSIONS_VL as version_number is same for all 3 rows. Regards Nidhi... Content (required)…Nidhi Chhajed 1 view 9 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column.&…Noelle Bartlam-Oracle 1.7K views 19 comments 3 points Most recent by User541815-Oracle Reporting and Analytics for ERP
-
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if…
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 50 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
Need to push output files of the job Import Project Budgets through SFTP.Summary: Content (required): The issue can be reproduced with the following steps: Step1: We are scheduling the Import Project Budgets job. This is a seeded processes. S…Lokesh Senthilnathan 1 view 0 comments 0 points Started by Lokesh Senthilnathan Reporting and Analytics for ERP
-
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…
-
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor…
-
Projects-Labor distribution Cost analysis is missing exception information for error rowsSummary: Projects-Labor distribution Cost analysis is missing exception information for error rows Content (required): We have analysis built on Projects-Labor distribut…Mona Mantry 1 view 1 comment 0 points Most recent by Mike Bartoletti-Oracle Reporting and Analytics for ERP -
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen…Fongang 1 view 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 45 views 8 comments 4 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
PPM: Data Security in Custom I Publisher ReportSummary: We need some sort of Data Security to be handled in Custom BI Publisher Reports related to Projects module. We are looking for options related to the seeded Sec…Balachander G-Oracle 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing)Summary: Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing) Content (required): How are oracle customers that use EPM/EPBCS for project planning, appr…Andrew_Schmitz 11 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for ERP
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 808 views 14 comments 15 points Most recent by AnimeshAgrawal-Oracle Reporting and Analytics for ERP -
OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…StuartHibbert 50 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar…Andrew_Schmitz 14 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le… -
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 13 views 1 comment 0 points Most recent by Dhruvjoshi23 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…
-
OTBI multi-language support Release 13Summary Multi-language support for OTBIContent Hi Has multi-language support been enabled for OTBI Release 13? ThanksNeena S-48254 54 views 7 comments 2 points Most recent by Hari Thyagaraj 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…Marybeth Snodgrass 15 views 1 comment 3 points Most recent by James Allen Reporting and Analytics for ERP