Fusion Procurement reporting
Discussion List
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 952 views 7 comments 7 points Most recent by Marwa Reporting and Analytics for ERP -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 105 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 451 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
What is the meaning of the LAST_UPDATED_BY and LAST_UPDATE_DATE in GL_FRC_REPORTS_B?Summary: Our auditors asked us to extract the contents of the table GL_FRC_REPORTS_B for them. While reviewing this data, we noticed that for many of the reports it is s…Chris Mansfield 45 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Is there a way to modify the configuration so that the link to its own cell is displayed?Summary: When downloading information from a report, clicking on the link of any of the cells always displays the link to the cell corresponding to the first row. Is the…Manuel Riobóo Córdoba 31 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Does BIP allow additional static attachments, Word and Excel, to be added to a bursting email?Summary: We are customising the standard PO print BIP report and they will all be delivered via email, using the bursting functionality. The email will have a PDF attach…Derek Corbett 22 views 2 comments 1 point Most recent by Derek Corbett Reporting and Analytics for ERP -
Issue to get PO Lines accounting details from GL sideWe need to retrieve the PO Lines accounting details along with the net balances. But we are unable to obtain the PO Lines accounting details from the GL-level tables. We…Sushan Peiris 71 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co…Lucky Sharma 45 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask … -
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 22 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management -
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the… -
How to export XML sample file from Purchase Order PDF data modelI am trying to export the XML from the standard Oracle Purchase Order PDF Data Model, so that I can import that XML Sample into the RTF Document (using the BI Publisher …Richard Nagle 139 views 3 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 41 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP -
Supplier data model missing a column in displaySummary: The tax ID column is missing in a custom data model for one user. Content (please ensure you mask any confidential information): I created a data model (SQL que… -
Shared SCM ReportsDoes anyone have a monthly total spend report that they might share? OTBI or SQL code? CoVicky P 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
view past versions of PDF in oracle fusionSummary: How to view the past revisions of PO PDF within Oracle Fusion ? Content (please ensure you mask any confidential information): Version (include the version you … -
I am not able to access data model through report edit section, page showing as unresponsiveWhen I am trying to access a BI report to attach a data model through Edit section of the report, page is showing as Page Unresponsive in DEV instance, can i delete the …Shahid Qureshi 181 views 8 comments 0 points Most recent by Mahesh Kumar C Reporting and Analytics for ERP -
TAD Setups - For Project POs Charge AccountSummary: TAD Setups - For Project POs Charge Account Content (please ensure you mask any confidential information): According to business requirement, we have configured… -
How to Restrict downloading URL Attachments by other Supplier in Fusion OracleSummary: My scenario is PO Lines are attached with documents for Supplier, using supplier portal login users are able to view/download other(supplier) attachments. This … -
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar… -
Oracle Procurement Punchout Definition tableNavigation - Procurement - Catalogs - Manage Catalogs - Punchout Catalog We are trying to build a bip report to query all the punchout catalog information. We are not ab… -
Need Setup/Configuration changes Report for Oracle Finance, Procurement, HCM setupsSummary: I Need Setup/Configuration changes Report for Oracle Finance, Procurement, HCM setups. The report should show about the changes made in setups. Content (please …PratikL 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Requisition Approvals History - Approval history has been purged and no longer availableWe are getting the error 'Approval history has been purged and no longer available' when to view document history in requisition and purchase order. Is there any tables …Kishore Kumar Reddy Bhushanam 107 views 1 comment 1 point Most recent by Lego Mathew-Oracle Reporting and Analytics for ERP -
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t…AndresGlz2109 244 views 4 comments 0 points Most recent by AndresGlz2109 Reporting and Analytics for ERP
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 1.2K views 8 comments 0 points Most recent by MangalThorat Reporting and Analytics for ERP -
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 34 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP -
Oracle Fusion BI Publisher Custom Physical SQL SecuritySummary Oracle Fusion BI Publisher Custom SQL - Security ConsiderationsContent Hi, When you create a Business Intelligence Publisher data model with physical SQL, you ha…User_2025-02-05-04-43-06-903 136 views 6 comments 3 points Most recent by Carlos Benassi Reporting and Analytics for ERP -
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce… -
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it…