System Admin Error: "Conversion Failed When Converting The Varchar Value 'AA' To Data Type Int" (Doc ID 2081328.1)

Last updated on NOVEMBER 30, 2015

Applies to:

Oracle Insurance General Agent - Version 8.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.2.0 version, Core System

System Admin Error: "Conversion failed when converting the varchar value 'AA' to data type int"

In System Administration, the following error displays when selecting "Codes": "Grid Loading (1003,3eb): Conversion failed when converting the varchar value 'AA' to data type int"
Selecting any code in the code management hierarchy on the left causes the error to display. Selecting 'OK' allows the user to continue. Selecting any of the top tier code categories, "Agreement Codes", "Case Codes", "Case Tracking", "Entity Codes", "Miscellaneous Tables", causes the error to display but also the grid showing the Code IDs is not populated. Selecting any of the codes lower in the hierarchy also displays the error but the gridbox is populated.

Due to this issue, users cannot get the Code IDs for the code categories Agreement Codes, Case Codes, Case Tracking, Entity Codes, Miscellaneous Tables

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