Canceling (Purchase Order) PO Line And Finalizing Line before budget check Results in Error(10200,337)

(Doc ID 1586757.1)

Last updated on NOVEMBER 21, 2017

Applies to:

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


Canceling (Purchase Order) PO Line then Finalizing Line before budget checking results in invalid message (10200,337)

Steps to reproduce the issue:

1) Find or create a PO Line that is tied to a Req Line but not yet vouchered.
2) Click the Cancel Line button (on Line Details page). Answer Yes to continue. Answer 'No' or ‘Yes’ regarding making the req available to source again.
3) On the same PO Line, go back into Line Details and click the Finalize button.  Messages regarding cancelling the line will appear again.  That is not appropriate, but go ahead and respond in the affirmative to continue.  
4) The following message will appear which

Error Message:

Invalid message while SQL transaction in process: This action will finalize all eligible distributions for this line. Continue? (10200,337)
PO_KK_WRK.PB_FINAL_LINE.FieldChange Name:PartialFinalLine PCPC:655 Statement:9
Called from:PO_PNLS_WRK.GOTO_LINE_DTLS.FieldChange Name:goto_line_details Statement:348
Called from:PO_PNLS_WRK.GOTO_LINE_DTLS.FieldChange Statement:358  

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."


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