My Oracle Support Banner

"SQL Error: ORA-01407: cannot update ("SYSADM"."PS_OMH_LOCK_TAO4"."PROCESS_INSTANCE2") to NULL" when Running the 'OM Background Credit Check' Process (OM_CREDIT) (Doc ID 1421312.1)

Last updated on JANUARY 16, 2020

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9.1 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Mar-2013***

Symptoms

The following error is issued when running the 'OM Background Credit Check' process (OM_CREDIT) (navigation: Order Management, Quotes and Orders, Process Orders, Apply/Release Credit Hold):

SQL Error: ORA-01407: cannot update ("SYSADM"."PS_OMH_LOCK_TAO4"."PROCESS_INSTANCE2") to NULL

Process 1470595 ABENDED at Step OM_HLDUPD.END.RESETPI1 (Action SQL)

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.