Error "ORA-01427: single-row subquery returns more than one row" when Running the 'Item Loader' Process (IN_ITMLOAD)

(Doc ID 1684039.1)

Last updated on DECEMBER 14, 2017

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
Information in this document applies to any platform.

Goal

The 'Item Loader' process (IN_ITMLOAD) (navigation: SCM Integrations, Process Transactions, Items, Item Loader) fails with the following error:

SQL error. Function: SQL.Execute Error Position: 45 Return: 1427 - ORA-01427: single-row subquery returns more than one row Statement: update ps_master_item_ec set category_cd = ( SELECT CATEGORY_CD FROM PS_ITM_CAT_TBL C WHERE C.SETID = PS_MASTER_ITEM_EC.SETID AND C.CATEGORY_ID = PS_MASTER_ITEM_EC.CATEGORY_ID) WHERE CAT EGORY_CD = ' ' AND EXISTS ( SELECT 'Y' FROM PS_ITM_CAT_TBL C WHERE C.SETID = PS_MASTER_ITEM_EC.SETID AND C.CATEGORY_ID = PS_MASTER_ITEM_EC.CATEGORY_ID) AND EXISTS (SELECT 'Y' FROM PS_EO_EIP_CTL B WHERE B.EIP_CTL_ID = PS_MASTER_ITEM_EC.EIP_CTL_ID AND B.PROCESS_INSTANCE = :1 AND B.EIP_DTA_STATUS = '3 ')

 
How to resolve it?

Solution

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