After raising a tar with oracle, it is confirmed that it is an oracle bug. If we use bind variable in a query which is using Full outer join then it gives the error of From keyword not found where expected. The workaround that I use to solve the problem is instead of using full outer join on the inline views I first left joined the internal view union right join on the same internal views and the expected output was available.