E-AD: Application Designer Crashes at Build Project/Build Script/Create Table

(Doc ID 817654.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 and later
Information in this document applies to any platform.
***Checked for relevance on 23-10-2012***

Symptoms

When attempting to build tables from Application Designer, an error similar to the following occurs:

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

Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT DATABASE_OPTIONS FROM PSSTATUS

STEPS
-----------------------
By following these steps the issue can be reproduced:
1. Application Designer
2. Build
3. Create Tables

The problem may be intermittent depending on load of system.

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