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)
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.
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:
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:
- Create a Sales Order in a 'Pending' status for Customer A and save.
- 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).
- 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.
- Ship the Sales Order.
- Run the OM_BILL process for the Sales Order and observe the error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms