Fusion Procurement reporting
Discussion List
-
How to display the latest value (Contract Agreed Amount)?Summary: I am creating an OTBI report for contracts including the contract agreed amount field. Because the contract has revisions, the contract agreed amount is display… -
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 …
-
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne…
-
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.9K views 14 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Feasibility check: OTBI report for supplier registration resubmissionsSummary: Hi Team, We received a customer requirement to understand which suppliers have the most difficulty during the supplier registration process, along with their vo…
-
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…
-
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…
-
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens…
-
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… -
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. …Varun Dhondea 155 views 1 comment 0 points Most recent by Rajat_Gupta Reporting and Analytics for ERP -
Procurement Procure to Pay real time subject area no data showing on purchase order measurements colProcurement Procure to Pay real time subject area no data showing on purchase order measurements Ordered Amount, Delivered Amount and Open Ordered Amounts User has AP ro…
-
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 53 views 3 comments 0 points Most recent by Nathan CCC 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…
-
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 61.8K views 147 comments 33 points Most recent by YevgenyM Reporting and Analytics for ERP
-
Need to show or hide details in po approval notification based on the approversSummary: Hi Team, We have modified the PO approval notification to add few details. We would like to display some contents in the notification report only to few approve…
-
PO PDF Report Showing Truncated “Text to Supplier” – Full Attachment Name/Text Not Printing CompleteHi all, We’re facing an issue with the PO PDF report where the Text to Supplier (or text from the URL attachment) is not printing completely. When we open the attachment…
-
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…
-
Unable to link multiple subject areas in OTBI reportHi, I created an OTBI report with PO and Invoice details such as PO number, PO lines, PO amount, Invoice number, Invoice amount, Transaction currency and Ledger/Accounti…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. …Pranita S 91 views 3 comments 0 points Most recent by Judith COLLONGUES Reporting and Analytics for ERP -
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.4K views 7 comments 1 point Most recent by Ch M Prasad-Oracle 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. …
-
ESS Job (Copy of Accrual Reconciliation Report) throwing warning Too many matching records found."Hi, We have created a new ESS job by simply copying seeded Accrual Reconciliation Report. We did not touch any parameters and kept them as it is. We have just enabled bu…
-
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 1K views 8 comments 7 points Most recent by Mohamed Elwan Reporting and Analytics for ERP -
Assistance required to create Requisition Bucket with Bar graphHello, I am seeking assistance in developing a Requisition Aging Bucket in OTBI. The goal is to create a bar graph to present summarized requisition data on a dashboard.…Shubham Kadam 11 views 1 comment 0 points Most recent by Deepak Pai-Oracle Supply Chain Financial Orchestration
-
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 4.3K views 55 comments 20 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
Which report is responsible for managing the approval notification in the application and the emailSummary: We would like to add the supplier name to the report that manages the sending of approval notifications. The goal is to display the supplier name in both the in…Varun Dhondea 21 views 2 comments 0 points Most recent by Varun Dhondea Reporting and Analytics for ERP
-
How can I write a SQL query in Oracle Fusion Cloud to identify unapproved requisitions?Hi everyone, Please see the full question below. How can I write an SQL query in Oracle Fusion Cloud to identify unapproved requisitions where a specific approver (e.g.,…FlatFish534 21 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…Brian Burns 87 views 5 comments 5 points Most recent by daniel.valdovinos Reporting and Analytics for ERP -
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" is returning blankSummary: Has anyone get to the bottom of this, I am trying to bring back "Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" But it is coming black as blan…
-
Adding extra filters to Infolets (Order Management - Seeded Infolets)Summary Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'Content Currently the system allow users t…Senthilrajan V 154 views 9 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP