My Oracle Support Banner

ETL9.2 - Reported Time Approvals Calling The Same AWE INSERT Statements Repeatedly, Sometimes Causing Timeout (Doc ID 2640248.1)

Last updated on MARCH 02, 2021

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Users are getting timed out while submitting Reported Time for approval. Checking a trace file and the database shows that the issue seems to to be with AWE code looping through its INSERTS SQL statements -- it is trying to submit the same rows multiple times.

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.