Hi,
I have form item item base on LOV as below
After upgrade
Page show the error
ORA-20001: LOV: return LOV.get_delivery_hours_lov(to_number(:P69_TOTALTOPAID)); not found in the APEX data dictionary
ORA-06512: at "FOEX_040200.FX_P_UTILS", line 5786 ORA-06512: at "FOEX_040200.FX_P_UTILS", line 5879 ORA-06512: at "FOEX_040200.FX_P_PLUGIN_INIT", line 368 ORA-06512: at "FOEX_040200.FX_P_PLUGIN_INIT", line 832 ORA-06512: at "FOEX_040200.FX_P_FORM_DML", line 3660 ORA-06512: at "FOEX_040200.FX_P_FORM_DML", line 6378 ORA-06512: at "FOEX_040200.FX_P_FORM_DML", line 6769 ORA-06512: at "FOEX_040200.FX_P_FORM", line 6736
OK
My LOV.get_delivery_hours_lov in the LOV package
function get_delivery_hours_lov(p_total number) RETURN varchar2 as
begin
return '
select name,code from (
SELECT
Level AS code,
Level ||'' giờ'' name
FROM Dual
CONNECT BY Level <= 9
)
where code >=1
';
end;
This page work before upgrade
Please help me on this
