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.
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:
, gpgb_pslip_detail + 50000000
, gpgb_pin_num_cur + 50000000
, gpgb_pin_num_ytd + 50000000
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms