Fusion Project reporting
Discussion List
-
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 123 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… -
How to Handle Billing for prepaid Awards in Grants Management ?For the Grants which were prepaid/money received, we told the customer to create a Receipt in AR, and account it. Once the client started incurring cost on it, we told t… -
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… -
Is there any connection link to pull data from PPM via SmartView ?Summary: We have a requirement to pull awards and other project-related details from the PPM dashboard via SmartView. Wanted to check if there is a connection link to pu… -
PPM Manage project status - Status classification tableSummary: Hi All, I have noticed a discrepancy between the project screen status and the backend table status. On the project screen, the status code is displayed as DRAF… -
'Assets' Icon is not showing under 'Projects' Work are on Home pageSummary 'Assets' Icon is not showing under 'Projects' Work are on Home page but in Navigator , it is showing under 'Projects'Content Hi Team, 'Assets' Icon is not showin… -
Can you add a project number to a contract event after it's been billed?Summary: We've identified that we should have included the project number when creating an event for a contract to allow us to report through Fusion Data Intelligence (F… -
COGS matching with RevenueHello, We are doing billing using a Project billing solution without having an order management module in scope. The cost will be accumulated on the Projects from variou… -
How do we find the PVO of these tables(PJF_PROJ_ELEMENTS_B TASK, PJF_PROJ_ELEMENTS_TL PPETL)?Summary: MTIA PO and PO Value in ERP - The columns above highlighted are present in the one of the base tables PJF_PROJ_ELEMENTS_B TASK, PJF_PROJ_ELEMENTS_TL PPETL as pe…Rasagna Repaka-Oracle 132 views 9 comments 0 points Most recent by Neha Jha-Oracle Project Management -
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… -
How can we manage the Burn rate indicators / KPI values on Awards overview screen.Summary: Can we manage the Indicators that are shown on the Award overview screens against the associated project ? Indicators against the Available amount on Awards ove… -
Query or Table for Budgetary Control Settings under Manage Financial Plan TypesSummary: Hi Team, We need a Query or Table for Budgetary Control Settings to get below fields under Manage Financial Plan Types. Content (please ensure you mask any conf… -
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… -
Clarification on Impact of Removing Standard Project Manager RoleSummary: I wanted to check the impact of removing the standard Project Manager role when we are not using Project Execution Management. Since we already have other roles… -
Billing Dashboard OTBI AnalysisSummary: Can one of you share the OTBI Analysis shown in screenshots in new feature (23B) documentation (link below) ? Content (please ensure you mask any confidential i… -
How to Debug and Track Burden Cost Generation in Oracle Fusion ProjectsSummary: I am looking for insights on debugging burden cost generation in Oracle Fusion. Specifically, I would like to understand which costs contribute to burden calcul… -
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 11 views 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 51 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Invoice Exceeding PO Amount Not Reflecting in Project Costs – Missing Validation & Costing ImpactSummary: We have a scenario where an invoice is being created against a Purchase Order (PO) with an original amount of 1,000 and a 12% non-recoverable tax, bringing the … -
Is there any project level chat option available to chat with team members?Summary: Is there any project level chat option available to chat with team members? Content (required): Version (include the version you are using, if applicable): 23A … -
PVO and Oracle Base Table for Project approvalsSummary: We have approval hierarchies enabled for Projects Module, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywh…User_7DZID 11 views 2 comments 0 points Most recent by sambasivarao kosuri-Oracle Project Management -
Project Manager role to restrict access to purchasing data for own projects onlySummary: Project managers should only be able to view purchase orders, requisitions and AP invoices for the projects that they are assigned to as a project manager. Can … -
Need a SQL Query to fetch Inception to date Budget Amount from Oracle Grants Management AwardsSummary: Hi, I need to fetch Inception to date Budget Amount for each funding source from Awards screen that is under Awards → Award Details → Project Financial Details … -
Securing purchase order-, purchase requisition- and supplier invoice details by projectSince the project commitment and project cost subject areas do not provide all required purchase order/requisition and supplier invoice details, project managers of our … -
Unable to Bulk Load Common lookupsSummary: Unable to Bulk Load Common lookups Content (please ensure you mask any confidential information): Hi Team, When trying to Bulk Upload Common LookUps ,Im able to…PPM Consultant1 44 views 6 comments 0 points Most recent by KKhin-Oracle Fusion Applications Administration -
Restrict Project Accountant access by Team memberSummary: We have a requirement to restrict Project accountant role only to certain projects where they are assigned as the Project Accountant. By default if standard Pro…