SQL below works fine io staging environment.
FROM "#OWNER#"."APXTER_TERR_HDR" terr
WHERE terr.status = 'FINALIZED'
AND terr.latest_version_flag = 'Y'
After migration, on Prod env, Page errors out with the same sql.
ERROR: Table or View doesnot exits.
Is there any checks/setups/profile options to be made in the PROD for the query to be executed.
have you verified that the "Parsing Schema" (Edit Application Properties) of your application actually contains or sees the table APXTER_TERR_HDR? If you go to SQL Workshop you should be able to verify that.
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins