Fusion Project reporting
Discussion List
-
Expenditure type mapping with GL AccountSummary: Whenever this a new value created in the value set for the Natural Account, it necessitates creation of new expenditure type in Projects. This is resulting in d… -
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 543 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
i need table name for the TAG_NUMBER columnSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Project not transferred to Fixed AssetsSummary: Project not transferred to Fixed Assets Content (please ensure you mask any confidential information): Create project Upload salary reversal to Project Generate…
-
Reporting currency amount for project cost and revenue in OTBISummary: Hi Team, Do we have flexibility to get the project cost and revenue data in reporting currency, could you please how we can get that. we have created project wi…
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
How to know whhat are the data access and role needed for consulting a BI report with project tablesSummary: Hello, can some one help me with this? The business wishes to know if it's possible for anyone within the organization to view a report made with project tables…
-
Query returns values but when passed as a pram trucates other prams in OTBI PPM custom report.Summary: Query returns values but when passed as a parameter trucates others in OTBI PPM custom report. Content (please ensure you mask any confidential information): We… -
How Add Data Validation to ADFDIwe are migrating the costs through ADFDI "Create Costed or Accounted Transactions for Third-Party Applications". While entering the data there is one column called "Orig…
-
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 293 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 281 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How can we add multiple columns in an OTBI report for project team member rolesSummary: We are building an OTBI report using Projects subject areas. In this report we need to show project wise details of team members assigned to that project in mul…
-
BILL TRANSACTION CREATION ON BILLING EVENT CREATION- 23D new updateHello, After understanding and exploring the new feature in 23D, we have successfully enabled "BILL TRANSACTION CREATION ON BILLING EVENT CREATION" on our Test Instance …
-
Review Project Performance Data - PR in the current Month with Expenditure Item date in future MonthSummary: Hi We have a scenario where we have a PR booked in current month let' s say in the month of January 2024 with expenditure item date of April 2024. After the PR …
-
Migrate historic assets to projectsSummary: One of client manages their Assets outside of Oracle with journals being posted into Oracle based on figures derived from the “offline” asset data. They have al…
-
Retirement Target AssetSummary Retirement Target AssetContent Hello Team, Has any one worked on "Retirement of Asset" from Projects. I've gone thur few documents on Oracle Support and on Oracl… -
Error message:The value cannot be found in the list of items for unmatched negative itemSummary: When user load the transactions via ADFDI(Third party non-labor), it throw an error "The value cannot be found in the list of items for unmatched negative item"…
-
How to retrieve the source records for the entries in the table PJC_COST_DIST_LINES_ALL?Given a record in the table PJC_COST_DIST_LINES_ALL with the column Transaction Source (TRANSACTION_SOURCE_ID) = "Oracle Fusion Payables" and the column Document (DOCUME…
-
Default user name in ESS job parameter LOVSummary: We have created custom ESS job to invoke OIC integration using datamodel type - http. We need to pass logged in user's user_name as query parameter to integrati…Sumit Sengupta 625 views 3 comments 0 points Most recent by J Gatdula Reporting and Analytics for ERP
-
Did you know? Use OTBI to view period close exceptionsSummary Sample dashboard that gives you an overview of your accounting period close exceptions Content The attached sample dashboard gives you an overview of your accoun…Prithi Bandla-Oracle 162 views 5 comments 1 point Most recent by Marcelo Cardoso Project Management Resource Center -
project budget version reportSummary: I need to have a report that shows Project Budget Version and their Cost, for example when i created project budget the cost was 100, later i revised it and cos…
-
Single/Parallel PARTICIPANT rule is not working in BPM WorkflowWe created a Single PARTICIPANT rule But, this is not working as expected The same rule is working as expected when we use with serial PARTICIPANT but hear all members h…Thahir Hussain 122 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
Is there any Public Business Event that can be used for the Header of the Projects in PPM?Summary: We are looking for different ways to extract details of the header level using real-time events from the header level of the project. We already confirmed with …
-
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 28 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
Need configuration and conversion reportHi Experts, Need your guidance, Client wants to validate all the configurations done by functional consultant, is their any report that give us all the configurations de…
-
How can we merge multiple OTBI report lines into one lineWe are building one report which contains project wise team member details. As per the requirement, we should have one line in the report for each project displaying eac…Sanket.Kakde 488 views 7 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Oracle Social Network Cloud Service (OSN)Summary: Oracle Social Network Cloud Service (OSN) Content (please ensure you mask any confidential information): With oracle retire the Oracle Social Network Cloud Serv…