My Oracle Support Banner

EGL9.2: Archive Job Fails With Unique Constraint Error Due To SETTLEMENT_DT Not As Key (Doc ID 2172320.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------
Archive Job fails on unique constraint Error

Source table : PS_JRNL_CF_BAL_TBL OL, PS_JRNL_HDR_H BTH
FIELD : key field settlement_DT is present

Target table : JRNL_CF_BAL_H
FIELD : key field settlement_DT is absent



Error:
-------
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_JRNL_CF_BAL_H) violated

Steps to Replicate:
---------------------
1. setup source
2. setup target
3. Run archive process

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


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