After Creating A New Contract, Receiving FATAL SQL Error When Attempting To Add A Document (Doc ID 2176656.1)

Last updated on JANUARY 13, 2017

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

Fatal SQL error when attempting to add a document to a Contract

The issue can be reproduced at will with the following steps:
1. Create a Purchase Order contract - Supplier Contracts, Create Contracts and Documents, Contract Entry.
2. Enter the necessary information and Save the Contract.
3. Click the Add Document button.
4. The following error is displayed:

A Fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL error in Exec. (2,280) SCM_CS_DOC_MGMT.DocumentObject.OnExecute Name:create_new_doc PCPC:8887 Statement: 105
Called from: SCM_CS_DOC_MGMT.CreateDocFromPOContracts.OnExecute Name:BuildDocument Statement: 116
Called from: SCM_SC_CONTENTS_SEARCH.Utility.Common.OnExecute Name:GetContentRegistry Statement: 51
Called from: SCM_CS_CONTENTS_SEARCH.Utility.Common.OnExecute Name:RedirectURL Statement 9
Called from: CS_CNTRCT_WRK.CREATE_PB.FieldChange Statement 26

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

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