Today, we had trouble with a SQL Server installation of PeopleSoft asking for a tablspace. We created a new record, and when we saved it, it asked for a tablespace name. The problem was that we had no tablespaces setup in PeopleSoft. Therefore, we couldn’t pick a tablespace and essentially couldn’t save a new record.
What was more frustrating was the fact the SQL Server does not have tablespaces. On a SQL Server system the tablespace settings are completely ignored. It should not show the tablespace dialog.
The solution was to turn off platform compatibility mode. The compatibility mode allows you to create records that could be migrated to a database such as Oracle. With this option turned on, it will ask you for the tablespace so that it will have it when it gets on the Oracle database. You can turn it on or off in the PeopleTools Options page (PeopleTools > Utilities > Administration > PeopleTools Options).