Norway - Performance Issue With "Norwegian Recording Sheet For Employer's Contribution" (Doc ID 1962697.1)

Last updated on JANUARY 10, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Norway Payroll

ACTUAL BEHAVIOR


Performance issue - Norwegian Recording Sheet for Employer's Contribution and Withholding Tax (Report Set). Report took 18 hours to run in Production.
The most expensive SQL:
SELECT DISTINCT EEV.SCREEN_ENTRY_VALUE TAX_MUNICIPALITY
FROM
 PAY_ELEMENT_ENTRIES_F PEE ,PAY_ELEMENT_ENTRY_VALUES_F EEV ,
  PAY_INPUT_VALUES_F PIV ,PAY_ELEMENT_TYPES_F PET ,PAY_PAYROLL_ACTIONS PPA
  WHERE PPA.PAYROLL_ACTION_ID = :B2 AND PEE.ELEMENT_ENTRY_ID =
  EEV.ELEMENT_ENTRY_ID AND EEV.INPUT_VALUE_ID + 0 = PIV.INPUT_VALUE_ID AND
  PIV.NAME = 'Tax Municipality' AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
  AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE AND
  PIV.EFFECTIVE_END_DATE AND PEE.ASSIGNMENT_ID = :B1 AND PET.ELEMENT_NAME =
  'Tax Card' AND PET.LEGISLATION_CODE = 'NO' AND PPA.EFFECTIVE_DATE BETWEEN
  PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE AND PPA.EFFECTIVE_DATE
  BETWEEN EEV.EFFECTIVE_START_DATE AND EEV.EFFECTIVE_END_DATE AND
  PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE AND
  PET.EFFECTIVE_END_DATE


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 23960180 1220.02 1203.36 0 0 0 0
Fetch 23960180 23901.40 24339.54 2509 3335982877 0 23955439
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 47920361 25121.43 25542.91 2509 3335982877 0 23955439



EXPECTED BEHAVIOR

The process to finish in a few minutes

STEPS

The issue can be reproduced at will with the following steps:
1. Report Request Set
Norwegian Recording Sheet for Employer's Contribution and Withholding Tax (Report Set)


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