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

Last updated on NOVEMBER 26, 2021

Applies to:

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.