APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS_CRYPTO Error When Linking to Interactive Reports with Query Criteria

khennSep 27 2019

We were previously running APEX 5.0.3 on Oracle 11.2.0.4. We recently stood up a new 12c database, and then moved our data from the old 11g DB to the new 12c DB. After doing this there were certain pages in my application which would not load, and would give the error listed below. We then installed APEX 19 on 12c to see if this would solve the issue, but I still get the same error. I had a tabbed navigation area which used a list to display 6 links on my page. After some trial and error, I discovered that two of the links were attempting to navigate to another page and set the default criteria for an Interactive Report. Once I removed the IR criteria from the links, the page that had the sub tab links loaded properly. Maybe my links are not correct, and I have provided them below. I tried multiple different simple filters today, but I can't get anything to work. Am I doing something wrong or do I have another problem?

f?p=&APP_ID.:8:&SESSION.::&DEBUG.:25,CIR:IRC_ROWFILTER,IR[EMAIL]EQ_TO_USER_EMAIL:&P2_EMAIL_LOG_EMAIL.,&P2_EMAIL_LOG_EMAIL.

f?p=&APP_ID.:14:&SESSION.::&DEBUG.:14,CIR:IRC_ROWFILTER,IR[EVENT]C_MESSAGE:&P2_ACCESS_LOG_CN.,&P2_ACCESS_LOG_CN.

Below is the error message when trying to access any page which contained the tabbed navigation list.

is_internal_error: true

apex_error_code: APEX.REGION.UNHANDLED_ERROR

ora_sqlcode: -28817

ora_sqlerrm: ORA-28817: PL/SQL function returned an error.

ORA-06512: at "APEX_190100.WWV_FLOW_DISP_PAGE_PLUGS", line 999

ORA-06512: at "APEX_190100.WWV_FLOW_DISP_PAGE_PLUGS", line 1941

ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 131

ORA-06512: at "SYS.DBMS_CRYPTO", line 72

ORA-06512: at "APEX_190100.WWV_FLOW_CRYPTO", line 326

ORA-06512: at "APEX_190100.WWV_FLOW_SECURITY", line 1827

ORA-06512: at "APEX_190100.WWV_FLOW_UTILITIES", line 9077

ORA-06512: at "APEX_190100.WWV_FLOW_REGION_LIST", line 433

ORA-06512: at "APEX_190100.WWV_FLOW_REGION_LIST", line 728

ORA-06512: at "APEX_190100.WWV_FLOW_REGION_LIST", line 784

ORA-06512: at "APEX_190100.WWV_FLOW_REGION_LIST", line 1269

ORA-06512: at "APEX_190100.WWV_FLOW_REGION_LIST", line 1294

ORA-06512: at "APEX_190100.WWV_FLOW_REGION_NATIVE", line 2426

ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2096

ORA-06512: at "APEX_190100.WWV_FLOW_DISP_PAGE_PLUGS", line 1408

ORA-06512: at "APEX_190100.WWV_FLOW_DISP_PAGE_PLUGS", line 1892

ORA-06512: at "APEX_190100.WWV_FLOW_DISP_PAGE_PLUGS", line 984

component.type: APEX_APPLICATION_PAGE_REGIONS

component.id: 1268175589264502

component.name: User Details Sub Tabs

error_backtrace: ORA-06512: at "APEX_190100.WWV_FLOW_DISP_PAGE_PLUGS", line 999