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 laterInformation in this document applies to any platform.
Symptoms
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
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the process PSARCHIVE with delivered data archival template - GPGBRSLT
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 |
| References |