Re: Where does SQL get generated for PeopleSoft Inserts?

[Hartono Sutirman <hsutirman@JATIS.COM>]

hi...

As far as I know, you can assign default values to the fields but it is not
required, since peoplesoft would automatically insert a space to a blank field.

This error usually happen because you haven't Alter or Re-Create the Table
after you added the fields and maybe you want to check the Setting when you
choose to re-create or alter the table.

regards,
Hartono Sutirman


Zubin Shroff wrote:

>      We added a few new fields to the JOB table and on the JOB_DATA_HIRE
>      panels. When adding a new employee, we get a SQL INSERT error since
>      the new fields are not being assigned values. How do I fix this? Where
>      is the SQL generated?
>
>      Thanks for your help...