My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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