12.2.7 Upgrade Patch 24690690 - FAILED: FILE WSMUPGCPYRTG.SQL ON WORKER 1

(Doc ID 2345335.1)

Last updated on JANUARY 04, 2018

Applies to:

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

Symptoms

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

PL/SQL procedure successfully completed.

DECLARE
*
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

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