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.
Contract Header Error, contract ID string with single quote and when click on current change reason link.
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
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
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