My Oracle Support Banner

EGL9.2: Project-to-GL Allocation Error With ABENDED At Step FS_ALLC_OUTJ.iJLine.iLine (Doc ID 2472311.1)

Last updated on APRIL 01, 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:
-------

After applying  fix for <Bug 28320935>, the allocation process runs to error for project allocations.


Error:
-------
ABENDED at Step FS_ALLC_OUTJ.iJLine.iLine

ORA-00001: unique constraint (PS_JRNL_LN) violated

 

The issue can be reproduced at will with the following steps:
1. Define the "ITD" Time span to start on FY2000/PD1 to FY2017/PD12.  
    a. Set Start/End Year Type to 'Absolute Year'
    b. Set Start/End Period Type set 'Absolute Period'.
2. Create allocation Step using `Copy' Allocation Type
    a. Pool Tab:
       Pool Record Type = Any Table
       Table = PROJ_RES_CAL_VW
       Time Span = ITD
       Define Account and business unit
    b. Target Tab:
       Target Record Type = Journal Records
       Target Ledger = RECORDING
       Time Span = PER
       Define Account, Activity, Analysis Type, Business Unit, PC Business Unit, Department, Journal Line References, and Project.
3. Create an allocation group for allocation step
4. Run Allocation on allocation group

See replication steps.

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.