ETL 9.1: Cannot Approve Time When Previously Deleted Time is Resubmitted (Doc ID 1531792.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Approvals

When attempting to submit previously deleted and re-entered time, the following error occurs.

ERROR
---------------------
The URL has not been set. (18081,5703) EOAW_UTILITIES.Portal.portalURL.OnExecute Name:getServletURL_ PCPC:5492 Statement:81
Called from:EOAW_UTILITIES.Portal.portalURL.OnExecute Name:GenerateComponentPortalURL Statement:53
Called from:EOAW_CORE.DEFN.AWTxn.OnExecute Name:GetNotifyURLOverride Statement:366
Called from:EOAW_CORE.NOTIFICATION.InlineStrategy.OnExecute Name:ProcessNotifications Statement:78
Called from:EOAW_CORE.NotificationEventHandler.OnExecute Name:ProcessNotifications Statement

The URL value defined on the Transaction Registry has no value. Refer to People Books for details on setting URLs

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

ISSUE 1

1. Enter and submit time for DUR XXX
2. Check the TL_APP_RPTD_XRF, EOAW_USERINST and EOAW_STEPINST tables,Thread status and Step status will be P(P is pending)
3. Delete the time and DO NOT SUBMIT
4. Check the TL_APP_RPTD_XRF, EOAW_USERINST and EOAW_STEPINST tables,Thread status and Step status will be P(P is pending)
5. Enter the same deleted data for the same DUR XXX  and click on SUBMIT
6. Check the TL_APP_RPTD_XRF, EOAW_USERINST and EOAW_STEPINST tables,Thread status will be T and Step status will be L( L/T is terminated)

Outcome : Needs approval exists in Reported time but no pending row in Approvals



ISSUE : 2

1. Enter and submit time for DUR XXX
2. Check the TL_APP_RPTD_XRF, EOAW_USERINST and EOAW_STEPINST tables,Thread status and Step status will be P(P is pending)
3. Delete the time and DO NOT SUBMIT
4. Check the TL_APP_RPTD_XRF, EOAW_USERINST and EOAW_STEPINST tables,Thread status will be T and Step status will be L( L/T is terminated)
5. Employee still didnot SUBMIT, so there are chances that Employee can Log off with out submitting the time sheet

Outcome :Needs approval exists in Reported time(as deleted time was not submitted) but no pending row in Approvals

Changes

 Issue 1 was fixed in HRMS 9.1 Bundle # 11 (BUG 12837221)

 Issue 2 was fixed in HRMS 9.1 BUNDLE #13 (Bug 16247835)

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