OAB Patch 24733720 Failes with "PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW'" (Doc ID 2216216.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply patch 24733720:R12.BEN.B: ACA Phase 1 YEAR 2016, the following error occurs on the log:

ERROR
-----------------------
Current system time is Sun Dec 18 08:40:11 2016

Uploading from the data file /u02/oracle/DEV/apps/apps_st/appl/ben/12.0.0/patch/115/import/US/benzzcncprg00186.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u02/oracle/DEV/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15), /u02/oracle/DEV/apps/apps_st/appl/ben/12.0.0/patch/115/import/US/benzzcncprg00186.ldt) to staging tables
Dumping LCT file /u02/oracle/DEV/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u02/oracle/DEV/apps/apps_st/appl/ben/12.0.0/patch/115/import/US/benzzcncprg00186.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE BENACA1095C BEN , PROGRAM BEN1095C BEN ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error parsing the generated plsql wrapper statement ORA-06550: line 782, column 9:
PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW'
ORA-06550: line 782, column 9:
PL/SQL: Statement ignored

Concurrent request completed
Current system time is Sun Dec 18 08:40:11 2016

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to apply the patch in a non-Production environment.
Application shows failed workers with error PLS-00306 wrong number or types of arguments.

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