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:

Symptoms

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:

PO_HEADERS_ALL.PROGRAM_APPLICATION_ID:-1
PO_HEADERS_ALL.PROGRAM_ID:-1

PO_LINES_ALL.REQUEST_ID:-1
PO_LINES_ALL.PROGRAM_APPLICATION_ID:-1
PO_LINES_ALL.PROGRAM_ID:-1

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

Cause

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