EGL9.2: GL_JP Process for STD_BUDG journal Abending At Step GL_JP_POST.Process.setDc0 (Doc ID 1943144.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

ENVIRONMENT:
------------------
Release 9.2 PUM 8

ISSUE:
-------
When running journal post (GL_JP) for STD_BUDG journal, the process abend with the following error

ERROR:
---------

-- 13.35.29 .........(GL_JP_POST.Process.setDc0) (SQL)
UPDATE PS_LEDGER_TMP_BUD2 SET date_code=3D '0' WHERE process_instance =
=3D2136170=20
AND date_code =3D ' '
/
-- Row(s) affected: 0
-- 13.35.31 Process 2136170 ABENDED at Step GL_JP_POST.Process.setDc0 =
(Action SQL) -- RC =3D 8010
ROLLBACK
/
-- 13.35.32 SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL =
Server]Invalid column name 'DATE_CODE'.


Cause

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