My Oracle Support Banner

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 (Doc ID 2099429.1)

Last updated on FEBRUARY 24, 2024

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 <EBS_BASE>/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


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

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