OTBI
Discussion List
-
OTBI Subject area to get Project cost and accounting entriesSummary: Unable to get details of view accounting page from Project Costing - Actual Costs Real Time. Wanted to pull the Project cost transactions which are enabled for … -
Where to find Warning limit and Error limit for the fusion tablesSummary: Greetings of the day.. Please share the information where we can find Warning limit and Error limit for the fusion tables Content (please ensure you mask any co…
-
customer required a report to fetch resources dataHi Everyone, we have a requirement to create a report to fetch details of resources who are working in a project for more than 24 months for a client. Can anyone share t… -
-
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 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
OTBI - Project Current Baseline Version and Actual CostSummary: Content (required): I'm trying to create an OTBI Analysis which shows the latest Current Baseline budget for a project, and next to this I would like to have a …
-
Project Contract Receivables collectionIs there any analysis that can reflect the project invoices collection cycle since invoicing till receivables receipts?
-
Need help configuring BPM Workflow Task for Issue NotificationsSummary: I have tried to customize the Issue Notifications Catalog workflow template for the Create Issues task under Project Management, but it is not reflecting my new…
-
Labor Distribution - Reporting Attribute to Identify Labor Cost AdjustmentsIs there a reporting attribute within the "Projects - Labor Distribution Cost Analysis Real Time" subject area within OTBI that identifies when a transaction is related … -
Resource class in oracle project table nameI need any supporting query that includes resource class of project on task information level. For better understanding I am pasting screenshot. As per my understanding …
-
Joining two subject related to project and project program.Summary: I want fetch project customer name based on project name for which program is assigned for this project program performance reporting real time, in this subject…
-
Approach to retrieve the value "5000009" from the string 01-4211002-00000000-0000-CH10-0000-5001044-Summary: I used the below, but it is giving syntax error. Can some one please assist and provide me corrected query SUBSTRING( "GL Account"."Concatenated Segments", LOCA… -
Sample Report: Project Financial Management Cloud: Project Budget vs. ActualSummary This dashboard displays Budget details for a specific project.Content The attached sample dashboard displays budget vs. actual cost and commitment details for a …Dustin Grabowski-Oracle 975 views 21 comments 11 points Most recent by aileen.joy.g.arcilla Project Management -
Extracting data from project management pvos and linking them to build an external reporting model.I need to extract data out through Project PVO's in order to fullfil an external reporting requirement. I am trying to find the PVO to bring below information together a…
-
Need access for Custom OTBI Dashboards : "Projects Control Dashboard" reportSummary: Project Role as "Project Team member" on Oracle seeded has no access for Custom OTBI Dash boards (specially "Projects Control Dashboard") . Our request is to pr…SRIRAMULA RAJKUMAR 41 views 6 comments 0 points Most recent by Sudhir Agir-Oracle Project Management
-
Enterprise Contract -> Manage Contract-> Contract Deliverables ->Activation Status Field Missing.Summary: Need to pull the list of newly created contract deliverables which are 'NOT ACTIVATED' for each contract/Award. ' Deliverable Activation status field is missing…Guna Suriya 31 views 3 comments 0 points Most recent by Andrei Ursachel-Support-Oracle Enterprise Contracts -
-
OTBI Reports CalculationSummary: Hello, We have resource assignment report and our aim is to join Project Resource Assignment and Worker Assignment, in order to calculate each employee ‘s proje… -
Forecast line additional information doesn't appear in analysisSummary: I have specified some additional information to the Forecast line , and all are BI enabled the issue is that none of them appears in the OTBI analysis meanwhile…
-
How to make one prompt for two viewsI have created an analysis in which a table and graph are reflecting the same results but in different views, I want to use one prompt to work for both at the same time.…Mohamed Abdelbar 11 views 1 comment 0 points Most recent by Adrian Paun - Oracle-Oracle Project Management
-
Project CostingSummary Project CostingContent 1. How do you Transfer Cost from one project to the next? 2. how to split cost from one project to multiple? 3. How to correct duplicate l…
-
-
Project Costing - Actual Costs Real TimeIs anyone using this data analysis (standalone without joining to another) and pulling in Cost Management information? If so, are you finding that the amounts are duplic… -
SQL Link between Project billing event and AR invoice?Summary: I need to identify the event which generated an AR invoice. Which table stores this information? Content (please ensure you mask any confidential information): …alejandro.vizcaino 203 views 2 comments 0 points Most recent by alejandro.vizcaino Project Management
-
Resource budget in different currenciesI have an OTBI analysis that needs to view the resource in different currencies - as the project budget allows- , but I can't get the amount in resource currency or even…
-
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 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…
-
Resource planning currency in budget doesn't appear in analysisI'm using a budget in two different currencies, but when I create an analysis I can't get the planned amount in the planned currency , only I get the currency code but t…
-
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…