Catalog Bulk Load - Items Upload Is Failing Error: Column OVER_TOLERANCE_ERROR_FLAG (VALUE=WARNING) Must Be NULL (Doc ID 1942952.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

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

Symptoms

When attempting to upload items in GBPA/BPA, the following error occurs.

ERROR
-----------------------
Error: "The loader has encountered an unexpected Purchasing Document Open Interface
error. Please run the concurrent program, "Purge Purchasing Open Interface
Processed Data" to see the detailed errors.

After <patch 18724731>:R12.PO.B, the error changed to:

ERROR_MESSAGE ERROR_MESSAGE_NAME INTERFACE_LINE_ID TABLE_NAME COLUMN_NAME COLUMN_VALUE
Error: Column OVER_TOLERANCE_ERROR_FLAG (VALUE=WARNING) must be NULL. PO_PDOI_COLUMN_NULL 23,344,519 PO_LINES_INTERFACE OVER_TOLERANCE_ERROR_FLAG WARNING


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open GBPA
2. Upload the items


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms