Import DMS Fails When Applying Bug ID # 24691280 (downloaded From HCM Image20) (Doc ID 2247402.1)

Last updated on MARCH 30, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When applying delivered leave of absence transaction definitions, for bug fix 24691280, customer getting DMS error as below:

ERROR
-----------------------
- SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0104N An unexpected token "." was found following ".". Expected tokens may include: "". SQLSTATE=42601
 (SQLSTATE 42601) -104

CREATE TABLE .PS_EOPCMIG_DEFN (EOPCMIG_DEFN_ID CHAR(10) NOT NULL, EOPCDEFN_ID CHAR(20) NOT NULL, EOPCSOURCE_CD CHAR(4) NOT NULL, EOPCAPPOBJ_TYPE CHAR(2) NOT NULL, EOPCAPP_OBJ CHAR(30) NOT NULL, EOPCDEFN_NAME CHAR(30) NOT NULL, EOPCDEFN_DESCR CHAR(254) NOT NULL, OWNERID CHAR(8) NOT NULL, EOPCDTTM_ADDED TIMESTAMP, EOPCOPRID_ADDED CHAR(30) NOT NULL, EOPCLASTUPDDTTM TIMESTAMP, EOPCLASTOPRID CHAR(30) NOT NULL) IN PSHRDMOO.EOECAPP
Error: Unable to process create statement for EOPCMIG_DEFN



The issue can be reproduced at will with the following steps:
1. Execute Import script upd24691280_02_imp.DMS


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