EOEN_MSG Subscription Messages Take Long To Process

(Doc ID 2091226.1)

Last updated on MAY 22, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Some subscription messages, including EOEN_MSG, processed take minutes to process instead of seconds. DBAs have identified a long running SQL. Is there an Oracle provided solution for this issue to update code that writes this sql for better performance

STEPS

The issue can be reproduced at will with the following steps:
1. EOEN_MSG subscription message


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