"Validation failed for the field - Ship To Contact" Error while Importing Sales Order In oracle APPS

SELECT 'VALID'
  FROM hz_cust_account_roles acct_role
             ,hz_role_responsibility rol
 WHERE acct_role.cust_account_role_id = :ship_to_contact_id
   AND acct_role.status = 'A'
   AND acct_role.role_type = 'CONTACT'
   AND acct_role.cust_account_role_id = rol.cust_account_role_id(+)
   AND NVL (rol.responsibility_type, 'SHIP_TO') = 'SHIP_TO';


Pass :ship_to_contact_id value as OE_HEADERS_IFACE_ALL.ship_to_contact_id.

Also verify if the ship_to_contact_id from OE_LINES_IFACE_ALL is not null Pass :ship_to_contact_id value as OE_LINES_IFACE_ALL.ship_to_contact_id and verify.