My Oracle Support Banner

SPWA - Supplies And Demands - ORA-00942: Table Or View Does Not Exist (Doc ID 2794251.1)

Last updated on AUGUST 25, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Constrained planning

SPWA - Supplies and Demands - ORA-00942: table or view does not exist

We've just installed SPWA. Items, Supply Chain Bill, Vertical Plan, Supplies and Demands are working. But when doing a query in Supplies and Demands after clicking on Search, issue 'ORA-00942: table or view does not exist' appears.
System finds organization, item, Order Type and so on in search field but no result.
Of course it works in Workbench (Java screen).

ERROR
-----------------------

ORA-00942: table or view does not exist


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to "Supplies and Demands" page in Supply Plan Work Area
2. Search for the above item

Following error thrown:
ORA-00942: table or view does not exist



Changes

 

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.