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!

Understand effect of Parsing Schema

Amin AdatiaJul 23 2020 — edited Jul 24 2020

APEX 20.1 ORDS 20.2 Database 19.3

I have an application for which the Data Tables are owned by EFMSI and so the Parsing Schema is defined as EFMSI

I did an Advisor Check and found the following error reported

Applications > 101 - Vessel Fishery Trip > Pages > 10042 - Manage User Access > Processes > Save
AttributeProcess Source (Identifies the corresponding process text for the process type)
CheckFetch, DML, MR* Processes are Valid
CategoryError
Message
Compilation error - ORA-00942: table or view does not exist Statement: SELECT "ID"  FROM "EFMSI"."APEX_APPL_ACL_USERS"
Value
#OWNER#:APEX_APPL_ACL_USERS:P10042_ID:ID|IUD

How do I resolve this?

Comments
Post Details
Added on Jul 23 2020
5 comments
602 views