My Oracle Support Banner

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:

  'A fatal PeopleCode SQL error occurred. Please consult your system log for details.'
  'SQL error in Exec. (2,280) JRNL_POST_REQ.BUSINESS_UNIT.RowInit PCPC:743 Statement:22
  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


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