2 Replies Latest reply: Nov 15, 2012 4:03 AM by Sombit RSS

    Page errors when using #OWNER#

    Sombit
      Hi All,

      SQL below works fine io staging environment.

      SELECT terr_name
      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.

      Thanks,
      Sombit