Reports
Discussion List
-
Project to GL Reconciliation ReportCan you confirm if there is an existing Project to GL Reconciliation Report? We are trying to check if there is a counterpart for Projects. Sample is attached screenshot… -
How to find the revenue_category_id from revenue_category_code in PPMI need to filter data using revenue category code in PPM. Revenue category code is kept in PJF_REVENUE_CATEGORY lookup. Now when I use joins in PPM table they are holdin… -
HCM OTBI- How do I run report to see any positions with an entry in the 'Funding Source'?Summary: Need run a report to see if there are any positions with an entry in the 'Funding Source' field however I'm unable to find the field in any HCM Subject Areas. C…Sangken 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subledger Period Close Exception ReportSummary Subledger Period Close Exception ReportContent I am seeing these transaction on the Sub-ledger exception report as per below table. 1. Does this means they were …
-
Table name and column for EXPENDITURE BUSINESS UNITSummary Table name and column for EXPENDITURE BUSINESS UNITContent what could be the Table name and column for EXPENDITURE BUSINESS UNIT for project commitment although …
-
Need a sql query or exact tables to find out Manage Mapping Sets for PurchasingSummary: Need a sql query or exact tables to find out Manage Mapping Sets for Purchasing for Input source - Item Category and Output - Account Content (please ensure you…
-
Import Costs Scheduled Process Only Shows Counts, Not Details- How to Get detailed based on ESS JobSummary: How can we get detailed records (line-level) of successfully imported project costs from the Import Costs scheduled process in Oracle Fusion, since the standard… -
Where are project asset details (and additional details) stored?Summary: Looks like the central project asset table is pjc_prj_assets_all. In the UI there's additional details areas that I'm not seeing a corresponding table. I'm spec…Jason Parker 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management -
Sql query to fetch the account coding status in invoicesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Joylin Boby 44 views 5 comments 0 points Most recent by Pradeep Balakrishnan Payables, Payments & Cash Management
-
Did You Know? Export Large Volumes of Project Costs to Excel EfficientlySummary Export large volumes of project costs from the Manage Project Costs page to Excel. Content You can export the search results on the Manage Project Costs page to … -
How can we change the sequence of the parameters while copying job from seeded job.we are trying to duplicate the ESS job ( Transfer Assets to Oracle Fusion Assets ) but we have a doubt regarding parameter sequence. In the standard ESS job definition B…
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
Output of 'Import Project Billing Events: Generate Report' in OICSummary: How to get report 'Import Project Billing Events: Generate Report' output in OIC and send it through email/ftp/UCM? I am submitting the Import Project Billing E…
-
Capture in BI Report the "Proposed Increase and Decrease in Budget" valueWe have a report requirement to extract in BIP report the "Proposed Increase or Decrease in Budget" value from Project budget version. Upon initial investigation, we hav…
-
Is there any table which stores interface error details for PPM Billing Events?PJB_Billing_Events_INT doesn't store any details. Or is there any way to delay the purge of data in this table post Import job runs? I am using it in OIC and need to get…
-
Why is Print Receivables Transactions ESS Job picking up seeded template?We have customized the seeded report. The Seeded report can be found under 'Shared Folders/Financials/Receivables/Bill Presentment'. The report name is "Invoice Print Te…
-
Unable to send Generate Invoices Output to EmailSummary: Looking for an option to send "Generate Invoices" scheduled process output PDF output to the Email ID Content (please ensure you mask any confidential informati…
-
submission note not copiedWorking on 25A, when Import Costs is submitted, I enter a Submission Note 'aaaa' , then at completion, the Report is submitted with another Process id, is it posible to …maria.torres 11 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management
-
How to assign project code creation role only ( Edit, delete) to users.I have requirement to provide project code creation role only to users. But users already have project related roles and General ledger related roles. it's not possible …
-
How to find the customer information from Manage Financial Project SettingsI want to retrieve customer information from Manage Financial Project Settings page. Can anyone help on the query?
-
Which subject area.column or BIP column is for rate name in benefitsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to remove processed PO change orders from monthly subledger exception reportSummary: We have a few PO's that are showing up on the subledger exception report monthly but the change orders against them have been processed. How do you get them rem…
-
PRJ: Print Option is not working in Project Overview Page in Project Financial ManagementDear Team, Print option is not working in Project Financial Management, does any specific setup is required for the same? Regards Prashant
-
SQL Query for Project Budget InformationSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …
-
Which table contains the cross charge business unit exceptions?When creating a project there is a section on Cross-charge options that lets you specify "Allow Charges from All Provider Business Unit". There is then an area to add a …
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
Oracle fusion column for Enable B2B MessagingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Joylin Boby 11 views 1 comment 0 points Most recent by Miranda Beuc-Oracle Payables, Payments & Cash Management
-
Which column gives the b2b column in supplier site levelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there any connection link to pull data from PPM via SmartView ?Summary: We have a requirement to pull awards and other project-related details from the PPM dashboard via SmartView. Wanted to check if there is a connection link to pu…
-
Is a report available that lists the sources use in Projects subledger account rules and conditions?Summary: Is a report available listing the sources which can be used in Projects account rules and conditions? I need to add a condition on the cost center segment based…Chris van de Graaf Perth WA 13 views 2 comments 0 points Most recent by Chris van de Graaf Perth WA Project Management