My Oracle Support Banner

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 ***


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:

 "Item Validation Resulted in error(s)"

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.

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


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

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