My Oracle Support Banner

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 AUGUST 10, 2018

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.