My Oracle Support Banner

AM: Data Archival Process Failed- PSARCHIVE With Delivered Data Archival Template- GPGBRSLT While Processing GP_ABS_EVENT_VW (Doc ID 2634591.1)

Last updated on NOVEMBER 26, 2021

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 and later
Information in this document applies to any platform.


There is an issue while restoring the data from history tables to actual tables through delivered Data archival process - PSARCHIVE with delivered data archival template- GPGBRSLT with the below error.

Processing GP_ABS_EVENT_VW (142,89)

SQL.Execute: SQL error closing bulk mode: ORA-01400: cannot insert NULL into ("SYSADM"."PS_GP_ABS_EVENT"."ABS_CAN_REASON") (2,298) PSARCHIVE.ROWBASED.GBL.default.1900-01-01.Step001.OnExecute PCPC:9411 Statement:145

Process 263792 ABENDED at Step PSARCHIVE.ROWBASED.Step001 (PeopleCode) -- RC = 24 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 14.26.31 2019-09-11

The issue can be reproduced at will with the following steps:
1. Use the process PSARCHIVE with delivered data archival template - GPGBRSLT




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

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