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
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
PeopleSoft instance from DB2 to Oracle
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
Questions by dorsalad
Related Answered Questions
Related Open Questions