Error when creating a Quote: ORA-20000: APP-11029: Location: "######" Has Multiple Parents

(Doc ID 743570.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Quoting - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 24-MAY-2011***


Symptoms

Creating a quote in HTML Quoting an error is returned

Error

The following SQL error occurred: ORA-20000: APP-11029: Location: "BELLEVUE" has multiple parents..
API_MISSING_ID (COLUMN=ACCT site)
Unable to create a valid account site use for the given party site(party_site_id = 88187)
This site is not a valid site for a given Bill to Customer Account/Customer Account

Steps to Reproduce

  1. Responsibility: Oracle Quoting
  2. Navigation: Quote
  3. Create quote
  4. Error returned when entering the customer details


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