My Oracle Support Banner

EGL91+:Open Item Key Value Not Picked By Journal Generator Process when the Data Is Loaded From Third party Flat File (Doc ID 2958964.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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


After adding a new column Open item key to  payroll third party flat file to load the account entry table and while  running the journal generator the process fails with the below error

Cannot insert duplicate key row in object 'dbo.PS_DIST_LN' with unique index '.PS_JRNL_LN'

Replication Steps

1)Added Open Item key to third  party  File Layout interface
2)Run monthly subsystem interface  open item successfully picked in the staging table
3)Run the  Journal Generator process with Retain Detail Option




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.