12.2.7 Upgrade Patch 24690690 - FAILED: FILE WSMUPGCPYRTG.SQL ON WORKER 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.
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.
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
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