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.

Symptoms



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.

ERROR
-----------------------
Web Exception Error

Table or View Name = F17311 - Data Source[0] = 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

Cause

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