Procurement
Discussion List
-
Supplier Statement ReportSummary: Any OTBI or Seeded Supplier Statement Summary & Details report including transactions details and opening closing balances. Content (required): Any OTBI or Seed…Bilalemail 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet Content This spreadsheet is published by Oracle OTBI Development. …Ramamurthy Shankarachetty-Oracle 6.2K views 37 comments 33 points Most recent by Tracy C Reporting and Analytics for SCM -
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c…Sai Revanth-Oracle 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Is it possible to give OTBI analysis access to Department Managers without any job role?Summary: Hello, We have a requirement to see PR-related analysis by department managers. These managers are not having roles or data access related to SSP module. Simila…
-
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…Hendra_innopia 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
Can we customize the Award Negotiation Spreadsheet?Summary: Is is possible to customize the Award Negotiation spreadsheet? Also , is this report a BIP report in OTBI? If yes can you share the location? If it is not what … -
Custom Report Printing PO Terms and ConditionsSummary: How to Print PO Terms and Conditions? Content (required): Is there a way to add the Terms and Conditions attached to PO to a custom report. I've checked the sta…
-
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …Astrid Ferrao-Oracle 21 views 2 comments 0 points Most recent by Astrid Ferrao-Oracle Inventory Management
-
Table and column for Firm DateSummary: The supply planning UI shows Firm Date as a column in the supplies and demands table. This date reflects when the product is expected to arrive. What is the tab…
-
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…sanjam1130 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Ability to run BI report from Isupplier portalContent Hi Experts, We have built one custom report related supplier performance in BI. Requirement is Suppliers should be able to access the reports in iSupplier Portal…Venkatesh Periketi 14 views 2 comments 4 points Most recent by Sahil Makhiza Reporting and Analytics for SCM -
What is a "Perfect Invoice" in Oracle terms?Summary: In the subject area "Procurement - Spend Real Time" there is a measure called "“# of Perfect Invoices". Content (required): In the subject area "Procurement - S…Anders W. Langholm 1 view 1 comment 0 points Most recent by Anders W. Langholm Reporting and Analytics for SCM -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…Sushan Peiris 53 views 8 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 182 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 24 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …Sushan Peiris 374 views 1 comment 2 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…Rohit Kumar-266502 94 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 31 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 50 views 3 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 20 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…
-
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…Helen Thomas 23 views 2 comments 3 points Most recent by Helen Thomas Reporting and Analytics for SCM
-
Boost Revenue and Profit Performance With Oracle IBPXSummary Join us on Wednesday, January 20 from 11:00 AM - 12:00 PM CT to learn how to implement forward-looking metrics to drive optimum performanceContent Manufacturers … -
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 22 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…Yogesh Nemchand 23 views 1 comment 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Track Buyers' purchasing patternsSummary Track Buyers' purchasing patternsContent We are implementing Procurement and we have a requirement of a report to track buyers purchasing patterns in cloud. Is t…
-
How to join Procurement - Procure To Pay Real Time and Procurement - Purchasing Real Time without "OSummary Ability to display PO Line DFF with Procure to Pay information and Logical SQLContent We would like to display the PO Line DFF with Procure to Pay information an…
-
PO Unit Price incorrectly rounding to nearest number in PO PDFSummary PO Unit Price incorrectly rounding to nearest number in PO PDFContent Question about decimal places on PO's - even though only two digits show up, does the syste…vijayakrishna 20 views 31 comments 2 points Most recent by vijayakrishna Reporting and Analytics for SCM