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 JUNE 04, 2018

Applies to:

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

Symptoms

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

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


STEPS
-----------------------
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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.