Error "ORA-1427: single-row subquery returns more than one row / Process ABENDED at Step OM_BIDFTC.TEAMMBR.Step01 (SQL) -- RC = 1427 (108,524)" when Running the 'OM Billing Interface' process (OM_BILL) (Doc ID 1584275.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When modifing the Ship To Customer on a Sales Order, the old Sales Team Members are left on the order, resulting in an abend of the 'OM Billing Interface' process (OM_BILL) (navigation: Order Management, Quotes and Orders, Create OM Billing Entries, Process OM Billing) with the following error:

ORA-01427: single-row subquery returns more than one row

Failed SQL stmt:UPDATE PS_OMBI_INF_TAO4 SET SALES_PERSON = ( SELECT SCHCOM.SUPPORT_TEAM_MBR FROM PS_ORD_SCH_COMM SCHCOM WHERE SCHCOM.BUSINESS_UNIT = PS_OMBI_INF_TAO4.BUSINESS_UNIT_OM AND SCHCOM.ORDER_NO = PS_OMBI_INF_TAO4.ORDER_NO AND SCHCOM.ORDER_INT_LINE_NO = PS_OMBI_INF_TAO4.ORDER_INT_LINE_NO AND SCHCOM.SCHED_LINE_NBR = ...

Process 20108 ABENDED at Step OM_BIDFTC.TEAMMBR.Step01 (SQL) -- RC = 1427 (108,524)


Steps to reproduce the issue:

  1. Create a Sales Order in a 'Pending' status for Customer A and save.
  2. Change the Ship To Customer at the header from Customer A to Customer B and save (make sure Customer B has a different Service Team than Customer A).
  3. Change the Ship To Customer at line level to match the header and save > at this point, the PS_ORD_SCH_COMM table has duplicate rows.
  4. Ship the Sales Order.
  5. Run the OM_BILL process for the Sales Order and observe the error.

Changes

 

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