EAP: Voucher Build Abends at LC_VATDRIVER.DRIVER.Step01 With Error -- "single-row subquery returns more than one row" (Doc ID 1345142.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version: 8.9 and later   [Release: 8.9 and later ]
Information in this document applies to any platform.

Symptoms

Voucher build abends when processing vouchers with VAT

Error

SQL error. Function: CreateSQL
Error Position: 47
Return: 1427 - ORA-01427: single-row subquery returns more than one row

Fatal SQL error occurred. (2,125) LC_VATDRIVER.DRIVER.GBL.default.1900-01-01.Step01.OnExecute Name:RunSQL2 PCPC:4903 Statement:71
Called from:LC_VATDRIVER.DRIVER.GBL.default.1900-01-01.Step01.OnExecute Statement:201

Process 302991 ABENDED at Step LC_VATDRIVER.DRIVER.Step01 (PeopleCode) -- RC = 8 (108,524)

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