PAYAUTRM: Termination Payments performance Issues After AU.22 & RUP7

(Doc ID 1960403.1)

Last updated on JULY 14, 2016

Applies to:

Oracle HRMS (Australia) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ISSUE 1: 

Slow performance when accessing the Termination Payments form (PAYAUTRM) since applying

- Patch 18004477:R12.HR_PF.B.delta.7 - Release 12.1 HRMS RUP7
- Patch 19764591:R12.PER.B - R121.AU.22 AUSTRALIA CUMULATIVE RELEASE


After clicking the find button the form takes around 30seconds to open.
Prior to patching it only took a few seconds.

MOST EXPENSIVE QUERY

SELECT PRE78_PAY_ENTRY_VALUE,PRE78_HOURS_ENTRY_VALUE,POST78_PAY_ENTRY_VALUE,
POST78_HOURS_ENTRY_VALUE,POST93_PAY_ENTRY_VALUE,POST93_HOURS_ENTRY_VALUE,
ROW_ID,OBJECT_VERSION_NUMBER,ELEMENT_ENTRY_ID,ELEMENT_LINK_ID,CREATOR_TYPE,
ENTRY_TYPE,ELEMENT_TYPE_ID,PRE78_PAY_INPUT_VALUE_ID,
POST78_PAY_INPUT_VALUE_ID,POST93_PAY_INPUT_VALUE_ID,
PRE78_HOURS_INPUT_VALUE_ID,POST78_HOURS_INPUT_VALUE_ID,
POST93_HOURS_INPUT_VALUE_ID,OVERRIDE_ELIG_INPUT_VALUE_ID,ASSIGNMENT_ID,
EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PROCESSED,PRE78_PAY_UOM,
PRE78_hours_UOM,post78_pay_uom,POST78_HOURS_UOM,POST93_PAY_UOM,
POST93_HOURS_UOM,OVERRIDE_ELIG_PAY_UOM,OVERRIDE_ELIG_ENTRY_VALUE
FROM
pay_au_term_long_v WHERE (ASSIGNMENT_ID=:1)

   

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.16 0.16 0 0 0 0
Fetch 1 48.39 48.41 0 196939 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 48.56 48.57 0 196939 0 0



ISSUE 2:

Applied Patch 21071839:R12.PER.B - TERMINATION PAYMENT FORM STILL HANGS POST PATCH 20985396:R12.PER.B.

Find after 'ETP on Termination' element is added under ENTRIES of Termination Payment form, upon closing the entries form it hangs and the main Termination Payment form never returns.

SQL Spinning is:

SELECT
PAY_ETP_ENTRY_VALUE,TRANS_ETP_ENTRY_VALUE,PART_PREV_ETP_ENTRY_VALUE,REDUNDANCY
_ENTRY_VALUE,REDUNDANCY_NE_CHK,COMPENSATION_ENTRY_VALUE,COMPENSATION_NE_CHK,GO
LDEN_ENTRY_VALUE,GOLDEN_NE_CHK,LIEU_ENTRY_VALUE,LIEU_NE_CHK,SICK_ENTRY_VALUE,S
ICK_NE_CHK,RDO_ENTRY_VALUE,RDO_NE_CHK,OTHER_ENTRY_VALUE,OTHER_NE_CHK,ROW_ID,OB
JECT_VERSION_NUMBER,ELEMENT_ENTRY_ID,ELEMENT_LINK_ID,CREATOR_TYPE,ENTRY_TYPE,E
LEMENT_TYPE_ID,REDUNDANCY_INPUT_VALUE_ID,COMPENSATION_INPUT_VALUE_ID,PAY_ETP_I
NPUT_VALUE_ID,GOLDEN_INPUT_VALUE_ID,LIEU_INPUT_VALUE_ID,SICK_INPUT_VALUE_ID,RD
O_INPUT_VALUE_ID,OTHER_INPUT_VALUE_ID,TRANS_ETP_INPUT_VALUE_ID,PART_PREV_ETP_I
NPUT_VALUE_ID,ASSIGNMENT_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,REDUNDANCY
_UOM,COMPENSATION_UOM,GOLDEN_UOM,LIEU_UOM,SICK_UOM,RDO_UOM,OTHER_UOM,PRE_1983_
INPUT_VALUE_ID,PRE_1983_UOM,POST_1983_INPUT_VALUE_ID,POST_1983_UOM,ETP_CS_DATE
_INPUT_VALUE_ID,ETP_CS_DATE_UOM,PRE_1983_ENTRY_VALUE,POST_1983_ENTRY_VALUE,ETP
_CS_DATE_ENTRY_VALUE,PROCESSED FROM PAY_AU_TERM_ETP_V WHE

 

EXPECTED BEHAVIOR
   Expecting to wait only a few seconds at most


STEPS TO REPRODUCE
ISSUE1    1. AU Human Resources > Person > Fastpath > Termination Payments
                 2. Query person
                 3. [Find]
                     Wait for about 30 seconds for the data to appear

ISSUE 2   The issue can be reproduced at will with the following steps:

1. N: PEOPLE - FASTPATH - TERMINATION PAYMENT
2. Enter employee details and click on 'Find' to retrieve
3. Click on ENTRIES button
4. Add 'ETP On Termination' element, save and close the Entries form

 

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