My Oracle Support Banner

R12:AP:When Applying the Script ap_trxupg_M.sql Getting the Error (Doc ID 2725883.1)

Last updated on MARCH 29, 2021

Applies to:

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

Symptoms

When applying the script ap_trxupg_M.sql getting the below error 

@ap_trxupg_M.sql

Enter value for invoice_id: 13183840
old   3:        l_invoice_id number := &invoice_id;
new   3:        l_invoice_id number := 13183840;
Enter value for undo_gl_date: 15/11/2020
old   4:        l_undo_gl_date date := to_date('&undo_gl_date', 'dd/mm/yyyy');
new   4:        l_undo_gl_date date := to_date('15/11/2020', 'dd/mm/yyyy');
Enter value for user_name: OHISGIASTISD
old   5:        l_user_name varchar(100) := '&user_name';
new   5:        l_user_name varchar(100) := 'OHISGIASTISD';
Enter value for resp_name: GHA YDH AP Super User Config
old   6:        l_resp_name varchar(100) := '&resp_name';
new   6:        l_resp_name varchar(100) := 'GHA YDH AP Super User Config';
       AP_INVOICES_DATAFIX_PKG.init_df(l_user_name, l_resp_name);
       *
ERROR at line 11:
ORA-06550: line 11, column 2:
PLS-00201: identifier 'AP_INVOICES_DATAFIX_PKG.INIT_DF' must be declared
ORA-06550: line 11, column 2:
PL/SQL: Statement ignored
ORA-06550: line 12, column 23:
PLS-00201: identifier 'AP_INVOICES_DATAFIX_PKG.IS_TRX_MODIFIED' must be
declared
ORA-06550: line 12, column 2:
PL/SQL: Statement ignored
ORA-06550: line 15, column 3:
PLS-00201: identifier 'AP_INVOICES_DATAFIX_PKG.CREATE_UNDO_DRIVERS' must be
declared
ORA-06550: line 15, column 3:
PL/SQL: Statement ignored
ORA-06550: line 16, column 3:
PLS-00201: identifier 'AP_INVOICES_DATAFIX_PKG.REUPGRADE_M' must be declared
ORA-06550: line 16, column 3:
PL/SQL: Statement ignored
ORA-06550: line 18, column 3:
PLS-00201: identifier 'AP_INVOICES_DATAFIX_PKG.REUPGRADE' must be declared
ORA-06550: line 18, column 3:
PL/SQL: Statement ignored
ORA-06550: line 21, column 2:
PLS-00201: identifier 'AP_INVOICES_DATAFIX_PKG.FINISH_DF' must be declared
ORA-06550: line 21, column 2:
PL/SQL: Statement ignored

Changes

 

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.