Submit/place Order from Quote Error: "1. Error returned in ASO_CHECK_TCA_PVT.CUST_ACCOUNT_RELATIONSHIP, 2. ORA-00972: identifier is too long ORA-01422: exact fetch returns more than requested number of rows" (Doc ID 1212205.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Quoting - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

 When trying to place a quote as order, the following error message occurs :

Error

1. Error returned in ASO_CHECK_TCA_PVT.CUST_ACCOUNT_RELATIONSHIP,
2. ORA-00972: identifier is too long
ORA-06512: at "APPS.ASO_UTILITY_PVT", Line 62
ORA-06512: at "APPS.ASO_PARTY_INT", line 2610 ORA-01422: exact fetch returns more than requested number of rows,
3. There is an error in order submission

 

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