R12 – java.sql.SQLException: Invalid column type in OAF
Issue:
When we are using view object (VO) in OA Framework it’s possible that you will run in to the problem java.sql.SQLException: Invalid column type, especially if it’s an LOV VO. When you click on the LOV torch for the first time it is working fine. But whenever when we click on the GO button in the LOV Region it gives an error.
Solution:
What we need to is, change the Binding Style from Oracle Named to Oracle Positional in the View Object declaration. The framework is adding a where clause to the query using bind variables that are typed :n, this is why you need to set Oracle Positional. Now save it run again, then it will solve this issue.
Thank you so much, this was exactly the issue I was facing!
It is not working in apps dev instance. it is working fine in jdeveloper. can you suggest on voimpl.class file or xml
Thank you!
Thanks you so much this option worked for me.