My Oracle Support Banner

EBI.9.1+ BI_IVCEXT Failed At Step BI_IVCEXT.UPDPYTRD.Step10 With ORA-01427 When Running The Job : BIPJ50 (Doc ID 2407030.1)

Last updated on APRIL 07, 2019

Applies to:

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


When attempting to run reprint invoices, BIPJ50 process has the following error.

ABENDED at Step BI_IVCEXT.UPDPYTRD.Step10 (Action SQL) -- RC = 1427
-- SQL Error: ORA-01427: single-row subquery returns more than one row tips

The issue can be reproduced at will with the following steps:

  1. Add a new Payment Terms using an existing Payment Terms and set it to Inactive;
  2. Choose an Invoice using that Payment Terms ID with Invoice Date less than today;
  3. Set the Language Code to "French" for the customer used, in the Customer General information;
  4. Run the JOB : BIPJ50 to Print the Invoice selected - BIPJ50 runs to No Success because the Application Engine BI_IVCEXT abends at Step BI_IVCEXT.UPDPYTRD.Step10 with SQL Error ORA-01427 : single-row subquery returns more than one row tips.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.