Hi,

My Users keep getting the following error message when they use the 9ias portal.

The page which they are opening consist of a combo box and this is the error they get.

After refreshing the page, they are able to view the combo box.

May I know whether any one of you encounter with this error?


COMBOBOX LOV ERROR:
LOV: "SI_DB_PROVIDER.LOV_STOCKS"
Parse Message: Parse as pre-set global: "PORTAL_PUBLIC".
Find Message: LOV is of type DYNAMIC (LOV based on SQL query).
Query: "SELECT DISTINCT RTRIM(STOCK_NAME)||','||STOCK_ID, STOCK_ID FROM SGX_STOCKS WHERE STOCK_NAME IS NOT NULL AND MARKET_ID = 'R'"
wwv_parse.parse_as_user: ORA-12516: TNS:listener could not find available handler with matching protocol stack wwv_parse.parse_as_user: Failed to parse as PORTAL_PUBLIC - SELECT DISTINCT RTRIM(STOCK_NAME)||','||STOCK_ID, STOCK_ID FROM SGX_STOCKS WHERE STOCK_NAME IS NOT NULL AND MARKET_ID = 'R' wwv_security.check_comp_privilege: Insufficient privileges. wwpre_utl.get_path_id: The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.40023_FORM_STOCKS_FUNDA_193047549

Oracle LazyDBA home page