Allow Partial Processing of Interface Records in External Purchase Prices

Partial processing of interface records in external purchase prices is now possible when there are lines with errors. This flexibility to process contracts partially even if a few lines are in error enables downstream purchasing process to proceed for the other lines. This results in the ability to manage and maintain your purchase agreements better.

Prior to this update, if there were errors in importing any of the lines within an interface header, then the header and all the lines were considered to be in error and weren't imported. The records in error had to be reprocessed by running the Import External Purchase Prices scheduled process with the 'Reprocess Error' parameter set to Yes. 

With this update, the header and lines without errors are imported into external purchase prices. The records in error remain in the interface tables but you can't reprocess them directly from these tables. You must reimport the corrected records into the interface tables, and then run the Import External Purchase Prices scheduled process.

For example, suppose you have an interface header 111 with four lines. Now suppose one line for the SCH1002 part number has the Source UOM set to Box of 5, which has not been defined in the External Purchase Prices Unit of Measure mapping. Prior to this update, the header and all the four lines were retained in the Interface tables with errors. No external purchase price was created. In this scenario, you can either correct the data in the interface table or create a mapping and then reprocess the records.

However, with this update, only the line with error (that is, SCH1002) is retained in the interface table as error and the other lines with the header are created as an external purchase price record. In this case, you cannot reprocess the record in error even if the mapping is fixed. You need to reimport the required data again for it to be picked up for processing. Then, delete the interface records in error.

Illustration for Interface Table Data and Resultant Behavior With Opt-in Enabled and Disabled

Illustration for Interface Table Data and Resultant Behavior With Opt-in Enabled and Disabled

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Procurement

In the Offerings work area, enable the Allow Partial Processing of Interface Records in External Purchase Prices feature:

  • Offering: Procurement
  • Functional Area: External Purchase Prices

Select the Enable checkbox corresponding to the Allow Partial Processing of Interface Records in External Purchase Prices feature, and then click Done.

Opt-in Allow Partial Processing of Interface Records in External Purchase Prices.

Opt-in Allow Partial Processing of Interface Records in External Purchase Prices.

Tips And Considerations

If there is an error at the header level of the interface record, then even with the opt-in enabled, none of the records will be processed into External Purchase Prices.

When this feature opt-in is enabled, the Import External Purchase Prices scheduled process will not allow reprocessing records in error and the Reprocess Error parameter will be disabled. There is no option to reprocess any of the records in error and the required data should be re-sent from the source. You must delete the interface records in error using REST API or the predefined template for External Purchase Price Errors that uses the Oracle Visual Builder Add-in for Microsoft Excel plug-in. 

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Import Purchase Agreements from External Purchase Prices (SCH_UPDATE_BPA_FROM_EXTERNAL_PURCHASE_PRICES_PRIV)
  • Import Blanket Purchase Agreement (PO_IMPORT_BLANKET_PURCHASE_AGREEMENT_PRIV)

These privileges were available prior to this update.