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.
After applying fix for <Bug 28320935>, the allocation process runs to error for project allocations.
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
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