Fusion Project reporting
Discussion List
-
ESS job for IICS web serviceSummary: IICS related ESS job in Oracle fusion Content (required): I have a requirement where I created an ESS with Webservice DM and created an ESS job. When submitted,…Dhara2022 5 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Project Budget Vs Actual at Task Level ReportSummary: Project Budget Vs Actual at Task Level Report Content (required): Has anyone developed a report that contains Project Budget Vs Actual at Task Level? Version (i… -
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 15.4K views 78 comments 25 points Most recent by Souvik Ghosh Reporting and Analytics for ERP
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 10 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…Shivaji Muttarapu HL 41 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 45 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
AP Aging reportSummary AP Aging reportContent Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current da…
-
Current year + 2 as filter in columnSummary: Content (required): Hi I would like to show the forecast for 2 years from now for a specific column. For example in the code below I've used a repository variab…Nicolas Vahman 12 views 2 comments 0 points Most recent by Amrita Gupta-Oracle 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 19 views 7 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to add Award project burden schedule and burden rate available in OTBI ?Summary: Our business needs ward project burden schedule and burden rate available on OTBI side. Has anyone configured them via flexfields? Content (required): Version (… -
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 1 view 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 38 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 2 views 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 2.2K views 19 comments 4 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 2 views 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 2 views 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 2 views 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 12 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…