Update Income Tax Details Utility Report ORA-01427: single-row subquery returns more than one row (Doc ID 1284160.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to Run the Update Income Tax Details Utility Report the following error occurs.

ERROR
-----------------------
MSG-00010: Counting distributions for 1099 vendors...
MSG-00010: Counting distributions for 1099 vendors...
ORA-01427: single-row subquery returns more than one row
( ==> select pvs2.state
ORA-01427: single-row subquery returns more than one row
( ==> select pvs2.state
REP-0069: Internal error
In-process job terminated:Terminated with error:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run 'Update Income Tax Details Utility Report'

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Users need to run the report and provide the results to third party

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