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 Deve…Rashmi M-Oracle 40.1K views 126 comments 28 points Most recent by Dave Kekish Reporting and Analytics for ERP -
OTBI Analysis to get a value from the latest project budget versionI have created an OTBI analysis that shows values from the original budget version , but I want to compare it with the same values of the latest budget version, but when…Mohamed Abdelbar 3 views 0 comments 1 point Started by Mohamed Abdelbar Reporting and Analytics for ERP
-
TIP: Relative deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content…alexey.shtrakhov 23 views 3 comments 3 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Reporting subledger modules to GL with transaction detailSummary: We're looking for a report that provides information from subledgers into the GL in an Excel like format. For example, we need the project number, expenditure t…Kristen Shimkus 42 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
job which populates invoices into the fixed asset moduleSummary: Would like to know which job populates invoice data into the fixed asset module. Content (please ensure you mask any confidential information): We're missing so…
-
How to we call multiple Standard Packages in Data ModelSummary: As part of our requirement we need club two standard FA report columns. Two report called two different Standard Default Packages and in Report triggers also. C…Sarala B-Oracle 11 views 0 comments 1 point Started by Sarala B-Oracle 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 4.6K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…Dejan Begovic 1 view 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
Project Resource varianceI have created an analysis that reflects the variance of actual cost to the budget at resource level and also the variance of the same cost but related to the whole proj…Mohamed Abdelbar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 33 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…Regina_P-Oracle 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …Thanigainathan R 34 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p…Sam Solomun 102 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…Kalyani-Oracle 21 views 3 comments 0 points Most recent by Kalyani-Oracle Reporting and Analytics for ERP
-
TOOLS > audit reports - ORACLE PLATFORM SS > ADD/REMOVE ROLE MEMBERSHIPHI THERE am I Missing something? how useless are the reports without a User ID!?!? the reports tells us who removed what role and when but WHO.. SURELY the most importan…
-
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
Advanced Search hyperlink within LOV for VBCS screenSummary: We have a requirement to open advanced search screen from VBCS Screen LOV similar to oracle fusion standard screen. Is it possible to add hyperlink within LOV? …Sumit Sengupta 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
Regarding connectivity between BI Reports and OIC (PaaS)Hi team, Currently we are having few BI reports which call OIC services as data sources. All these connections are secured via basic auth. Since we are currently using O…
-
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask… -
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 1.7K views 14 comments 15 points Most recent by Bea Reporting and Analytics for ERP -
Downloading ESS Jobs using OIC IntegrationI was working on an integration in OIC that is supposed to allow me to download attachments in an ESS Job in EJKO by sending those attachments as a zip file to my email.…
-
Project Number Analysis Is Showing Project Templates As WellSummary: We are trying to generate a new OTBI that lists all the project numbers, irrespective of the project status, and the list shows Projects templates along with Pr…N K Shah-Oracle 11 views 1 comment 0 points Most recent by Nathan CCC 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…
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very badSummary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to. There is same …
-
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 406 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP