Skip to Main Content

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.

APEX_APPLICATION_TEMP_FILES after upgrading to APEX 20.1 ORA-01403

zagirovJun 30 2020 — edited Jul 6 2020

Hello!

The problem started after switching from Apex 18.2 to Apex 20.1
Using ORDS 19.4.6 on Tomcat9
The last PSE BUNDLE PATCH_VERSION = 2020.06.25 was successfully installed on APEX

select version, status from dba_registry where comp_id = 'APEX'
VERSION STATUS
------------------------------ -----------
20.1.0.00.13 VALID

The same error occurs in many of my applications, I will clearly show on the application "Sample File Upload and Download"
Page 13 "Project" - Upload File and successfully select the file and click "Apply Changes" I get:

Technical Info (only visible for developers) is_internal_error: true
apex_error_code: APEX.UNHANDLED_ERROR
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found ORA-06512: at "APEX_200100.WWV_FLOW", line 1362
component.type: APEX_APPLICATION_PAGES
component.id: 105000000013
component.name: Project
error_backtrace:
ORA-06512: at "APEX_200100.WWV_FLOW", line 1362
ORA-06512: at "APEX_200100.WWV_FLOW", line 3870

Nothing falls into the temporary table.
How I tried to solve the problem:
1. exec wwv_flow_upgrade.recreate_public_synonyms ('APEX_200100'); - did not help
2. alter user flows_files quota unlimited on users; Doc ID 2681340.1 - did not help
3. d0.sql Enabling LEVEL9 does not add details to my error

How can this problem be solved?

скрин1.JPG

This post has been answered by zagirov on Jul 6 2020
Jump to Answer

Comments

Processing

Post Details

Added on Jun 30 2020
6 comments
2,664 views