Fusion Procurement reporting
Discussion List
-
proxy bidding functionality in auction negotiations, proxy decrement as a percentageSummary: We are using the proxy bidding functionality in auction negotiations, but the system only allows us to specify a fixed amount for the proxy decrement. However, … -
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 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP
-
Trigger email notification when approver has requested more information on a requisition.Hi All, I'm trying to implement a change where an email notification should be triggered when an approver has requested more information on a requisition. I'm editing ex…Evanshi Vasani 81 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, https://us.v-cdn.net/6034893/uploads/DY6GVHKZ7OXI/ess-job-parameter-issue.docx I’m facing an issue when scheduling the ESS job — as soon as I select the paramet…Ashish1Soni 47 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Customization of Standard Contract Preview ReportSummary: Hi Team, I am writing to request guidance on a customization for the Standard Contract Preview Report(Enterprise Contracts --> Contract Printing --> Contract Pr…Saumya Mani Tripathi-Oracle 66 views 2 comments 0 points Most recent by Saumya Mani Tripathi-Oracle Reporting and Analytics for ERP
-
Need Sample and Confirmation of AnalysisSummary: Hi We have requirement to create analysis of procure to pay process (PR-PO-Receipt-Invoice-Payment). We need your help to give sample how to create analysis wit…
-
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
Combining Procurement Subject Areas for Enhanced AnalysisI am currently attempting to combine two subject areas, namely Procurement - Requisitions Real Time and Procurement - Purchasing Real Time, for a comprehensive analysis.… -
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…User_2025-01-28-17-34-41-546 566 views 2 comments 1 point Most recent by Shyam Patel Reporting and Analytics for ERP -
SQL query or oracle table names to extract the actual values of supplier change request detailsHi, Business requirement is to see the actual values that got changed on all of those tabs under supplier i.e. organization details/Addresses/Banking/Business Classifica…
-
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…
-
script to show item numberDear all, I would like to get the records of procurement with detail item number and description for each PO Line. i try with script, but the item number not shown can a…
-
Identity Correct PO and PR approval email & notification reportsSummary: How can we identify and modify the correct Oracle Analytics reports to update email and approval notification formats for Purchase Requisitions (PR) and Purchas…
-
customize standard reportSummary: Hello everyone, Can you tell me how I can find out which standard report is associated with this view in the purchasing module > purchase requisitions? I've tri… -
Description need to pass for Purchase order using Oracle standard SOAP servicePassing Description in Oracle Standard API for uploading Attachments - We need to pass a description while uploading attachments via Oracle’s standard SOAP Service for P…
-
using procurement data for commitment reportingSummary: Looking for a way to report commitment data using procurement data Content (please ensure you mask any confidential information): We currently report purchase c…
-
Is there any table which stores last email notification sent date for Requisition approvalwe need to display Last email notification date in our report so we wanted to check is there any workflow table which stores the details. we trayed to query this below t…Basavaraj Navalagi 41 views 3 comments 0 points Most recent by Basavaraj Navalagi Self Service Procurement -
How to use job schedule as a parameter in an SQL report?Summary: I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect. Content (please …
-
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 1.1K views 7 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
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 2.3K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
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 972 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 122 views 1 comment 1 point Most recent by Usman Ali2025 Reporting and Analytics for ERP
-
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.3K 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 22 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…