[SOLVED] Re: v5.5 CU2 Issues after de-installing Oracle Spatial


BTW, I created a forum topic on this issue a bit back.  Please feel free to update it with any new information you come across in your testing.

http://www.otmfaq.com/forums/f23/uni...le-spatial-76/ (Uninstalling Oracle Spatial)

Thanks!
--Chris

---------- Original Message ----------
From: Alan Cuartero <consulting (AT) cuartero (DOT) net>
Sent: 1/9/2007 2:00:40 PM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Re: v5.5 CU2 Issues after de-installing Oracle Spatial

Re: v5.5 CU2 Issues after de-installing Oracle SpatialJada,

If you found the problem and then removed spatial you still need to go back and create the correct public synonym for the OTM DISTANCE table to get it working again. Running @create_public_synonyms.sql as GLOGOWNER or just doing a one-off create statement should do the trick.

Good Luck,
Alan


On 1/9/07 1:15 PM, "Barnett , Jada" <JBarnett (AT) geo-logistics (DOT) com> wrote:

Guys - this is great, we have just identified a resulting distance issue and haven't yet tried this.  
 
Thanks so much for your help!
 

Thanks,
Jada






From: owner-otmsig (AT) solutionbeacon (DOT) net [mailtowner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Paul Franz
Sent: Tuesday, January 09, 2007 10:11 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Re: v5.5 CU2 Issues after de-installing Oracle Spatial

Actually the fix was to rename the DISTANCE table to be DISTANCE_LOOKUP.



Paul Franz



On Jan 9, 2007, at 1:04 PM, Alan Cuartero wrote:



Just an FYI, I investigated the Oracle Spatial issue for a client and the only problem I found that caused a conflict with OTM 5.5 was the public synonym called DISTANCE which conflicts with a synonym of the same name used by OTM. So it may not be necessary to de-install all of spatial only to remove the conflicting synonym. I imagine that the fix in CU2 was to rename the synonym in OTM to something else.

-Alan


On 1/9/07 12:55 PM, "Barnett , Jada" <JBarnett (AT) geo-logistics (DOT) com> wrote:



Thanks Chris and Mauricio - We will continue on!! J


Thanks,
Jada








From: owner-otmsig (AT) solutionbeacon (DOT) net [mailtowner-otmsig (AT) solutionbeacon (DOT) net] <mailtowner-otmsig (AT) solutionbeacon (DOT) net%5d> On Behalf Of Mauricio Ramirez
Sent: Tuesday, January 09, 2007 9:56 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: RE: v5.5 CU2 Issues after de-installing Oracle Spatial

Jada,
 
We are nearing the end of our v5.5 implementation and we didn't experience any issues after applying CU2 in OTM.  Of course we've experienced other issues throughout our implementation with regard to the Oracle EBS interface but none as a result of applying CU2 - or at least none that we've run into yet with the functionality that we're using.
 
Regards,

Mauricio Ramirez
Lucidity Consulting Group LP
214-336-9189 Mobile
425-675-8676 Fax
www.luciditycg.com/video <http://www.luciditycg.com/video>
This e-mail and any files transmitted with it are the property of Lucidity Consulting Group LP, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed.  If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at (214) 336-9189 and delete this message immediately from your computer.  Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.   Unless expressly stated in this e-mail, nothing in this message should be construed as a digital or electronic signature.








From: owner-otmsig (AT) solutionbeacon (DOT) net [mailtowner-otmsig (AT) solutionbeacon (DOT) net] <mailtowner-otmsig (AT) solutionbeacon (DOT) net%5d> On Behalf Of Barnett , Jada
Sent: Tuesday, January 09, 2007 11:27 AM
To: 'otmsig (AT) solutionbeacon (DOT) net'
Subject: v5.5 CU2 Issues after de-installing Oracle Spatial

Hi All
We are working on a v5.5 implementation and have worked through the Oracle Spatial issues. &nbspe-installing recommendation on Metalink help worked well for us.  
 
As we look ahead to apply CU2, we were wondering if anyone else has had any issues with CU2 after working through the Oracle Spatial issues.
 
We would like to be proactive or at a minimum get a "heads up" and avoid any additional delays to our implementation.
 
Regards,
 
 
Jada Barnett
Agility Logisitcs
Program Manager, Transport Planning
Tel.      +1.714.513.3000
Mobile +1.858.699.4996
jbarnett (AT) agilitylogistics (DOT) com