Do not place Semicolon at the end of the SQL View statement

In this doodle, we will talk about one of the most common error PeopleSoft developers used to experience while building the PeopleSoft views through application designer.

When you place semicolon (;) at the end of the SQL view statment in the SQL Editor you will see an error message when you build the view through application designer.Do not place Semicolon[;] at the end of the SQL statement. It will be treated as an invalid character.

Correct:

Select EMPLID,NAMES from PS_NAMES

In-correct:

Select EMPLID,NAMES from PS_NAMES;