GLPPPOST COBOL Process Throwing Error - View log/trace shows - SQLRT: INVALID DBTYPE:GLPPPOST

(Doc ID 2395288.1)

Last updated on MAY 07, 2018

Applies to:

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

Symptoms

Application - FSCM9.1 Bundle#32  Peopletools - 8.52.26 Database - Oracle 11.2.0.4 Environment Affected: Production

Issue:GLPPPOST COBOL Process throwing error

Symptoms:
1)Post Journal Request (GLPPPOST) process is throwing error in production.
2) The process was running fine till now.
3) however, today when users is trying to run the same process with trace, the process abended
(%ÛTYPE%%/%ÛNAME%%/%%OPRID%%/%%OPRPSWD%%/%%RUNCNTLID%%/%%INSTANCE%%/135/%ÛFLAG%%), it is throwing below error.

View log/trace - SQLRT: INVALID DBTYPE:GLPPPOST
Message log - Process Request shows status of 'INITIATED' or 'PROCESSING' but no longer running

Even when we are trying to run the process without trace, it is throwing same error.

What is Working: COBOL process (PTPDBTST) is running fine, both with and without trace.

The GLPPPOST is working fine in other environments.

Changes

 

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