GP UK - Error While Employees Are Accessing Their On Line Payslip GBR (Doc ID 2112935.1)

Last updated on MAY 04, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When exporting Non rule package to copy pay slip template, there are these lines in records DMS Script:

DELETE FROM PS_GPGB_PSLIP_ATXD where GPGB_PSLIP_ID='OSL';

IMPORT PS_GPGB_PSPAT_NRVW as PS_GPGB_PSLIP_ATXD;

Which is causing problem as the View PS_GPGB_PSPAT_NRVW has below SQL:

Select gpgb_pslip_id
, effdt
, gpgb_ele_order
, gpgb_pslip_descr
, entry_type_elem2
, gpgb_pslip_detail + 50000000
, entry_type_elem
, gpgb_pin_code_cur
, gpgb_pin_num_cur + 50000000
, gpgb_pin_code_ytd
, gpgb_pin_num_ytd + 50000000
 from ps_gpgb_pslip_atxd;

This Script adds 50000000 in GPGB_PSLIP_DETAIL field when exporting Non rule package and after 2 migration attempts, the value GPGB_PSLIP_DETAIL will be more than 100 000 000 , which then will trigger the error "Numeric value out of range" as the field GPGB_PSLIP_DETAIL in table PS_GPGB_PSLIP_ATXD only supports 8 numbers.

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