EGL: After Update to PeopleTools 8.59.18, Post Journal Page Add/Search Results to Error -- 'SQL error in Exec. (2,280) JRNL_POST_REQ.BUSINESS_UNIT.RowInit PCPC:743 Statement:22'
(Doc ID 2993837.1)
Last updated on JANUARY 04, 2024
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
User gets a fatal error in batch Post Journal process add/find an existing value -- General Ledger > Journals > Process Journals > Post Journals.
This started after updating to PT 8.59.18, while there was no change in Image level, which currently in Image 36.
From the error, it seems to be expecting below records in the code:
GL_JRNL_SRC_BU
GL_JRNL_USR_SRC
GL_JRNL_ROL_SRCActivity Guide
Error/s:
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.'
Steps to replicate:
1. Navigate to General Ledger > Journals > Process Journals > Post Journals.
2. Enter a Run Control ID.
3. Click Search or Add, in the case of existing and new run control, respectively.
4. Receive the error/s.
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 |