Apex 5.0.
Page 301 is an Interactive Report based on a multi-table join stored as a View.
The link attribute calls Page 302, passing 3 ID values to P302 page items.
Page 302 is a single-row form using one of the 3 ID values as the primary key in the source table.
This is done by a generated, Pre-rendering, After Header process, Fetch Row from SSN_LINK.
Display-only values for the form are obtained by a second Pre-rendering, After Header process.
This is a hand-built SQL query that uses the other two ID values as a compound key to a table in
another database using a database link. (The 2nd database is local, but on a separate DB appliance.)
The call to Page 302 works sweetly until we start to use the filter on the Interactive Report.
After filtering the report to a more specific list of people, the first call to Page 302 fails with an Internal Error.
Going Back in the browser (Chrome) and retrying the link works perfectly.
Other links from the same filtered list also work perfectly.
But when the filter is removed, the first attempt to link to Page 302 fails with the same Internal Error.
Then, going Back in the browser and retrying the link works perfectly.
What does toggling the Interactive Report filter do?
Here is the Internal Error technical info, which I do not know how to interpret:
Internal Error
Contact your application administrator.
Technical Info (only visible for developers)- is_internal_error: true
- apex_error_code: APEX.ERROR.INTERNAL
- component.type: APEX_APPLICATION_PAGE_REGIONS
- component.id: 2554504249580925
- error_backtrace:----- PL/SQL Call Stack -----
- object line object
- handle number name
- 0xd3b3b4e0 641 package body APEX_050000.WWV_FLOW_ERROR
- 0xd3b3b4e0 709 package body APEX_050000.WWV_FLOW_ERROR
- 0xd3b3b4e0 1013 package body APEX_050000.WWV_FLOW_ERROR
- 0xd3b3b4e0 1106 package body APEX_050000.WWV_FLOW_ERROR
- 0xc0488c18 1749 package body APEX_050000.WWV_FLOW_PLUGIN
- 0xc0488c18 2622 package body APEX_050000.WWV_FLOW_PLUGIN
- 0xd3a800f0 4535 package body APEX_050000.WWV_FLOW
- 0xc093e170 173 procedure APEX_050000.F
- 0xcc2b4fc0 30 anonymous block