Onpremise – Country Code Format in Third-Party Billing Popup

Problem:
 ShipConsole currently does not accept full country names in the third-party billing popup. The system requires a 2-character country code. When using UPS shipping methods, the country code appears as “United States,” but UPS only accepts the 2-character code “US,” causing shipment delays. Manual overrides are currently required.

Solution:

1. Check Logic in Procedure:
    Review the logic for pulling the country name (using the country_symbol column) from the procedure get_third_party_details in the aasc_custom_functions_pkg.
2. Customize Country Code:
    If the complete country name is being retrieved, customize the code to pull the correct 2-character country code. This can be done by mapping country names to their respective ISO2 codes using the lookup available in Oracle.
3. Outcome:
    This change will ensure only the 2-character country code is pulled into ShipConsole, avoiding the need for manual overrides and eliminating delays in shipments.