Is There a Delivered Process to Purge Equation Process Instance Table EQTN_PRCS_INST? (Doc ID 2770961.1)

Last updated on JANUARY 25, 2024

Applies to:

Goal

A row is inserted into table EQTN_PRCS_INST every time an equation is run. This table records the equation name, EFFDT and process instance. When a user changes an equation and saves or compiles the equation, all rows on EQTN_PRCS_INST for that equation are automatically purged, along with the corresponding rows on PS_EQTN_GLOBAL_VAR.  But for an equation that is not updated and is being run frequently, rows will accumulate in the table for that equation.

A problem has been discovered in at least one instance, when an update was attempted to an equation, and an error occurred and the update wasn't saved. An analysis of the error determined that the equation had too many rows on EQTN_PRCS_INST for the purge code feature to handle - in this example case there were 44 million rows for that equation. It's not clear where the exact threshold is where the problem may begin to occur, and so there may be a desire proactively purge the data after a certain point, in order to prevent the problem from eventually occurring. 

Is there a delivered mechanism for purging the EQTN_PRCS_INST table - similar to what PRCSYSPURGE does for Process Request and Report Manager tables - and mimicking the purge that the delivered Peoplecode performs when saving and re-compiling an equation after a change(s)? 
 

Solution

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