After completing an PeopleSoft installation, I found that I had missed a step as there were no table spaces available to save a new record definition into.
You can check this in application designer using the following steps:
- Open a record definition
- Tools > Data Administration > Set Table Space
- Look at the available space Name-DB Name. If you have no options (blank) then no table spaces are defined.
Another way to check this is through:
No tablespaces! Behind the scenes, the table that needs to be populated is
The step that I had missed as part of the installation was to run the SQR,
sqrw.exe (found under
PS_HOME\bin\sqr\<DB>\binw\). Specify the appropriate parameters and run.