My Oracle Support Banner

GP STP 2: Cessation Type/Reason Is Blank When Termination Effective Date Is Period End Date + 1 (Doc ID 2848931.1)

Last updated on APRIL 12, 2022

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

STP is creating a blank cessation type when employee has TER action on the day after the period end and Validation report displaying message 'Cessation date and cessation reason code both must be provided'.

The issue can be reproduced at will with the following steps:
1. Add a termination row to KA0005 with effdt 01/02/2022(1st Feb) and Reason 'Health Reasons'. This will create a Termination date 31/01/2022(31st Jan).
2. Now run the STP Preparation(GPAU_STP_PRC).
3. Then check the resulting data in GPAU_STP_HR_STG. Execute below SQL.
SELECT A.CAL_RUN_ID, A.EMPLID, A.BALANCE_GRP_NUM, A.PAY_ENTITY, A.GP_PAYGROUP, A.GPAU_TAX_YEAR, TO_CHAR(A.TERMINATION_DT,'YYYY-MM-DD'), A.GPAU_CESSATION_TYP
  FROM PS_GPAU_STP_HR_STG A
  WHERE ( A.GPAU_TAX_YEAR = 2022
  AND A.EMPLID = 'KA0005'
  AND A.CAL_RUN_ID = 'KA 2022M01')
4. Term Date is populated but Cessation Type is NOT populated even though reason HEA should map to ‘I’

NOTE: In the <images or examples> <above or below> and/or the attached document, user details / customer name / address / email / telephone number represent a fictitious sample (based up made up data used in the Product name test environment). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

Changes

 

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
Changes
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.