EBI.9.1+ BI_IVCEXT Failed At Step BI_IVCEXT.UPDPYTRD.Step10 With ORA-01427 When Running The Job : BIPJ50
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.
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:
- Add a new Payment Terms using an existing Payment Terms and set it to Inactive;
- Choose an Invoice using that Payment Terms ID with Invoice Date less than today;
- Set the Language Code to "French" for the customer used, in the Customer General information;
- 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.
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