My Oracle Support Banner

E-DB2: Change Package Failing At Creating Tables Step With "SQL0204N "SLMAPPIDX" is an undefined name. SQLSTATE=42704" (Doc ID 2602224.1)

Last updated on OCTOBER 23, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.48 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version

Change Package is failing at creating table step with below error :

CREATE TABLE PS_INSTALLATION_SC (SCD_ALLOW_DECLINES CHAR(1) NOT NULL, SCD_SUPPLIER_SETID CHAR(5) NOT NULL, SCD_TRCBK_DYS_TRND SMALLINT NOT NULL, SCD_TRCBK_DYS_RANK SMALLINT NOT NULL, SCD_VNDR_SEL_TRND CHAR(2) NOT NULL, SCD_VNDR_SEL_RANK CHAR(2) NOT NULL, SCD_VNDSEL_TM_FRM SMALLINT NOT NULL) IN SLMAPP INDEX IN SLMAPPIDX NOT LOGGED INITIALLY

ERROR
-----------------------
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "SLMAPPIDX" is an undefined name. SQLSTATE=42704


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.