We are faced with an issue where we send an ASN to customer. ASN is based on Lot number of product. When we have a large lot size, we end up sending duplicate ASNs because we draw from the same lot. Has anyone else experienced this issue and come up with a solution to address. We've discussed adding a table to add suffix number but I was hoping there was standard oracle functionality.