My Oracle Support Banner

Processes Using Equation Engine Insert Orphaned Data in PS_MESSAGE_LOG And PS_MESSAGE_LOGPARM (Doc ID 2541119.1)

Last updated on FEBRUARY 04, 2020

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms


When running a process involving equation engine, the process inserts orphaned data into the PS_MESSAGE_LOG and PS_MESSAGE_LOGPARM tables for the process FAPEQRUN. The data is assigned a process instance that doesn't match the instance of any scheduled process. Thus when running PRCSYSPURGE, these rows never get purged.

The issue does not occur every time equation engine is used in any form, but only in certain instances; for example, running a process that involves a pop select with equation engine as the method.



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
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.