EGOIJAVA: Create Multiple Items By Copying from Existing Item Throws ORA-01427: single-row subquery returns more than one row (Doc ID 2097503.1)

Last updated on JANUARY 15, 2016

Applies to:

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


On : 12.1.3 version, Catalog items

Getting subquery error when creating multiple items in APC.

Create multiple items by copying from existing items should not show errors

The issue can be reproduced at will with the following steps:

Navigate to Development Manager->Item Catalog->Create Production Items
Select - Copies of Existing Item
Enter the item number to copy from
Enter number of copies (more than one)
Select the Continue button

Review log file for EGOIJAVA concurrent program -


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