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 …Rashmi M-Oracle 21K views 89 comments 26 points Most recent by Dave Kekish Reporting and Analytics for ERP -
Need a query to get the project actual cost ,committed cost and actual revenue of the project (PPM)Summary: we are developing a BIP report which gives project-wise budget details and actual cost and revenue details. we were able to get the project budget cost and budg…
-
Can we create custom workflow for Project escalationSummary: Can we create custom workflow in BPM for Project escalation Content (required): 23A Version (include the version you are using, if applicable): Code Snippet (ad…
-
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …Santhi Sree 31 views 11 comments 0 points Most recent by Santhi Sree Reporting and Analytics for ERP
-
Need to know the Accounting Status identifier from Projects expenditure/costing tablesSummary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. For this request we need to know …
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…user12240811 10 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 47 views 2 comments 3 points Most recent by Vijaya Sekhar A-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… -
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 87 views 3 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Unable to see Creation date of Project Enterprise Resources in any subject areasSummary: We have below requirements:- Report to be sent to resource pool manager when a resource with back dated date is entered (for ex: Resource is created with date 0…
-
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,…
-
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …Nicolas Vahman 41 views 4 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for ERP
-
Project Manager project reportSummary: We would like to build an OTBI report parameter that defaults to the current user as a prompt. Content (required): If i am signed in, I would like the report to… -
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…Nicolas Vahman 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…Abhilash K - Deloitte USI 71 views 5 comments 1 point 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 (…Mona Mantry 61 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Error in Financial reporting centerHello, I am trying to upload my balance sheets and income statements in financial reporting center, when I navigate, I can't find the different ledgers to select. In add…Victor Chrabieh 21 views 2 comments 3 points Most recent by Bhaskar Konar 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 1 view 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 91 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 78 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 11 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 94 views 7 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
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 65 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
-
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 11 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.7K views 19 comments 4 points Most recent by User541815-Oracle Reporting and Analytics for ERP