E1: 13: Table F17311 Has Incorrect Field Names For Latitude And Longitude Causing Web Exception Error
(Doc ID 2251606.1)
Last updated on APRIL 04, 2017
Applies to:JD Edwards EnterpriseOne Capital Asset Management - Version 9.2 and later
Information in this document applies to any platform.
When attempting to change Equipment Master - Work with Equipment Locations address book LATITUDE AND LONGITUDE fields in the P1704 Equipment Master - Work with Equipment Locations
the following error occurs. JAS error. When looking at the jas log. Its saying LDNLONG is invalid. Checked the table there is a field called LDLONG but not LDNLONG.
Web Exception Error
Table or View Name = F17311 - Data Source = Business Data - TEST java.sql.SQLSyntaxErrorException: ORA-00904: "LDNLONG": invalid identifier
29 Mar 2017 13:26:44,805 [SEVERE] JBUHAJLA - [BASE] com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: ORA-00904: "LDNLONG": invalid identifier
STEP To Duplicate:
The issue can be reproduced at will with the following steps:
1. Go to Equipment Master Inquire on an Asset in P1701 or P1702
2. Form Exit To Address Book / Inquiry P1704 Equipment Master - Work with Equipment Locations /
Row Exit to Details P17041 Equipment Master Location Details
3. Make Change or update Fields Latitude (LATT) and Longitude (LONG) i.e. -104 / 36
4. Click OK to Save. Notice Web Exception, Run and check Jas Log for error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document