PERACADR.fmx did not Generate Successfully After Applying The Patch 23532353

(Doc ID 2188394.1)

Last updated on OCTOBER 18, 2016

Applies to:

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


On : 12.2 HRMS RUP8 version, Patch Application Issues

When attempting to compile the form PERACADR.fmb, the following error occurs.

Compiling package body ADDRESS_DML...
Compilation error on package body ADDRESS_DML:
PL/SQL ERROR 0 at line 24, column 5
Statement ignored
PL/SQL ERROR 0 at line 281, column 9
Statement ignored

Compilation error on procedure PERFORM_ADDRESS_VALIDATION:
PL/SQL ERROR 302 at line 786, column 37
component 'POPULATE_SCHOOL_DSTS' must be declared
PL/SQL ERROR 0 at line 786, column 13
Statement ignored

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

1. Apply the <patch 23532353>.
2. Check the logs.


 Applied <patch 23532353>.


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