My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.