My Oracle Support Banner

Compilation Errors for Package Body PO_REQUISITION_CANCEL_PUB Invalid (Doc ID 2896625.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle iProcurement - Version 12.2.11 and later
Oracle Purchasing - Version 12.2.7 to 12.2.11 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.11 version, Other issues

While trying to compile invalid package body 'PO_REQUISITION_CANCEL_PUB', package body altered with the following compilation errors :

 ERROR
-----------------------

SQL> alter package apps.PO_REQUISITION_CANCEL_PUB compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.PO_REQUISITION_CANCEL_PUB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
29/27 PLS-00103: Encountered the symbol "." when expecting one of the
  following:
  constant exception
   table columns long
  double ref char time timestamp interval date binary national
  character nchar
  The symbol "" was substituted for "." to
  continue.
40/4 PLS-00103: Encountered the symbol "IF" when expecting one of the
  following:
LINE/COL ERROR
-------- -----------------------------------------------------------------
  begin function pragma procedure subtype type
  
current cursor delete
  exists prior
  The symbol "begin" was substituted for "IF" to continue.

STEPS TO REPRODUCE
--------------------------
The issue can be reproduced at will with the following steps:
1. Login to SQL Developer or Toad
2. Run SQL> alter package apps.PO_REQUISITION_CANCEL_PUB compile body;
3. The command failed with error
4. Package body altered with the compilation errors.

Cause

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
Symptoms
Cause
Solution
References


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