My Oracle Support Banner

R12: AP: New "1099 Electronic Media XML Publisher" Concurrent Program is Failing with Errors ORA-06550 and PLS-00201. (Doc ID 2835903.1)

Last updated on APRIL 11, 2022

Applies to:

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

Symptoms

New "1099 Electronic Media XML Publisher" - APXT7CMT2 concurrent program is failing with many errors "ORA-06550: line 2, column 1: PLS-00201:"

After applying <patch 33372456> and the new concurrent program "1099 Electronic Media XML Publisher" is added to AP responsibility, the new program it is failing with below errors, shown in the log file:

...
ORA-06550: line 2, column 1:
PLS-00201: identifier 'AP_APXT7CMT2_XMLP_PKG.P_DEBUG_SWITCH' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier 'AP_APXT7CMT2_XMLP_PKG.P_MIN_PRECISION' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier 'AP_APXT7CMT2_XMLP_PKG.P_FLEXDATA' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier 'AP_APXT7CMT2_XMLP_PKG.P_SET_OF_BOOKS_ID' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
...

Package AP_APXT7CMT2_XMLP_PKG does not exist in the database schema APPS

The following SELECT executed in the APPS schema, returns No rows:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. <Patch 33372456> applied successfully.
  2. Log into Applications using a Payables responsibility.
  3. Open the Standard Request Submission (SRS) form
    (N) Other > Requests > Run
  4. Submit new concurrent "1099 Electronic Media XML Publisher"
  5. Request Completes with Error.

Changes

Applied <Patch 33372456> - 1099 ELECTRONIC MEDIA REPORT CONVERSION TO BIP

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.