Today, I ran into an error importing a PeopleTools tree into an instance of PeopleSoft. Probably, the problem was that I was using an old version of PeopleTools (8.46).
If this were a production system, the fix would be to upgrade PeopleTools to 8.51. But, this is for testing purposes, and I kind of want to keep the old version so that I can make sure things run with it.
Here is the error message that I received from Data Mover:
SQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PSTREEDEFN"."PT_ALLVALUEAUDOPT")
With all that said, you probably don’t want to follow these directions. (This is a don’t try at home moment.) I don’t even know why I am posting this. Maybe it will help some one with SQL syntax or something. Most likely, I will need it again for a later update into this same instance.