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]
> 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]
> 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. De-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
>
>

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] 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] 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. De-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
>>
>>
>