My Oracle Support Banner

ORA-907 in Classic Report after Upgrading APEX Database To 19c and APEX to 19.2 Version (Doc ID 2671992.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 19.2 and later
Information in this document applies to any platform.


APEX 19.2 on DB 19 and EBS 12.2

- Trying to run a page with a classic report  gives
  Error: ORA-00907: missing right parenthesis,- ora_sqlerrm: ORA-00907: missing right parenthesis

- The query has NO syntax errors as it runs fine when cut and paste as is into a new region

- The Query uses a local view that queries across a database link to an EBS object
- The dblink and view have been re-created and reproducing the same issue after recreating them


 Upgrading All to new version on a separated server


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.