Fusion Procurement reporting
Discussion List
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…Alan-Oracle 904 views 14 comments 16 points Most recent by Mohamed Attia-Allah Reporting and Analytics for ERP -
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…Rojhat Sinan Balka 1 view 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…Sabarish Reddy Ganda 117 views 1 comment 1 point Most recent by Usman Ali2025 Reporting and Analytics for ERP
-
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
List of all seeded reports for SCM , Procurement and Procurement contractsI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…Santosh Kumar,Rayudu 1.1K views 4 comments 0 points Most recent by Arun Gandam Reporting and Analytics for ERP
-
To restrict access so that only pending workers can use the username and password.Hi All, Can someone provide insights on how to implement restricted access so that only pending workers can use the username and password login while everyone else uses …Sheshan Ukkalkar 23 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP -
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
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…
-
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…
-
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 1.2K views 6 comments 1 point Most recent by RKSharma 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 937 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 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 406 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 33 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 21 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 72 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 38 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 114 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. 44 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 13 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 158 views 8 comments 0 points Most recent by Mahesh Kumar C Reporting and Analytics for ERP