Customer Interface

[nithya]

Hi ,
Why do the customer interface error out if there is mismatch in address information?
this was question asked in an interview

[raoofbasheer]

Hi,

Because the code validates against these mismatches.

arplscin.sql and arplbcin.sql
It validates the address being inserted or updated with respect to the tax location flexfield structure. For each row being inserted or updated in RA_CUSTOMERS_INTERFACE, and that has not already been marked in error, the set_location_ccid function is called to return either an existing ccid for the address entered or to create a new entry in AR_LOCATION_VALUES for this new address. The RA_CUSTOMERS_INTERFACE record is then updated with the value of the ccid returned.