Jaircvrtvdff.sql Adworker Failed While Upgrade From 12.1.1 To 12.1.3 (Doc ID 1948992.1)

Last updated on JUNE 15, 2016

Applies to:

Oracle Financials for India - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Install and Patching Issues
Script when upgrading
 
jaircvrtvdff.sql adworker failed while upgrade from 12.1.1 to 12.1.3
ERROR
-----------------------
jaircvrtvdff.sql adworker failed while upgrade from 12.1.1 to 12.1.3

sqlplus -s APPS/***** @/a02/DEV/apps/apps_st/appl/ja/12.0.0/patch/115/sql/jaircvrtvdff.sql &un_po &batchsize 4 8
Connected.
  AND trx_information IS NULL;
  *
ERROR at line 36:
ORA-06550: line 36, column 12:
PL/SQL: ORA-00904: "TRX_INFORMATION": invalid identifier
ORA-06550: line 18, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 103, column 29:
PLS-00364: loop index variable 'REC' use is invalid
ORA-06550: line 103, column 8:
PL/SQL: Statement ignored
ORA-06550: line 149, column 84:
PL/SQL: ORA-00904: "VAT_INV_GEN_NUMBER": invalid identifier
ORA-06550: line 109, column 8:
PL/SQL: SQL Statement ignored
ORA-06550: line 157, column 11:
PLS-00364: loop index variable 'REC' use is invalid
ORA-06550: line 157, column 8:
PL/SQL: Statement ignored
ORA-06550: line 285, column 34:
PLS-00364: loop index variable 'REC' use is invalid
ORA-06550: line 285, column 34:
PL/SQL: ORA-00904: "REC"."SHIPMENT_LINE_ID": invalid identifier
ORA-06550: line 276, column 8:
PL/SQL: SQL Statement ignored
STEPS
-----------------------
Migration issue
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot with R12.1.3 Migration activity

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