My Oracle Support Banner

EGL9.2: PC-to-GL Allocation Abended at Step FS_ALLC_OUTJ.iJLine.iLine With "ORA-00001: unique constraint" Error After Applying Fix for Bug 28320935 (Doc ID 2472311.1)

Last updated on APRIL 16, 2021

Applies to:

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


After applying  fix for <Bug 28320935>, the allocation process runs to error at Step FS_ALLC_OUTJ.iJLine.iLine for project allocations.



Steps to Replicate:

1. Define a newTime 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





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

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