I have a grid that is a text column. The data has text strings. The underlying Oracle data type in the dictionary is VARCHAR2(100). When I search for a value like "2300", I get the Invalid Number error.
My guess is that since the search value is "0200", FOEX is doing a TO_NUMBER on the underlying column resulting in this error. If I search for "CAP" it works without any error. I have attached screen shots below
There is a lot of data and it is very complex for me to try to create a test case. The view used in the query, is made up of UNION of 6 views. I have looked up the data type in ALL_TAB_COLUMNS to ensure that this column is shown as VARCHAR2. Can you please guide on what could be the issue?
As a work around, I have set "Column Filterable" in FOEX config for that specific column to No. I am able to search for the data via the general grid search box (which I think does a text search).
ORA-01722: invalid number
ORA-06512: at "FOEX_210200.FX_P_GRID", line 3416 ORA-06512: at "APEX_210200.WWV_FLOW_PLUGIN_UTIL", line 1765 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 1280 ORA-06512: at "SYS.DBMS_SQL", line 1726 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 1274 ORA-06512: at "APEX_210200.WWV_FLOW_PLUGIN_UTIL", line 2741 ORA-06512: at "APEX_210200.WWV_FLOW_PLUGIN_UTIL", line 1752 ORA-06512: at "FOEX_210200.FX_P_GRID", line 3286 ORA-06512: at "FOEX_210200.FX_P_GRID", line 8466
