Error in PeopleCode ScrollSelect Processing. (2,213) PO.Contracts.Contract.OnExecute when clicking the Process Purchase Order button on Work Order. (Doc ID 1593350.1)

Last updated on DECEMBER 13, 2016

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Error when clicking Process Purchase Order on Work Order:

 

Error: 

Invalid message while SQL transaction in process: Invalid message while SQL
transaction in process: Error in PeopleCode ScrollSelect processing. (2,213)
PO.Contracts.Contract.OnExecute Name:PopulateContractRowset PCPC:23963
Statement:368
Called from:PO.Contracts.Contract.OnExecute Name:FindEffectiveContract
Statement:222
Called from:PO.Contracts.Contract.OnExecute Name:FindContract Statement:146
Called from:SP.SPF.WorkOrder.OnExecute Name:Get_Contract_Detail Statement:139
Called from:SP.SPF.Wor

A PeopleCode program tried to issue the indicated message while an SQL cursor
is open. The message is invalid because it requires user input.

Review the PeopleCode and either move the message to a place where it will be
issued during user "think-time", or change the "style" so no choice is
required.

 

Replication steps:

1) On Services Procurement Installation Options, turn on:
     PO Work Order Integration
     PO Service Contracts Enabled
2)Create a work order
3)Once all processing is complete and the Process Purchase Order button is available, click the Process Purchase Order button and error is thrown.

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