Oklbpvip.sql Failed while Applying Patch 10124646.drv in 12.2 Upgrade

(Doc ID 2154261.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, INSTALL

oklbpvip.sql failed while applying patch 10124646.drv in 12.2.0 upgrade

FETCH l_params_csr BULK COLLECT INTO virv_tbl_type;
ERROR at line 75:
ORA-06550: line 75, column 9:
PLS-00394: wrong number of values in the INTO list of a FETCH statement
ORA-06550: line 75, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 79, column 23:
PL/SQL: ORA-00947: not enough values
ORA-06550: line 79, column 11:
PL/SQL: SQL Statement ignored

The issue can be reproduced at will with the following steps:
1. Applying patch 10124646.drv in 12.2.0 upgrade


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