Why My query is not availing the offloading feature

Some of the area we need to check before we go to oracle to check if there is any known bug ?

1. Verify STORAGE clause is included in your query plan.

2. Verify if your function is offloloadabe using v$sqlfn_metadata

SQL> desc v$sqlfn_metadata
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FUNC_ID                                            NUMBER
 NAME                                               VARCHAR2(30)
 MINARGS                                            NUMBER
 MAXARGS                                            NUMBER
 DATATYPE                                           VARCHAR2(8)
 VERSION                                            VARCHAR2(12)
 ANALYTIC                                           VARCHAR2(3)
 AGGREGATE                                          VARCHAR2(3)
 OFFLOADABLE                                        VARCHAR2(3)
 DISP_TYPE                                          VARCHAR2(13)
 USAGE                                              VARCHAR2(30)
 DESCR                                              VARCHAR2(4000)

3. Verify if the below  init.ora parameters are matching
            cell_offload_processing = TRUE
            _kcfis_storageidx_disabled =FALSE  ( Storage index is enabled)
             _kcfis_cell_passthru_enabled = TRUE ( perform smart IO filtering on the cell )



4. Verify if 'cell.smart_scan_capable'='TRUE' is enabled for all the disk