Also to add to Drew's comments, from my little battles fought and won with AIE, sometimes it might be necessary to prefix the table or view with the database user/role name that you are connecting to.. For e.g. I am working with a PeopleSoft view that is called PS_Z_HR_SMTOOLS_VW that can be queried directly through the Oracle client using that name after being logged into SQLPlus, but using the same credentials, the AIE sees the table as SYSADM.PS_Z_HR_SMTOOLS_VW.
It cannot for some reason find PS_Z_HR_SMTOOLS_VW by that name itself from the AIE console.. I hope this helps.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Drew Shuller Sent: Thursday, April 17, 2008 10:49 AM To: arslist@ARSLIST.ORG Subject: Re: AIE configuration That portion of AIE doesn't appear to be re-written in the new version so it's still a little tricky. Make sure you've put the correct database connection info in the Rule Helper Utility. Save it, and then press the Load Table & View Names button and that database's tables should appear in the Available Tables and Views table. I say "should appear" because it doesn't always work they way you expect. You may have to press that button a few times before AIE knows what it's doing. You're obviously reading the source db tables here so if your db or network is running slow, this table won't update instantly. You can also press the Refresh Table List button but this gives you mixed results also. Keep messing with it and cross your fingers...the appropriate tables will eventually show up and the choices you make from there show up as the source tables when setting up a mapping. Drew No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.0/1383 - Release Date: 4/17/2008 9:00 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
