E-INST: Install error: File: Data MoverSQL error. Stmt #: 0 Error Position: 594 Return: 904 - ORA-00904: "SYNCDTTM": invalid identifier (Doc ID 2238166.1)

Last updated on FEBRUARY 27, 2017

Applies to:

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

Symptoms

On : 8.55 version, Install and Packaging

When attempting to build the DEMO 9.2 FSCM database with Image 19 on Tools 8.55.13,
the following error occurs:

ERROR
-----------------------
`File: Data MoverSQL error. Stmt #: 0 Error Position: 594 Return: 904 - ORA-00904: "SYNCDTTM": invalid identifier
Failed SQL stmt: INSERT INTO PS_COUNTRY_TBL
(COUNTRY, DESCR, DESCRSHORT, COUNTRY_2CHAR, EU_MEMBER_STATE, ADDR1_LBL,
ADDR1_AVAIL, ADDR2_LBL, ADDR2_AVAIL, ADDR3_LBL, ADDR3_AVAIL, ADDR4_LBL,
ADDR4_AVAIL, CITY_LBL, CITY_AVAIL, NUM1_LBL, NUM1_AVAIL, NUM2_LBL, NUM2_AVAIL,
HOUSE_TYPE_LBL, HOUSE_TYPE_AVAIL, ADDR_FIELD1_LBL, ADDR_FIELD1_AVAIL,
ADDR_FIELD2_LBL, ADDR_FIELD2_AVAIL, ADDR_FIELD3_LBL, ADDR_FIELD3_AVAIL,
COUNTY_LBL, COUNTY_AVAIL, STATE_LBL, STATE_AVAIL, POSTAL_LBL, POSTAL_AVAIL,
N_CITY_LIM_AVAIL, IN_CITY_LIM_LBL, GEO_CODE_AVAIL, GEO_CODE_LBL, POST_SRCH_AVAIL,
GBSYS_NRPATH_UK, GBSYS_CFGPATH_UK, SYNCID, SYNCDTTM)
VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, TO_TIMESTAMP(:42,'YYYY-MM-DD-HH24.MI


File: Data MoverSQL error. Stmt #: 0 Error Position: 725 Return: 904 - ORA-00904: "SYNCDTTM": invalid identifier
Failed SQL stmt: INSERT INTO PS_INSTALLATION (COUNTRY, EXCHNG_TO_CURRENCY, EXCHNG_TO_RT_TYPE, INSTALLATION_CD, AM, AP, AR, AUC, BI, CA, CAT, CCM, CFG, CP, DEAL, DP, EB, EG, ES, EX, FO, FO_PBM, FP, GL,
GM, GVC, HR, INV, IP, ITAM, ITK, MG, MPA, OM, PC, PGM, PM, PO, PV, QS, RE, RISK, RS, FPA, FAA, ADBA, FCA, SCMT, SP, SPL, TD, TR, TPM, WO, WR, CCU,
PPALM, PPESA, PPFIN, PPSCM, DMI, PRD, ADDRESS_VENDOR, TAX_VENDOR, JETFORMS, DC_INSTALLED, MULTIBOOK_FLAG, ALTACCT_OPTN, COMMITMENT_CNTL_AP, COMMITMENT_CNTL_AR, COMMITMENT_CNTL_BI, COMMITMENT_CNTL_EX, COMMITMENT_CNTL_GL, COMMITMENT_CNTL_GM, COMMITMENT_CNTL_IN, COMMITMENT_CNTL_PC, COMMITMENT_CNTL_PO, COMMITMENT_PROCARD, COMMITMENT_RECVACC, BUDG_DT_DFLT_OPT, RVSL_DT_OPTN, PROC_PART_GL, SYNCID, SYNCDTTM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, TO_TIMESTAMP(:84,'YYYY-MM-DD-HH24
.MI.SS.FF')).SS.FF'))

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into DataMover in Bootstrap mode
2. Select File, Database Setup
3. Run the Database Setup Wizard

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