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
PeopleSoft Enterprise SCM Inventory - Version 9.1 and later Information in this document applies to any platform.
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?
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