General Information and Troubleshooting Tips for NoetixViews Trial Edition for Subledger Accounting

This information applies to the free, 30-day trial edition of NoetixViews for Oracle E-Business Suite Release 12 Subledger Accounting.

GENERAL:

Q: How do I get the trial edition software?

A: Learn more about the software and sign-up for your free, 30-day trial at http://www.noetix.com/Tools/SLATrialEdition.aspx. Be sure to check out the data sheet for details about the complete solution for subledger accounting.

Q: How free is ‘free’?

A: Totally free. You’re under no obligation to buy anything if you install the trial edition software.

Q: What happens at the end of 30 days?

A: The 30 day trial period starts the first time you install the software in your E-Business Suite database. At the end of 30 days the views will stop returning data, though you’re free to keep the demonstration spreadsheets that came with the software.

Q: Where can I learn more about the setup and use of the trial edition software?

A: We’ve setup two on-line playlists of videos for these purposes. For the playlist about installing the software, click here. For the playlist about using the demonstration spreadsheets, click here.

Q: How do I get some help?

A: Start by reviewing the material below to see if your issue has already been addressed. If you still need assistance, send an email to Magnitude Software Support at trialsupport@magnitudesoftware.com. Provide a description of your problem, including any error codes and messages, a screen shot of the error, and your E-Business Suite and Oracle database versions. Also include a phone number where you can be reached.

VIDEO ISSUES:

Q: Why isn’t there any audio with the videos?

A: As of 10/7/2013, all YouTube videos start with their volume turned off. Until this is fixed by YouTube, you can turn on the volume by adjusting the volume slider bar on the bottom of the YouTube window.

SETUP ISSUES:

Q: I’m getting an error message during Setup that I don’t understand. What do I do?

A: There are a number of videos that explain the system requirements, the prerequisites, and the Setup process. If you haven’t already viewed these videos, view them online here. If you still need assistance, you can contact Noetix Support via email, at trialsupport@magnitudesoftware.com. Provide a description of your problem, including any error codes and messages, a screen shot of the error, and your E-Business Suite and Oracle database versions. Also include a phone number where you can be reached.

Q: Why do I get error: “A 32-bit Oracle client is not installed” or error: “Oracle data source could not be found”?

A: The Excel templates that are provided with the Trial Edition use Office Data Connections, which require that the bit-ness of your Oracle client and Excel must match. For example, if you are running a 32-bit version of Excel, you must also have a 32-bit version of the Oracle client. Also, Excel must be installed with VBA enabled.

Q: Why can’t I install the Trial Edition on my EBS 11i environment?

A: The Trial Edition only works with E-Business Suite R12 because subledger accounting (SLA) is only available in R12, and not in earlier versions of Oracle E-Business Suite.

EXCEL QUESTIONS:

Q: Why can I execute queries in Excel when I have not enabled Data Connections?

A: This is a feature of Microsoft Excel. As long as you have successfully logged into the NoetixViews account in the spreadsheet, Excel can refresh the data without having the Data Connections enabled.

Q: One of my reports is not working today, but it worked yesterday. All of the other reports still work. How do I fix it?

A: It is possible you modified an area of the prompts page that is causing the prompts to fail? You should not modify any of the fields on the prompt page below row 30.

You can get the original reports back by rerunning the Trial Edition Setup program. This will overwrite all the reports, setting them back to the original version. If you have made changes to reports that you do not want to have overwritten, you should copy the Excel .xlsm files to a location outside the NoetixViews Trial Edition for SLA folder before reinstalling, then copy them back afterwards. Just don’t copy the corrupt file back.

Q: When I open the Excel templates, I get error: [Microsoft][ODBC Driver Manager][/ODBC] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

A: This may happen if you are using an Oracle 10.2 client on a Windows 7 machine. The only 10.2 client that is compatible with Windows 7 is 10.2.0.5. If you do not have this version of the Oracle client, you will either need to upgrade your Oracle client or run the Excel reports on a machine that has a compatible combination of Oracle client and Windows operating system.

Q: I sent the Excel reports to a co-worker, but they cannot execute the reports. When they try to login, they get message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

A: Make sure the co-worker has an Oracle client and Excel installed on their machine, that the Oracle client and Excel are both 32- or 64-bit. The Excel reports cannot be run on a machine with a 64-bit Oracle client and a 32-bit Excel, or vice versa. Note that Excel 2007 is always 32 bit.

Also, the ODBC driver name on your co-workers machine must be the same as the ODBC driver name on your machine. In order to obtain the Oracle ODBC driver name, you need to open Windows’ ODBC Data Source Administrator utility but there are two versions. One is 32-bit and the other is 64-bit; the one you use depends on the bit-ness of your Oracle client. The 32-bit ODBC Data Source Administrator utility is located in C:WindowsSysWOW64 and is called odbcad32.exe. The 64-bit ODBC Data Source Administrator utility is located in C:WindowsSystem32 and is also called odbcad32.exe (notice than both names contain “32”).

After opening the utility, click on the Drivers tab and locate the Oracle ODBC driver name in the Name column. The default naming convention is similar to “Oracle in OraClient_home”, where is the version of the client and represents an incrementing number starting with 1 that increments each time you install another Oracle client on the same computer. If the ODBC driver name does not match the one on the machine where the Trial Edition was installed, you will need to talk to your IT department to change the driver name on the second machine.

Q: Why don’t my Excel reports return any data? They worked yesterday.

A: Check the trial days remaining that is displayed on the Prompts page of the Excel workbook. If the trial days remaining is 0, your trial period has ended. See the “What’s Next?” section.

Q: Can I keep the Excel spreadsheets after the Trial ends?

A: Yes, the spreadsheet are left untouched by the uninstall process. They will work with the SLA views in NoetixViews 6.3 General Availability version with a few modifications. Once you are ready to use them with NoetixViews 6.3, contact Noetix Support to learn what changes need to be made.

WHAT’S NEXT?

Q: These views are great! How do I get a permanent version?

A: If you are already a NoetixViews customer and have the global views for General Ledger, upgrade to NoetixViews 6.3, available in November 2013. If you don’t have the global views or you’re not yet a NoetixViews customer, contact Magnitude Software.

Q: I am finished with the Trial. How do I remove it?

A: You will find an uninstall program in the Start Menu of the machine where you installed the views. If you no longer have access to that machine, click here for instructions on manual uninstallation.