My Oracle Support Banner

E-AE: Field.AE_STMT_TYPE Translate Values do Not Match with Data in the Record.PSAESTMTDEFN (Doc ID 2948756.1)

Last updated on JULY 03, 2023

Applies to:

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


Values stored in PSAESTMTDEFN.AE_STMT_TYPE field are different from the Translate values stored in the AE_STMT_TYPE field definition (Field.AE_STMT_TYPE), causing a custom  audit report to fail. Below are the values in question.

C: Call Section (update)
S: SQL (update)
U: no longer used?
P: PeopleCode (missing)
X: XSLT (missing)

Steps to replicate:
1. Create and run the custom audit report.
2. Observe the failure.


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

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