Fusion Procurement reporting
Discussion List
-
REST API to extract database tableSummary: Hi Community, I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like SELECT * FROM PO_HEADERS_ALL I came across that REST … -
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…
-
Need to highlight the all the changed fields of PO Changed Order on PO PDF report.Summary: Need to highlight all the changed fields on a changed purchase order on PO PDF report. Content (please ensure you mask any confidential information): Fields can…
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 939 views 6 comments 1 point Most recent by User_2W210 Reporting and Analytics for ERP -
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2K views 7 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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 875 views 7 comments 7 points Most recent by Marwa Reporting and Analytics for ERP -
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 46.7K views 128 comments 30 points Most recent by Dave Kekish 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 106 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 363 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 22 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 32 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 24 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 54 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 33 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 23 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 31 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. 28 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…Pranita S 651 views 6 comments 0 points Most recent by Muhammed Basheer 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 69 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…
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 778 views 14 comments 1 point Most recent by Adwait Rajmane 1 Reporting and Analytics for ERP
-
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…