Fusion Procurement reporting
Discussion List
-
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem… -
Join between xla_distribution_links and po_distributions_allHi, Can anyone tell me how to join from xla_distribution_links to the purchase order tables (po_distributions_all)? For example, for the receipt accounting accrual. In x…Rob Tempelman 3 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Audit Trail in Procurement and Self Service ProcurementSummary: Currently in Procurement its possible to see only Supplier Audit History. Requisiton and Purchase Orders don't have any detailed history data available. Content… -
Can I edit the template of FYI notification myself?Summary: Would you please let me know whether I can edit the templates of FYI notification myself? If yes, where can I find these templates? Thanks. 1, the FYI notificat…Chunqing Wu 134 views 3 comments 1 point Most recent by Rebecca_Edwards Reporting and Analytics for ERP
-
supplier bank accounts fusion querySummary: I am trying to retrive the supplier bank accounts loaded in fusion at supplier header level. I have loaded bank accounts with only BANK_ACCOUNT_NUM. I did not i…
-
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
BICC Privileges or data access sets required to query PVO ReceivingReceiptTransactionExtractPVOSummary: Need to query PVO FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO via BI Cloud Connector. PVO is filtering data. Is there doc…Stéphane Lamy-Bouchard 4 views 0 comments 0 points Started by Stéphane Lamy-Bouchard Reporting and Analytics for ERP
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…Mainur-Oracle 113 views 11 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …Sheetal VBCS 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
sql query to fetch serial number per every transactionSummary: 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 establish Linkage in SAwhat is the linkage between Procurement - Pending Change Orders Real Time and Procurement - Purchasing Real Time Subject Areas. Although Order and Order Number from resp…Raakesh Piranawar 21 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Need to see supplier full account numberSummary: Is there any standard report in oracle we can leverage to see the full account number of Supplier. Could you please confirm? Content (please ensure you mask any…
-
Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached DocSummary: This post shares a comprehensive SQL query that retrieves detailed Contract information from Oracle Fusion ERP Cloud, especially for ECM_BUY contracts. It conso… -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 3.9K views 53 comments 20 points Most recent by Aitor Quintela Reporting and Analytics for ERP
-
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 54.8K views 137 comments 30 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 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 61 views 1 comment 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 21 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 43 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 553 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…