My Oracle Support Banner

E-ES: Voucher Build Fails With SQL Error On RTI Table -- ORA-01400: cannot insert NULL into ("SYSADM"."PS_PTSF_RTISTG"."PTRTIGUID") ORA-06512: at "SYSAD M.SFA_VOUCHER_TR", line 1 ORA-04088: error during execution of trigger 'SYSADM.SFA_VOUCHER_TR' Failed (Doc ID 2854173.1)

Last updated on MARCH 08, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.

Symptoms

Voucher build was working fine using RTI (Real Time Indexing). After a PUM Image upgrade applying 33191555 (and supporting patches), RTI no longer works, i.e. when we make any change to a voucher, this  change does not get indexed into Elasticsearch.

PeopleTools 8.59.05
ELK 7.10.0_03
FSCM PI # 42

In the appsrv_<ddmm>.log file located under the <PS_CFG_HOME>/appserv/logs folder we could see the below error:

 

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