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

Last updated on AUGUST 15, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Archiving

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

As per the above information our Arvive job fails on the unique constraint error as the key structure in history table and source table varies after upgrade .
currently we are on PS 9.2 PT 8.53.22

ERROR
-----------------------


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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. setup source
2. setup target
3. Run archive process
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot archive the data

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms