ap_corr_awt_inv_fix.sql AP_REV_AWT_INV_CREATE_BKP ORA-00942 Table or View does not exist (Doc ID 1963498.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Encumbrance

When attempting to launch the GDF 14067373 ap_corr_awt_inv_fix.sql script from Note: 1500291.1,
the following error occurs.

ERROR
-----------------------
Enter Payables responsibility name (CASE SENSITIVE)
________________________________________________________
Enter value for gl_date: 27-FEB-2014
Enter value for user_name: SYSADMIN
Enter value for responsibility_name: Payables Pharma - IT
for i in (select distinct invoice_id from AP_REV_AWT_INV_CREATE_BKP )
  *
ERROR at line 280:
ORA-06550: line 280, column 43:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 280, column 11:
PL/SQL: SQL Statement ignored
ORA-06550: line 286, column 27:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 285, column 14:
PL/SQL: Statement ignored
ORA-06550: line 296, column 86:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 296, column 3:
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply ap_corr_awt_inv_fix.sql script from one step of the GDF 14067373

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot correct the datas with the GDF script.

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