EGL: Journal: After Deleting Journal Generated Journal, Journal Shows Deleted But Subsystem Table Did Not Have GL_DISTRIB_STATUS Updated To N (Doc ID 1477417.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Goal

We are using "Generic" accounting entry definition and we have this value setup for multiple SETIDS to support the way we have our journal entries setup.   It seems like the setid can not be properly identified and passed with this setup.  Since it can not determine which SETID to use, it deletes the journal but does not reset the distrib status so that the journal can be resent.

Function JRNL_PANELS_WR.PB_DELETE.SavePostChange pb_delete_sp() (Record PeopleCode) the SQLExec SQLExec("SELECT RECNAME_UPDATE FROM PS_JRNLGEN_DEFN WHERE ACCTG_DEF_NAME=:1", JRNL_HEADER.ACCTG_DEF_NAME, &RECNAME) runs without passing the SETID as a parameter when the installation has a SETID beyond SHARE and this can cause errors.

This function is performed when an Accounting Entry is deleted in Main Menu> Accounting> Journal> Journal> Create / Update Journal.

 


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms