My Oracle Support Banner

12.2.7 Upgrade Patch 24690690 - FAILED: FILE WSMUPGCPYRTG.SQL ON WORKER 1 (Doc ID 2345335.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Shop Floor Management - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, Patch Application Issues

When attempting to upgrade to 12.2.7 by applying the upgrade patch 24690690, the following error occurs.

ATTENTION: All workers either have failed or are waiting:
  FAILED: file wsmUpgCpyRtg.sql on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Fri Dec 22 2017 05:27:48

sqlplus -s APPS/***** @/trndshr/tsoadev4/appl/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/trndshr/tsoadev4/appl/fs1/EBSapps/appl/wsm/12.0.0/patch/115/sql/wsmUpgCpyRtg.sql &batchsize'

PL/SQL procedure successfully completed.

ERROR at line 1:
ORA-20008: ERROR at line 0: Could not successfully upgrade OSFM Behavior to
create Job Level BOM and Routing Copies.
ORA-06512: at line 618

The issue can be reproduced at will with the following steps:
1. Apply The patch 24690690
2. observe error in the log


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.