Unable to compile oos_util_apex package body

[IsaacAguirre]

This might be a product of installing oos-utils in a local 12c database(Oracle version 12.1.0.2.0), however the oos_util_apex package body doesn't compile it returns the error: PL/SQL: ORA-00904: "AWS"."SESSION_LIFE_TIMEOUT_ON": invalid identifier at line 102.

Checking the description of the view for the installation, that column doesn't exist. desc apex_workspace_sessions Name Null Type

---

WORKSPACE_ID NOT NULL NUMBER
WORKSPACE_NAME NOT NULL VARCHAR2(255)
WORKSPACE_DISPLAY_NAME VARCHAR2(4000) APEX_SESSION_ID NOT NULL NUMBER
USER_NAME VARCHAR2(255)
SESSION_CREATED DATE
SESSION_TIME_ZONE VARCHAR2(255)
SESSION_LANG VARCHAR2(5)
SESSION_TERRITORY VARCHAR2(255)

Also found that the line 104 and 105 are the same

[martindsouza]

@IsaacAguirre what version of APEX do you have?

[IsaacAguirre]

@martindsouza 4.2.5.00.08. below the result from running select * from apex_release

[martindsouza]

Will need to support older versions (4.2.x) of APEX in next release