R12.1.3 -WMS_WCS_AQ_QUEUE_TBL Invalid Table (Doc ID 2289237.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

WMS_WCS_AQ_QUEUE_TBL invalid table

In the EBS database inside the WMS schema the following objects are invalid:

 ERROR
-----------------------
WMS AQ$WMS_WCS_AQ_QUEUE_TBL VIEW
WMS AQ$_WMS_WCS_AQ_QUEUE_TBL_E QUEUE
WMS AQ$_WMS_WCS_AQ_QUEUE_TBL_F VIEW
WMS WMS_WCS_AQ_QUEUE_TBL TABLE


STEPS
-----------------------
The issue was produced after applying  several patches and at the poing og the man merged RPC4 Patch

Changes

 For your references the list of patches applied were:

19501437.B
19634084.B
20017916.B
20561454.B
20863127.C
21041554.C
21236633.1
21285343.B
21314548.B
21538802.B
21621642.B
21778308.B
21778911.B
21947967.B
21947974.B
21947976.B
21958458.B
21980909.B
22012760.B
22053665.C
22076410.B
22076842.B
22237199.B
22290338.B
22305299.B
22324389.B
22350639.B
22384200.B
22453253.B
22455213.B
22458196.B
22465286.B
22468218.B
22471504.B
22471980.B
22485014.B
22487766.B
22490144.B
22499954.B
22499955.B
22504715.B
22519300.B
22526147.B
22551138.B
22577929.B
22598196.B
22614470.1
22642602.B
22687240.B
22732532.B
22765947.B
22777954.B
22804804.B
22804817.B
22804824.B
22807471.B
22842942.B
22854862.B
22899060.B
22972840.B
22984342.B
23012640.B
23022590.B
23049700.B
23049702.B
23049708.B
23059709.C
23115501.B
23125359.B
23133647.B
23153621.B
23537731.B
23187791.C
23216851.B
23217255.B
23256716.B
23272198.B
23287619.B
23322366.B
23327260.B
23335092.B
23343867.B
23478416.B
22598102
22779803
22465404
22465779
22465463
22465475
22465418
22465468
24432372
23634170
19554072
20879049
20677714
23475836
21316087
20617800

 

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