OTBI
Discussion List
-
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 954 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 36 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 151 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…
-
Balance Sheet by Project: Does this necessitate a project GL Segment or is there another way?Summary: We are in the design phase of a Financials and PPM implementation. Customer desires Project Balance sheets. Other than creating a GL segment for project (not be… -
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… -
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 61 views 5 comments 1 point Most recent by Marcelo Cardoso Project Management Resource Center -
How to find and use a specific kind of configuration/typology of "Event Types" in OTBI ?Summary: There is a specific kind of configuration/typology of "Event Types". It is included in the "Manage Project Billing Value Sets" configuration form You can get th…
-
Project Cost Budget BreakoutSummary: Project Cost Budget Breakout Content (please ensure you mask any confidential information): How can I get the breakout of what makes up the Cost Budget? Which r…
-
Budget vs. Actual Cost Comparison by Business Unit with sql errorSummary: unable to execute Budget vs. Actual Cost Comparison by Business Unit with the error Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY…
-
Project invoice table to subledger table joinSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Pradeep Balakrishnan Project Management
-
The specified criteria didn't result in any data from Project Subjects AreasSummary: When use Projects – Cross Suject Area Analysis – Real Time subject area, and select only project number column appears data, but when select project number and …Franklin_Cardozo-Oracle 21 views 5 comments 0 points Most recent by Franklin_Cardozo-Oracle Project Management -
Prompts are not currently supported for analysis that combine criteria.Summary: Combined two SA i.e Projects Billing - Revenue Real Time + Project Performance Reporting Real time and want to have 'Project name' as Prompt Value and it is not…
-
query to retrieve expenditure type linked to a project, task and organizationSummary: I need to extract the expenditure type linked to a specific project, task and organization (cost center). How can I build this query? Any suggestion? Content (r…Giuseppe Galluzzo 2.2K views 14 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
List of fields from project billing that is transferred over to AR Invoice data modelSummary: Is there a way to obtain a list of fields from project billing that is transferred over to AR Invoice data model following invoice generation process. I'm keen …Raj Mohanraju FRNT 22 views 3 comments 0 points Most recent by Zaheer Ahmed-Oracle Project Management