Tuesday, October 24, 2017

"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.

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...