How LOV is configured for Country Names more than 30 Characters
We have a business scenario where certain country names are greater than 30 characters and our siebel configuration stores these values in the COUNTRY LOV as Display Value. We are storing the Display Value in COUNTRY Coulumn in table S_ADDR_PER.
The Problem is that Display Value/LIC of an LOV have a character limit of maximum 30 hence certain country names are getting truncated when stored in Database.
How is everyone storing their Country Names that are longer than 30 characters?
Oracle suggested us to use an Abbrev for the Country name but Business does not want that.