E1: ODA: ODA Driver Not working properly in E1 9.1 prior to 188.8.131.52
Last updated on MAY 30, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
-Previous Version (8.0), Server IBM AS400, JDE 8.0, Microsoft Excel 2007
-Running JDE Version, 9.1.3, Tools Server IBM AS400 iSeries, Microsoft Excel 2007
Issue occurred after upgrading from ERP8 to 9.1|9.1.3. This issue with the ODA does not occur on ERP8. Users uses Microsoft Excel 2007 to extract data via ODA connection (JDE OneWorld ODA driver).
At one time, Microsoft Excel can be used with 2 sheets, each connected to specific connection and can work on a sheet. After working on it, the connection properties was changed and the changes were applied. As usual, the system requires login to JDE fat client login window, enter the USERID and password, and it works well here. But when switched to another sheet and change the connection properties, system prompts password error, "JDE could not sign you on", after keying the same password. For the third time entering the password, it allows to sign in however, the excel will get restarted and tried to recover the file.
Following steps are taken:-
1. Make sure there is a setup in ODBC, using JDE ODA.
If there is a security warning like this, enable it on button Enable Content.
3. Now, in the Sheet1, go to menu Data > Properties
4. Click on the Connection properties > Tab Definition
5. Try to change a little bit ‘where condition’ inside Command Text. Change on F0101.ABAT1 = ‘V’ into F0101.ABAT1 = ‘E’.
6. You may change anything on this command text.
7. Click Ok.
8. JDE sign on pop up will appear.
9. Click OK.
10. Then Data on the excel will be refreshed according to the syntax. Until this step, system still work well.
11. Now, the sheet2 has different connection and different syntax from sheet1. Now go to Sheet2. Go to data > Properties. And Click on Connection Properties.
12. In the pop-up connection properties > tab Definition, find the command text.
13. Changed the following like this:-
14. Click OK.
15. Sign on to the Pop up that appears.
16. Enter the user and proper password.
17. In this case, first symtom appeared. If the correct password is entered, then system denied it with error message, “JD Edwards EnterpriseOne could not sign you on. Make sure User ID is correct and retype your password”.
18. Next, put the wrong password and click Ok. Let the error message appears again and click OK again.
19. For the third attempt to log in into JDE, put the right password again into sign on popup.
20. The system does not prompt the error message again and lets you get into the excel spreadsheet. But from here onwards, the excel stopped working.
21. Excel attempting to recover the work.
22. Then the Book1.xlsx will recover with unsaved condition. And the connection properties remain unchanged.
23. In JDE version 8.0, step no 19 onwards did not prompt any error or failure of MS excel working.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms