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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |