BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Business Objects and Oracle Financials Upgrade


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 15, 1998 7:49 am 
Post subject: Business Objects and Oracle Financials Upgrade



Good morning,

We have a new test environment because we're moving form Oracle Financials 10.5 to 10.7. Some of the table names changed from one version to another so in my 10.7 environment I had to create new synonyms, and in designed I renamed and refreshed the structure of my tables. All of the queries are working fine but when I run an integrity check on the tables I still get the message for all of the new table names '"Tablename" is not in the database structure'.

I used to get this message when we were missing a synonym but I know that is not the case, we just renamed the tables. I don't want to reinsert the table because then I'll have to recreate all of my objects. Has anyone else encountered this?

Thanks,

Julie


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Mon Sep 21, 1998 5:35 am 
Post subject: Business Objects and Oracle Financials Upgrade

<Sailesh.Thakker@GEPEX.GE.COM>


Julie,

No need to create new synonyms,as Orafin 10.7 already has Views with original names for backward compatibility under user FND or FNDAPPS (not very sure).
So the only change required would be to remap the owner of the tables from AP/AR/GL etc. to FND i.e. Change your universe connection to FND. There is a different team at our site that did Orafin upgradation, and this is what I gather from them. If you have any specific question, e-mail me directly.
Regards
Sailesh Thakker
IMO, GE Plastics, Singapore.





Date: Tue, 15 Sep 1998 07:49:00 -0500

Good morning,

We have a new test environment because we're moving form Oracle Financials 10.5 to 10.7. Some of the table names changed from one version to another so in my 10.7 environment I had to create new synonyms, and in designed I renamed and refreshed the structure of my tables. All of the queries are working fine but when I run an integrity check on the tables I still get the message for all of the new table names '"Tablename" is not in the database structure'.

I used to get this message when we were missing a synonym but I know that is not the case, we just renamed the tables. I don't want to reinsert the table because then I'll have to recreate all of my objects. Has anyone else encountered this?

Thanks,

Julie
Best Regards
Sailesh Thakker
IMO, GE Plastics, Singapore.
Tel 326 3939, DC *533 3939.


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0269 seconds using 17 queries. (SQL 0.0031 Parse 0.0008 Other 0.0230)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo