EDI850 PO Import - Validations across Customers and Pricing

Summary:

We are introducing EDI850 Purchase Order Import and require some validations to be run across Customer Sites and Pricing/Discounting.

Content (please ensure you mask any confidential information):

The overall architecture includes CPQ and Oracle Cloud ERP. We are importing EDI850 Purchase Orders using CMK and B2B messaging services. In this process, the requirement is to do a customer site validations which includes

• A fuzzy search as the N1 segment on the 850 has a Free form Text for all qualifiers (BT, ST, EN, DU). If the customer site name sent on the EDI files have an additional space on the address and/or names. How do we tackle these validations? Is there a way to create new customers directly if the fuzzy search doesn't give the desired results?