EGL: How To Resolve Journal Post Error GLPPINWK-BE000 INS HDR TMP POST? (Doc ID 1308608.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms


When attempting to run the Journal Post process via online or batch, the following error occurs:

ERROR
-----------------------
GLPPPOST and GLPPPST0 -
PSPSQLRT error in Posting: GLPPINWK-BE000 INS HDR TMP POST.

FS_JGEN -
PSPSQLRT error in Posting: GLPPINWK-BE000 INS HDR TMP POST.
Remote program PTPECOBL failed with return code: 904 .Reason: ORA-00904: "PC_DISTRIB_STATUS": invalid identifier.

In section: SQLRT: EXECUTE-STMT (2,-1) GL_JCOBOL.MAIN.GBL.default.1900-01-01.COBOL. OnExecute PCPC:647 Statement:2
Process 727962 ABENDED at Step GL_JCOBOL.MAIN.COBOL (PeopleCode) -- RC = 8


STEPS
-----------------------
1. Create or open journal to be edited.
2. Select Journal Post online or setup up the Journal Post Request process.
3. Run GLPPPOST process

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