R11 R12 PAXTRTRX: PRC: Transaction Import Fails With A PL/SQL Error ORA-20002 PLS-00103 (Doc ID 373726.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Project Costing - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
REPORT:PAXTRTRX.RDF - PRC: Transaction Import

Symptoms

On a new installation the transaction import process is failing when trying to import transactions for a particular transaction source:

MSG-20002: ORA-20002: pre_import:ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "01" when expecting one of the following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
The symbol "case" was substituted for "01" to continue.
ORA-

or

ORA-20004: post_import:ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "01" when expecting one of the following:

( begin case declare exit for goto if loop mod null pragma
raise

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