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 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.

Symptoms

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:

 

ERROR
-----------------------
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
CONNECT SYSTEM/*****
Connecting to SYSTEM......Connected successfully.
AD Worker error:
AD Worker does not support the command BEGIN
Error occurred in file
/pmic2i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ademusr.sql
with arguments '&systempwd &un_fnd &pw_fnd &un_apps &pw_apps'.
Time when worker failed: Fri Jan 22 2016 04:34:17

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <Patch 18491990

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