My Oracle Support Banner

Fatal SQL error occured. (2,125) PO.Change Track.ChngRsn.OnExecute Name: RetrieveLastReason, When Clicking on Current Change Reason Link on Contract Header With Contract Id Having Single Quote (Doc ID 2624149.1)

Last updated on JANUARY 03, 2020

Applies to:

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

Symptoms

Contract Header Error, contract ID string with single quote and when click on current change reason link.

Error:

A SQL error occurred.
FATAL SQL error occurred. (2,125) PO. Change Track.ChngRsn. OnExecute Name:RetrieveLastReason PCPC:10275 Statement: 150
Called from:CNTRCT_WRK1.GOTO_RSN_CD.FieldChange Statement:9

Steps:

1.Set Up Financials/Supply Chain > Product Related > Procurement Options > Purchasing > Set Controls-Contracts
     - Make sure Reason Code required is checked and default reason code is provided
2.Navigate to Supplier Contracts > Create Contracts and Documents > Contract Entry
3.Created a contract with contract ID string with single quote example - (Abc'd 2019 SAMPLE)
4.Save the contract
5.Search for the created contract
6.Open the contract and click on current change reason link
7. Above error occurs

Changes

 

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