PeopleSoft instance from DB2 to Oracle

You have moved a PeopleSoft instance from DB2 to Oracle and when trying to build tables and indices, you notice that the SQLs generated by the Application designer are wrong / unacceptable, What could be the possible issue ?
which is the best option
a) Issues with PSDDLMODEL
b) Definitely not any one of the above
c) Issues with Application Designer
d) Issues with PSOPTION
e) Issues with PSDDLTEMPLATE

dorsalad
Profile Answers by dorsalad Questions by dorsalad
Dec 17th, 2013
2
6769

Questions by dorsalad

Peoplesoft

Answer

Showing Answers 1 - 2 of 2 Answers

Reena

Jan 18th, 2017

a) Issues with PSDDLMODEL
This table holds the Oracle DDL templates (i.e how the syntax of table , index etc should be in a particular DB )
There is a delivered DMS script (psddl.dms) that can be run to reset the structure of the objects