My Oracle Support Banner

EGL 9.2: Year End Close Process(GL_YC) Abended at Step GL_YC_OUTJ.InsJLn2.InsJLnDN with "ORA-00001: Unique Constraint" Error (Doc ID 2816840.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

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

Symptoms

If Separate DR/CR Amount Fields in Ledger for a Unit Page are enabled for a ledger group then GL_YC Process Abends with below error.


Steps to replicate :
--------------------
1) Enabling Document Sequencing for a BU.
2) Activating and defaulting Account Balancing Group : Group_1 via navigation Main Menu > Setup Financials/Supply Chain > Common Definitions > Design ChartFields > Configure > Account Balancing Group
3) Enabling Account Balancing Attributes i.e Balance Sheet Indicator and Book Code from installation Page.
4) Defining Closing rules via below navigation.
     Main Menu > General Ledger > Close Ledgers > Closing Rules
5) Defining Closing group for closing rule created in step 4.
6) Enabling Separate DR/CR Amount Fields in Ledger for a Unit Page.
7) Posting a journal for BU used in step 1.
8) Ran GL_YC 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.