Error Importing The APP Lacls_mnt_application In APEX (Doc ID 2950347.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

On : NA version, Installation and Maintenance

When attempting to run the LACLS MNT application for the first time,
the following error occurs.

ERROR
-----------------------
apex_error_code: APEX.CONDITION.UNHANDLED_ERROR

component.type: APEX_APPLICATION_PAGE_REGIONS
  component.id: 8427502095672315
  component.name:  
  error_backtrace:

  ORA-06512: at "SYS.DBMS_SYS_SQL", line 1458
  ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 746
  ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1629
  ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 758
  ORA-06512: at "SYS.DBMS_SYS_SQL", line 1458
  ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 746
  ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1995
  ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1522
  ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1671
  ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1438
  ORA-06512: at "APEX_220200.WWV_FLOW_CONDITIONS", line 290

  error_statement:

  select /*+qb_name(apex$103_9999)*/count(*) from sys.dual where exists (select appf.status
  from lacls_mnt_pack_app_file appf
  , lacls_mnt_pack_application paap
  , lacls_mnt_pack pack
  , lacls_cm_lib_environment envr
  where appf.pack_application_id = paap.pack_application_id
  and paap.pack_id = pack.pack_id
  and paap.environment_id = envr.environment_id
  and appf.status = 'M' -- Manual Step
  and paap.status = 'M'
  and :APP_PAGE_ID not in (8,12,14,19,21,33,34,37,59,61,9999)
  )

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.