OTBI
Discussion List
-
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 43 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 85 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 41 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 323 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 238 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…
-
I have a requirement to create an OTBI report in PPM with accounting informationSummary: Oracle Cloud Project GL report Content (required): I have a requirement to create an OTBI report in PPM, where we can view the accounting information w.r.t all …User_2025-03-07-19-07-12-950 63 views 2 comments 0 points Most recent by Meredith Bickell Project Management
-
How to find encumbrance in PPM OTBI Subject AreasSummary: HI Team, I want to find encumbrance in OTBI Subject Areas. Can you please help me to find same. Regards Nidhi Content (required): Version (include the version y…
-
Is there an attribute in PPM that shows the Return on Investment (ROI) of a Project or Program?Summary: In Project Performance or Program Analisys or OTBI, is there a collumn that represents the return of investiments? I didn't find this field. ROI = (Gain from In…Wilromar Benevides 31 views 2 comments 0 points Most recent by Wilromar Benevides Project Management
-
'Project costing - Actual Costs Real Time' , PO information is missing in subject areaSummary: 'Project costing - Actual Costs Real Time' , PO information is missing in subject area. Has anyone faced this issue? We have information available in UI but not… -
OTBI report on Contract. Unable to find Contribution Percent present in Contract Billing pageSummary: OTBI report on Contract. Unable to find Contribution Percent present in Contract Billing page in any subject area. Content (required): OTBI report on Contract. …Shashank Verma-Oracle 33 views 2 comments 0 points Most recent by Shashank Verma-Oracle Project Management -
How to create a list of projects linked to ContractsSummary: We need a list of all projects and their links to Contracts. Similar to this overview for one project: Content (required): Version (include the version you are …
-
What is the Analysis name (and path) of Progress Infolet of Project Management Infolets?Summary: The Existing Report Path shows no Analysis name on Edit Content (entering on Sandbox). I entered Sandbox and Edit pages, but nothing is shown on "Existing Repor…Wilromar Benevides 32 views 1 comment 0 points Most recent by Zaheer Ahmed-Oracle Project Management
-
Revenue Generation: How to ignore all migrated dataSummary: We are now live with Fusion ERP. Old projects and transactions have been migrated. Transactions are non-billable. Revenue is migrated using events. For new tran…
-
After 22B release Project - Grants Management - Award Funding Real Time is displaying incorrect dataSummary: The Award Direct Funding Amount is displaying the incorrect amount after 22B release Content (required): The award direct funding amount is summing the total of…