My Oracle Support Banner

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

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
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.