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.

Symptoms

On : 12.1.3 version, Catalog items

ACTUAL BEHAVIOR
---------------
Getting subquery error when creating multiple items in APC.

EXPECTED BEHAVIOR
-----------------------
Create multiple items by copying from existing items should not show errors

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

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