Fusion Project reporting
Discussion List
-
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev… -
Percentage formula doesn't work for expandable columns.In the "Financial Reporting Center" section by opening the "Workspace for Financial Reports" several reports have been configured. I have an issue... In column A (as an …Michele Ferro-Oracle 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How can i get currency report to show currencies and the exchange rate against a currency in OTBISummary: How can i get currency report to show currencies and the exchange rate against a particular currency in OTBI. I know I can get it through BIP report but i need …
-
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):…
-
Values exported from Financial Reporting Studio to Excel with the wrong sign!We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values present in the system (e.g. in the system the …Michele Ferro-Oracle 3 views 0 comments 0 points Started by Michele Ferro-Oracle Reporting and Analytics for ERP
-
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 49.2K views 133 comments 30 points Most recent by User_PNCTI Reporting and Analytics for ERP
-
Restricting BIP Data Model to signed in userSummary: Trying to use the data model to restrict the signed in user to only their information in projects. I'm trying to do this so that project managers when the open …
-
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 112 views 6 comments 0 points Most recent by 'Yehia Zakaria Reporting and Analytics for ERP -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
can BICC join multiple tablesSummary: Hi, Can BICC join multiple tables to populate data. i.e. From XLA table, I would like to link it to RA_CUSTOMER_TRX_ALL? Content (please ensure you mask any con…
-
Project Budgeting is done at resource level or task levelSummary: Hi experts, Is there a way or a flag or field which indicates if the project budget is done on the resource level or task level ? we are trying to identify that…
-
Project Adjustment Costs Error Exception DetailsSummary: I wanted to build a report which illustrates all the error-ed Cost Transactions ( Expenditure Item Costs ). In Costs dashboard, I have 1800+ error-ed transactio…
-
sql query or table name for Manage Account RulesSummary: Hi team, We need a table name or SQL query to get fields for the values type and values under the setup Manage Account Rules Content (please ensure you mask any…
-
Which table contains future budget period amount details?Summary: Hi Experts, We need to retrieve budget amount, actual amount and commitment amount for future budget periods for a report, these are the fields we see in the be…Aman Mishra 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Request for Information on Managing Budget Versions Approver details in fusion TablesSummary: I am currently working on a requirement to display the approver's name and the submitted person’s name for budget versions in our Grant Management system. Howev…Chetan Yeola 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
incorrect result when calculated measure by multiplying 2 columnsSummary: multipying revenue amount with ledger amount is giving incorrect results Content (please ensure you mask any confidential information): External Revenue Amount …mathew060581 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Project List Details OTBI report not showing any DataSummary: Project List Details OTBI report not showing any Data. Custom role is configured with all the below required duty roles Project Performance Reporting Transactio…Rohit Kumar Singh 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.1K views 7 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Sql query or Table name for Classify Organizations under Manage Project Organization ClassificationSummary: Hi Team, We need a table or query to get the flag columns for Classify Organizations under Manage Project Organization Classification Attached the screenshot fo…
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 22 views 1 comment 0 points Most recent by Nidhi Chhajed 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 105 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 388 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Budget Override Request NotificationSummary: How to customize Budget Override Request Notification Data Model to enhance the Notification? Content (please ensure you mask any confidential information): Cur…
-
Need SQL Query for Project Custom ReportSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …Awal 21 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
When using smartview for the projects Essbase cluster how to display description instead of IdsWhen using smartview for the projects Essbase cluster how to display Tasks_Dimensions or Resource_Dimensions with their description instead of their IDs There is no clea…Ivan Olivera-Oracle 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …ShitalRamteke 1 view 2 comments 0 points Most recent by Carlos Suarez Lopes Reporting and Analytics for ERP
-
Tables to get the Project Budget by monthSummary: Can anyone help me with the details of the tables that have Project budget in PPM. I am looking for the budget data by month. Building a custom BIP report. Cont… -
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…
-
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 83 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…