My Oracle Support Banner

E-AE: App Engine Message Log May Show Improper Statement Info For SQL Error (Doc ID 2552905.1)

Last updated on DECEMBER 13, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Symptoms

On : 8.57 version, Application Engine

after upgraded from PT 8.55.14, when some App Engine process run failed, the error messages get mess up with other process instances.  For example,

Error

-------------

SQL error. Function: SQLExec Error Position: 0 Return: 805 - ORA-00904: "ITM"."INV_ITEM_ID": invalid identifier

Statement: UPDATE PS_CHNG_RQST_DTL SET PROCESS_INSTANCE = 177204 WHERE PROCESS_INSTANCE <> 177204 AND CHG_PROCESS_STATUS NOT IN ('C', 'X') AND EXISTS ( SELECT 'X' FROM PS_CHNG_RQST C WHERE C.PROCES S_INSTANCE = 177204 AND C.BUSINESS_UNIT = PS_CHNG_RQST_DTL.BUSINESS_UNIT AND C.PO_ID = PS_CHNG_RQST_ DTL.PO_ID AND C.CHNG_SOURCE = PS_CHNG_RQST_DTL.CHNG_SOURCE AND C.CHNG_DTTM = PS_CHNG_RQST_DTL.CHNG_D TTM)

Original Statement: INSERT INTO ps_bh_in_picis_stg ( process_instance , business_unit , inv_item_ ...

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.