R12: Payables Data Select/Fix Scripts Fail with "component 'SEND_MAIL_CLOB_IMPL' must be declared" (Doc ID 1938998.1)

Last updated on DECEMBER 02, 2014

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

When executing an R12 Payables script, whether sanctioned through a Generic Data Fix (GDF) patch or by Oracle Development, such that the e-mail address is entered as an input parameter, the following error might occur:

Error message
l_email_flag := AP_Acctg_Data_Fix_PKG.send_mail_clob_impl(l_email_id,l_file_location);
                                          *
ERROR at line 347:
ORA-06550: line 347, column 44:
PLS-00302: component 'SEND_MAIL_CLOB_IMPL' must be declared
ORA-06550: line 347, column 6:
PL/SQL: Statement ignored

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