My Oracle Support Banner

R12: AP: GDF 22339917 SEL Script ap_remtchdist_cnclinv_sel.sql Fails With Errors ORA-06550 And PLS-00103 (Doc ID 2693931.1)

Last updated on AUGUST 13, 2020

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Your current version of file $AP_TOP/patch/115/sql/ap_remtchdist_cnclinv_sel.sql is as follow or below, based on your current Release

Executing GDF 22339917 SEL Script ap_remtchdist_cnclinv_sel.sql Fails With Errors ORA-06550 And PLS-00103

Complete error generated is:

SQL> start ap_remtchdist_cnclinv_sel.sql
Following are the parameters that would be asked for
by the script, along with their meanings:

P_Email_Id (Optional) [STRING] :
==================================================
If user wants to receive the generated
logs on their email id.

Enter value for p_email_id:
                 '  to 'Y' in the driver table ap_remtch_hdr_cancel_invs for invoices <br>'||
                        *
ERROR at line 266:
ORA-06550: line 266, column 25:
PLS-00103: Encountered the symbol "Y" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || member submultiset
The symbol "* was inserted before "Y" to continue.
ORA-06550: line 268, column 58:
PLS-00103: Encountered the symbol " in the driver table." when expecting one of
the following:
* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || member submultiset
The symbol "*" was substituted for " in the driver table." to continue.



Commit complete.

Review the above messages and press <Enter> to acknowlege.

 

Changes

Applied GDF <Patch 22339917>

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
Changes
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.