howdy
I hope you have been doing well. I have missed working with you but it looks we will get to work together again! I am preparing for the conversion of your customers into Oracle and I need your guidance on how y'all maintain address in ICS. The major difference in Oracle is we have specific fields for City and Province/State. I can take the address in ICS and break them up the proper fields in Oracle as long as I have standard rules I an follow for how the data is maintained on your customers. I have taken a look at a sample of your customers and see that it is not always consistent. Based on what I have seen with the sample it looks like addresses are entered in this fashion in your ICS system.