I'm not sure that you can use @BEGININVOICED_DATE and @ENDINVOINCED_DATE in the SQL that is passed to oracle, the variables are declared within SQL Server so I'm not sure...
I had similar problems and had to use the OPENQUERY syntax to get ORACLE to make the datetime suitable for SQL Server, you can then use this result as a...