My Oracle Support Banner

AD Patch Worker log Shows 'Error Calling FNDLOAD Function' When Applying Patch 25250989 (Doc ID 2252555.1)

Last updated on MAY 02, 2023

Applies to:

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

Symptoms


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: /<file_path>/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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.