OTBI
Discussion List
-
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.3K 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
-
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 31 views 6 comments 0 points Most recent by Matthew - Town of Aurora Project Management
-
Did you know? Subledger Accounting for Project Financial Management WhitepaperSummary This post provides customers and partners with best practices and detailed information on implementing, configuring and diagnosing subledger accounting for proje…Divya Sudhakaran-Oracle 3.6K views 37 comments 17 points Most recent by Kirtee Jeetah-Naran Project Management Resource Center
-
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 21 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 41 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
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".…
-
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 81 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 31 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Dynamic recipient email to be picked from OTBI analysis columnsSummary: We prepared an OTBI report where tasks to be started on the current date, task owner, task owner email, and project manager email is displayed. We need to sched…Santhi Sree 262 views 7 comments 0 points Most recent by Mona Mantry Reporting and Analytics for ERP
-
Sub-Recipient in Grants/AwardsSummary: Hi All, we are implementing PPM for our public sector client. There is a federal requirement to print SEFA report from Oracle which lists all the details of exp…
-
Do you know how to add a deeplink in the HTML ouput of an emailSummary: The request from business is to avoid opening a attached report to use deeplink from the report. But the email should contain directly the lines expected with a…
-
compare two project budget versionsSummary: Please confirm how to compare different versions of budget from UI or using OTBI? Content (required): Version (include the version you are using, if applicable)…
-
Security on OTBI reportSummary: Hi, We prepared an OTBI report on programs/projects. We are able to view all the data in the reports irrespective of Business unit/project unit/ project organiz…Santhi Sree 237 views 3 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
What is the equivalent of EBS Request Group in FusionSummary: I would like to know the equivalent of EBS Request Group in Fusion. For Example, I have a project accountant who needs to have access to run and view AP custom …Navaneeth TechM 61 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
How to create schedule wise S curve in fusionSummary: How to do Project Schedule wise S curve as explained in below link? Excel S-Curve Charts • My Online Training Hub Is there any workaround available? please advi…
-
Infolet for Percentage of work complete and amount billedSummary: We have a requirement from the customer that they want to see the percentage of work that is complete (Method can be either cost/effort/manual) and how much amo…
-
Cumulative totals in OTBISummary: We want to create cumulative Actual costs in OTBI. Please advise how to do this? SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Proj…
-
OTBI report to display program and projects under itSummary: We are trying to prepare a report to display the program and list of projects under the program. We tried adding below two subject areas Projects - Program Perf…
-
OTBI subject area for health of the project detailSummary: Please provide me OTBI subject area that gives health of the project. Content (required): Version (include the version you are using, if applicable): 23A Code S…
-
Is there a standard report for generating invoice cover letter by contractSummary: Is there a standard report for generating invoice cover letter by contract Any inputs on this will be appreciated. Content (required): Version (include the vers…