12.2 - The ademusr.sql Script Fails Applying E-Business Suite Patch 18491990 With Message 'AD Worker error: AD Worker does not support the command BEGIN; Error occurred in file PATH/ademusr.sql
Last updated on JANUARY 25, 2016
Applies to:Oracle Applications DBA - Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.
E-Business Suite 12.2.4, Upgrade related issues
Installation of <Patch 18491990> errors running SQL and EXEC commands in parallel. The patch logs contain the following error messages:
1. File Name = u18491990.log
ATTENTION: All workers either have failed or are waiting:
FAILED: file ademusr.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Fri Jan 22 2016 04:34:17
2. File Name = adwork001.log
**** Reseting package states in the current session ****
sql /pmic2i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ademusr.sql &systempwd &un_fnd &pw_fnd &un_apps &pw_apps
Set the Module name & Client id successfully for file 'ademusr.sql'
Start time for statement below is: Fri Jan 22 2016 04:34:16
Connecting to SYSTEM......Connected successfully.
AD Worker error:
AD Worker does not support the command BEGIN
Error occurred in file
with arguments '&systempwd &un_fnd &pw_fnd &un_apps &pw_apps'.
Time when worker failed: Fri Jan 22 2016 04:34:17
The issue can be reproduced at will with the following steps:
1. Apply <Patch 18491990
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