AD Patch Worker log Shows 'Error Calling FNDLOAD Function' When Applying Patch 25250989

(Doc ID 2252555.1)

Last updated on APRIL 14, 2017

Applies to:

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

Symptoms

On : 12.1 HRMS Rup7, Affordable Care Act

AD Patch Worker errors when attempting to apply 2016 ACA Phase 2 Patch 25250989:R12.BEN.B

ERROR:

The Worker Log shows:

Returned from FNDLOAD function.

Log file: /u01/oracle/JDRFDEV2/apps/apps_st/appl/admin/JDRFDEV2/log/US_benzzcncprg00186_ldt.log
Error calling FNDLOAD function.


From the above log - the log file called out - 'US_benzzcncprg00186_ldt.log' shows:

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


STEPS:

The issue can be reproduced at will with the following steps:
1. Attempt to apply patch 25250989:R12.BEN.B using AD Patch
2. If Workers error-out, View Error Logs for Failed Workers

Changes

 

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