My Oracle Support Banner

Some Who Columes Value Became to -1 Due to Batch Size of Import Price Catalog (Doc ID 2615544.1)

Last updated on DECEMBER 02, 2019

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.


Actual Behavior
When inserting three lines in interface, then run 'Import Price Catalog' with the below parameters:

Document Type:Blanket
Create or Update Items:No
Create Sourcing Rules:No
Approval Status:APPROVED
Global Agreement:No
Group Lines:No
Batch Size:2
Gather Stats:No

The 1st and 2nd BPA data have proper values, but the 3rd PO data set as below:



Expected Behavior
The po_headers_all/po_lines_all : request_id, PROGRAM_APPLICATION_ID,PROGRAM_ID of 3rd po data have proper values but not -1.

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Import Price Catalog with 3 PO's and set batch_size = 2 and approval status = APPROVED.
Approval Status:APPROVED
Global Agreement:No
Group Lines:No
Batch Size:2

2. Check the imported 3 PO data.
- For first and second PO, request_id, PROGRAM_APPLICATION_ID, and PROGRAM_ID have proper values in po_headers_all/po_lines_all table

- For third PO only request_id has proper value.
But the value for PROGRAM_APPLICATION_ID and PROGRAM_ID is -1in po_headers_all/po_lines_all table


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

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