Below is the script to populate the employee addresses into Oracle HRMS base tables using API's. DECLARE x_address_id NUMBER; x_object_version_number NUMBER; x_error_code VARCHAR2 (10); x_error_desc VARCHAR2 (2000); BEGIN hr_person_address_api.create_person_address (p_validate => FALSE ,p_effective_date => SYSDATE ,p_person_id => 13676 ,p_primary_flag => 'Y' -- Set Y for Primary address and N for Others. ,p_date_from => SYSDATE ,p_address_line1 => 'House Number : 0000' ,p_address_line2 => 'Sector : 00' ,p_town_or_city => 'Delhi' ,p_postal_code => '110001' ,p_style => 'IN' --API Parameters will vary depending upon the style you choose. ,p_address_id => x_address_id ,p_object_version_number => x_object_version_number ); EXCEPTION WHEN OTHERS THEN x_error_code := SQLCODE; x_error_desc := SQLERRM; END; / COMMIT ;