OTBI
Discussion List
-
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… -
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…
-
Project Management Infolet blankSummary: Project Management Infolet blank Content (please ensure you mask any confidential information): Why is PM infolets blank as reflected below Can additional infol…
-
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…
-
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 684 views 19 comments 11 points Most recent by Teresa Cabrita - Capgemini UK Project Management -
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 15 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 81 views 14 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
How to export csv file for Import Jounals with OTBI.Summary: Do you know how to export csv file for Import Jounals with OTBI? I tried to create OTBI report like the following. It is used Project Costing - Actual Costs Rea…
-
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 25 views 3 comments 0 points Most recent by Zaheer Ahmed-Oracle Project Management
-
How to grant users access to report that was built using Projects - Performance subject area?Summary: Users are able to access report built using the Projects - Performance Reporting Real Time subject, but not the data that populates the parameters needed to run…Matthew - Town of Aurora 21 views 6 comments 0 points Most recent by Matthew - Town of Aurora Project Management
-
Expose Billing Instructions field (Bill Plan) in AR Transactions UISummary: We have a global customer with each region using different invoice templates. I'm hoping to populate AR Invoice Template in the "Billing Instructions" field so …Raj Mohanraju FRNT 26 views 1 comment 0 points Most recent by Zaheer Ahmed-Oracle Project Management
-
Custom Project Role missing the ability to create a Report using Subject AreasSummary: Custom Project Role missing the ability to create a Report using Subject Areas Using this role when the Users tries to Create a report they can only create the …
-
PPM Contracts - How to setup new roles on the Parties LOV tab ?Summary: PPM Contracts - How to setup new roles on the Parties LOV tab ? Content (required): Hello We have the contracts module and on the parties tab , there are only t…
-
BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ tableSummary: BICC SYNC - PVO for PJF_PROJECTS_ALL_B_ table Content (required): Hi - I am looking for PVO to BICC sync table PJF_PROJECTS_ALL_B_ table. Please help. Version (…
-
Incorrect value/Same Value being displayed in Projects-OTBI reportsSummary: Content (required): Projects-OTBI reports show incorrect values, Budgets, Actuals, and Commitments are all displayed as "3".Occasionally, or depending on what e…
-
OTBI-Expense-Expense Transactions - SQL to Link Expense and PPM ?Summary: OTBI-Expense - Expense Transactions - SQL to Link Expense and PPM Content (required): Hello I have an OTBI report with the subject area Expense-Expense Transact…Cesar Saveedra 35 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
SQL Link between AP and Projects ?Summary: Report which shows project transaction that have flown through to AP Content (required): Hi Does anyone know the links/joins between AP and Projects, we are try…
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
Is it possible to route Project budget approvals to PM supervisor?Summary: Content (required): I am trying to setup budget approval rules to be sent to project manager supervisor but I can't seem to find the supervisor attribute in the… -
Request for Email Alert Setup: Task Status Change NotificationsSummary: We need to have an email alert to the task owner and project manager whenever the task status changes from "not started" to "Started" and "Started" to "Closed".…
-
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…
-
How to update subject areas to get additional flexfield?Summary: An additional flexfield was created, but it is not showing in subject area. Content (required): An additional flexfield was created, but it is not showing in su…Franklin_Cardozo-Oracle 76 views 9 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Billing Cycle is missing in Contract and invoice real time subject area in OTBI ReportSummary: Hi Team, We have requirement of Billing Cycle information in our custom OTBI report, i am unable to see that column. if you have any idea where we can see that,…
-
Is there a BICC data store that contains the Expenditure Type to Account MappingsSummary: Is there a BICC data store that contains the Expenditure Type to Account Mappings Content (required): We cannot find a data store that contains this information…Holly Wells 51 views 4 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
EPS element by delegate/EPS element by owner analysis not displaying hierarchy dataSummary: After Creating EPS element assigning delegate and assigning projects under it, when we run the EPS element by delegate/EPS element by owner analysis- these do n…
-
Custom Report example for PPM Allocations ?Summary: Custom Report for PPM Allocations ? Content (required): Hello I would like to create a custom report for PPM Allocations, will you please share with me the tabl…Cesar Saveedra 27 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management