Thanks Fred. I tried this, but I'm still getting the error. (Even though it's not captured on the SQL logs for some reason)
*/SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and owner = 'DCC' */OK */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and owner = 'DCC' */OK Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 27, 2009 12:12 PM To: [email protected] Subject: Re: View Forms and Synoyms.... Try adding in the owner of your synonym. Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch 007 on Solaris w/Oracle 10i (Remote DB) Attempting to create a View Form on "USER_VIEWS" <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'ARADMIN' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0325 */OK <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0327 */ SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 'ARADMIN' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0574 */OK <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0575 */ Error - can't find table USER_VIEWS (owner = ARADMIN). Attempting to create a View Form on "SYS.USER_VIEWS" <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7696 */OK <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7699 */ SELECT column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7771 */OK Fred ________________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, May 27, 2009 10:14 AM To: [email protected] Subject: Re: View Forms and Synoyms.... Yes it does work from the SQL Client. Sorry, I should have specified that..... Lisa ________________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Wednesday, May 27, 2009 11:01 AM To: [email protected] Subject: Re: View Forms and Synoyms.... I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe ________________________________________ From: "Kemes, Lisa" <[email protected]> To: [email protected] Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms.... Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting "Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481." We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [email protected] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

