Fndload Error When Applying Patch 25250000 (HRMS US EOY Phase 2) (Doc ID 2220904.1)

Last updated on JUNE 20, 2017

Applies to:

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

Symptoms

On 12.1.3 RUP9, Teacher Pension Interface

When applying patch 25250000 (HRMS US EOY Phase 2) error shows.


ERROR
-----------------------
Error calling FNDLOAD function

adwork004.log refered to "loc_gb_pqpenext_ldt.log", which has this error:
Uploading from staging tables
  Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 4 - Teachers Appointments ( England and Wales ), RECORD_NAME = PQP GB TP Type 4 - Teachers Appointments ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-20001: HR_7165_OBJECT_LOCKED: N, TABLE_NAME, ben_ext_data_elmt
  Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 2 - Teachers Additional Contributions ( England and Wales ), RECORD_NAME = PQP GB TP Type 2 Detail - Teachers Additional Contributions ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-20001: HR_7165_OBJECT_LOCKED: N, TABLE_NAME, ben_ext_data_elmt



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 25250000
2. Error shows in adworker


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot install the patch 25250000 to upgrade the application and therefore the system is not usable.

Changes

 

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