My Oracle Support Banner

Hrautpsd.sql and Perjobdp.sql Failed with ORA-01403 (Doc ID 2564931.1)

Last updated on DECEMBER 10, 2023

Applies to:

Oracle Human Resources - Version 12.2 and later
Information in this document applies to any platform.


Problem Statement:

During the patching, worker jobs failed loading perjobdp.sql and hrautpsd.sql.

ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "APPS.HR_PUMP_META_MAPPER", line 2195
ORA-06512: at "APPS.HR_PUMP_META_MAPPER", line 3845
ORA-06512: at "APPS.HR_PUMP_META_MAPPER", line 3932
ORA-06512: at line 63



Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Apply patch that contains perjobdp.sql or hrautpsd.sql.
     e.g. 12.2.8
  2.  Worker jobs failed loading perjobdp.sql or hrautpsd.sql.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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