Error creating new Address During Order Checkout Error: "ORA-20000: APP-11027: Mandatory segment: "COUNTY" missing in address." (Doc ID 353510.1)

Last updated on JUNE 12, 2016

Applies to:

Oracle iStore - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

Receive error when creating a new address in billing or shipping page during oracle iStore checkout process.  

Error

ORA-20000: APP-11027: Mandatory segment: "COUNTY" missing in address. 
API_MISSING_ID (COLUMN=ACCT SITE).
Unable to create a valid account site use for the given party site (party_site_id = xx)
This site is not a valid site for given Ship to Customer Account/Customer Account.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms