My Oracle Support Banner

PRC: PO: How To Derive Source Agreement During Purchase Orders Import (Doc ID 2792770.1)

Last updated on MAY 24, 2023

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.13.21.04.0 and later
Oracle Fusion Purchasing - Version 11.13.21.04.0 and later
Information in this document applies to any platform.

Goal

Actual Behavior
When importing Purchase Orders using Purchase Orders Import FBDI, item price is not derived from BPA unless Source Agreement Procurement BU, Source Agreement and Source Agreement Line columns on PO_LINES_INTERFACE sheet are populated.

Expected Behavior
When Price column on PO_LINES_INTEFACE sheet is NULL, BPA is derived from supplier and item, and the price is derived from BPA.

Steps to Reproduce

  1. Populate POPurchaseOrderImportTemplate.xlsm
    Leave Price, Source Agreement Procurement BU, Source Agreement and Source Agreement Line columns on PO_LINES_INTERFACE sheet blank
  2. Generate CSV File
  3. Run 'Load Interface File for Import' with the following parameters:
    Import Process=Import Orders
    Data File=select 'Upload a new file' and specify the file in step2.
  4. Run 'Import Orders'

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.