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

Last updated on NOVEMBER 24, 2015

Applies to:

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

Symptoms

 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

Connected.`*
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.

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