Blanket Sales Agreement Creation With 6000 Lines Resulting error Item Validation Resulted In Error(s)" (Doc ID 2000702.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked Relevance on 20-APR-2015 ***
*** Checked Relevance on 21-SEP-2015 ***
*** Checked Relevance on 03-Nov-2015 ***

Symptoms

On : 12.1.3 version, Agreements/Blankets/Contracts
When attempting to create a Blanket Sales Agreement with 6643 lines using oe_blanket_pub.process_blanket following (Reference note 790223.1) the following error messages for each line:


ERROR
-----------------------
 "Item Validation Resulted in error(s)"

Workaround:
As a work around, we can use the oe_blanket_pub.process_blanket to create the Sales Agreement initially with 2000 lines and then used the oe_blanket_form_control.insert_row to load the remaining lines in batches of 2000 at a time. This works fine.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
call the API Referenced in note 790223.1



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