Have received a similar error - created a view utilizing a dblink - six fields - 4 from dblink and 2 from local database. The view and data is accessible thru PL/SQL Developer with no errors. When attempting to access thru a page/component utilizing the view in peoplecode, receive the same error. Error Return: 1858 - ORA-01858: a non-numeric character was found where a numeric was expected ORA-02063: preceding line from ORA_FIN_EBIZ. Our other dblinks see to work successfully, except this one. Has anyone responded at this time?
Branched to a new thread instead of hijacking old one.
Please give more details about your architecture, Peopletools version as well as database version, thanks.
And also give the view definition.