My Oracle Support Banner

Structure Bulkload Program Error When Updating Structures With Over 1000 Components With Error ORA-01795: maximum number of expressions in a list is 1000 (Doc ID 2376242.1)

Last updated on MARCH 20, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Catalog items

Structure Bulkload Program Erroring when UPDATING Structures

Requirement : To end date all 4321 components under the assembly programmatically through API.
Have loaded data into staging and from there into BOM Interface tables and triggered the Structure Bulkload Program.

ERROR
-----------------------
ORA-01795; ORA-06502

 Error: -----> ## Detail 0 ##
  java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run structure bulkload

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!


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