This discussion is archived
2 Replies Latest reply: Nov 15, 2012 2:03 AM by Sombit RSS

Page errors when using #OWNER#

Sombit Newbie
Currently Being Moderated
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
  • 1. Re: Page errors when using #OWNER#
    Patrick Wolf Employee ACE
    Currently Being Moderated
    Hi Sombit,

    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.

    Regards
    Patrick
    -----------
    My Blog: http://www.inside-oracle-apex.com
    APEX Plug-Ins: http://apex.oracle.com/plugins
    Twitter: http://www.twitter.com/patrickwolf
  • 2. Re: Page errors when using #OWNER#
    Sombit Newbie
    Currently Being Moderated
    Hi Patrick,

    The issue has been resolved now, It was due to some other table not being the PROD environment.
    And the Parsing Schema : <was the correct one>

    Thanks,
    Sombit

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points