My Oracle Support Banner

PLS-00103: Encountered the symbol "`" When Loading perachrgchk.sql (Doc ID 2082008.1)

Last updated on DECEMBER 11, 2023

Applies to:

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


 Problem Statement:

When applying the patch that contains perachrgchk.sql 120.0.12010000.37 (e.g. Patch:22052686), following error occurs.

sqlplus -s APPS/***** @/XXXX/apps/apps_st/appl/per/12.0.0/patch/115/sql/perachrgchk.sql

ERROR at line 235:
ORA-06550: line 235, column 1:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge
The symbol "`" was ignored.



Steps to Reproduce:

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

  1.  Apply patch that contains perachrgchk.sql 120.0.12010000.37 (e.g. Patch:22052686)
  2.  Worker job fails loading perachrgchk.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.