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.
When inserting three lines in interface, then run 'Import Price Catalog' with the below parameters:
Create or Update Items:No
Create Sourcing Rules:No
The 1st and 2nd BPA data have proper values, but the 3rd PO data set as below:
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.
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