Custom Event, ORA-01722 Invalid Number

Hi,

I’m working with a customer on NCR’s and they want to prevent NCR’s from moving into Released status unless the NCR is connected to an object.

I can up with this event action:

And it works when an NCR isn’t connected to a Project. For example, the test NCR 120822-3 throws the error that I'm looking for when I try to release it:

However, after connecting the NCR to a project:

I get this error message:

And I’m not really sure why. When I run my select statement in Oracle I can see that it’s evaluating to 1:

So, right now I’m at a bit of a loss and I’m hoping someone can help me figure out how to get this over the finish line.