AD Patch Worker log Shows 'Error Calling FNDLOAD Function' When Applying Patch 25250989
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.
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
The Worker Log shows:
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:
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
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
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