PC_PO_TO_PC ABENDS AT STEP PC_PO_TO_PC.21000000.UPDATE2 (SQL) - ORA-1427 (Doc ID 2152541.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, PUM 16, Tools 8.54.18

When attempting to run PC_PO_TO_PC, the following error occurs.

ERROR
-----------------------

PC_PO_TO_PC ABENDS AT STEP PC_PO_TO_PC.21000000.UPDATE2
SQL Error: ORA-01427: single-row subquery returns more than one row.

Two req's causing an error when running PC_PO_TO_PC - SQL Server]Subquery returned more than 1 row


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Configure VAT in Purchasing.
2) Create a project and activity.
3) Create requisition with two lines against the activity. Ensure there is recoverable VAT calculated for the requisition lines.
4) Run PC_PO_TO_PC.

 

 

 

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