GB - DEA Payment Schedule Assignments Error With ORA-06512: At "APPS.PAY_ARCHIVE", Line 1207 (Doc ID 2020918.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

In PRODUCTION
12.1 HRMS RUP7

pygbpaep.pkb 120.0.12010000.141
pygbdea.pkb 120.0.12010000.16

Running the GB - DEA Payment Schedule report 3 assignments error with same error, 20 assignments complete successfully.

Get following error :

ERROR
----------------------------------

Error ORA-20001: Errors found while archiving data.ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3 has occurred in table pay_archive.process_employee at location 1108

WHAT IS WORKING
----------------------------------


The assignments have been processed succesfully by the payroll run in the same period.


STEPS TO REPRODUCE
----------------------------------

Navigation :

Launch new concurrent request 'GB - DEA Payment Schedule'

Parameters
Tax Ref: xxxx
Payroll: YYYY
Period: 52 2015 Lunar Month

ARCHIVE, DEA_PAY_REP, GB, , 2015/03/21 00:00:00, EDI, 105, , , , 120/C1291, TAX_REF=xxxx, 61, PAYROLL_ID=61, Plain Paper, REPORT_FORMAT=Plain Paper, 1102, PERIOD_ID=1102


WORKAROUND
----------------------------------
NONE


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