Getting "ORA-00936: missing expression" when adding a new filter (74395)

To reproduce the problem please follow the steps below:

1. Go to Database | Monitor | Session Browser
2. Click on Filter icon
3. Click on Add button
4. Enter a Filter name
5. Enter the following expression:

select * from v$session s
where
(
program = 'frmweb.exe'
)

6. Click on Test . The format of the Expression changes to

SELECT * FROM V$SESSION s WHERE
(
select * from v$session s
where
(
program = 'test.exe'
)

and therefore the following error is raised: "ORA-00936: missing expression"

RESOLUTION

Please enter only the where expression on the filter.
On the example above only "program = 'test.exe'" should be entered in the expression field.