Navigate from Oracle BI 11g to Oracle eBS R12. While setting this up, I had some challenges to overcome. One of them was the following. When I clicked the column with the Action Link, the following error showed up;
The Oracle eBS Server was available, so that couldn’t be the problem. Checking the logfile(s) showed that there was a ORA-01722 error involved.
The question at this point is; Which query is throwing a ‘Invalid Number’-error. To Sql Trace the Connection Pool which is being used for the Action Link.
Via the generated Trace Files I was able to identify the problem – query. It turned out to be the query which constructs the Url to navigate to Oracle eBS.
1 | select fnd_run_function.get_run_function_url |
3 | ( fnd_function.get_function_id ( 'AP_APXINWKB_SUMMARY_VIEW' ) as number ) |
4 | , cast ( '200.00' as number ) |
5 | , cast ( '*****' as number ) |
6 | , cast ( '0.00' as number ) |
8 | , null ) as action_link |
A quick check in SQL*Plus gave the same error. The problem is in the Cast functions and the NLS_NUMERIC_CHARACTERS-settings.
An easy;
1 | ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,' ; |
….. solved the problem in SQL*Plus.
In Oracle BI, I added the ‘Alter Session’-Statement in the Connection Pool which is being used for the Action Link.
Problem Solved.
