Hey Folks…
Trying to implement an RDT for Lawson Inventory. When I run a query it tells me tables not found. I’m assuming that the product is not looking for the correct owner of the table. My question is two part… If the classes have been renamed to a more english like meaning, how do I determine the actual Oracle table name? Second… How do I change the “owner” id to reflect the correct “owner”? Thanks…
Michael Dempsey
Manager, Data Base Administration
University of North Carolina Hospitals
We installed RDTs for some of Oracle’s financial applications and encountered similar problems. I’m not familiar with the Lawson application, but I suspect the scenario is similar.
Which Oracle user name are you using to connect to the database ? From R10.7 on, many of the object names that were formerly owned by the application (GL,AR,AP, etc.) now belong to user APPS. The Oracle applications themselves have no problem since public synonyms exist for these objects. Unfortunately, BusObj doesn’t recognize public synonyms.
Assuming that the user that has been defined in your BusObj connection has SELECT priveleges to all the tables and/or views that comprise the universe, you could create private synonyms. Or if you are lucky, you could check the ERD that the RDT universe creates & see who owns the tables. If they all have the same owner, change your BusObj connection to sign on as that user.
To rename tables; go into the Designer module, right click on the required table
that you wish to rename, and select the “Rename Table” option. This pops up a window
that should provide what you need. We run Lawson (Not thru RDT’s due to later version
than RDT’s) & ran into the same issue.
To determine the class that a table belongs to, go into the Designer module, open the Universe, Right click on the table, and select “View Associated Objects”.
This will highlight, in the structure window, all objects that were derived from that
table
Hey Folks…
Trying to implement an RDT for Lawson Inventory. When I run a query it tells me tables not found. I’m assuming that the product is not looking for the correct owner of the table. My question is two part… If the classes have been renamed to a more english like meaning, how do I determine the actual Oracle table name? Second… How do I change the “owner” id to reflect the correct “owner”? Thanks…
Michael Dempsey
Manager, Data Base Administration
University of North Carolina Hospitals
[Charles Killam] Go to the .prm file and reset OWNER= to N. The software assumes that the connection account is the owner of the tables. Resetting this parameter removes this assumption.
Charles A. Killam IV , Senior Consultant Business Objects Americas
Chicago Office (847)391-9880
Michigan Office (248)-366-7606
Fax (248)-366-7607 ckillam@busobj.com
Hey Folks…
Trying to implement an RDT for Lawson Inventory. When I run a query it tells me tables not found. I’m assuming that the product is not looking for the correct owner of the table. My question is two part… If the classes have been renamed to a more english like meaning, how do I determine the actual Oracle table name? Second… How do I change the “owner” id to reflect the correct “owner”? Thanks…
Owner and table name can be changed in the designer, right-mouse click on the table, “rename”…
To include the owner in the tablename you could use (create) an external (STRUCT-) strategy. Look into the designer manual for this…
The oracle table-name of an object can be seen in the generated SQL (query-panel).
Walter
Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria Tel. +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at