Error Returned In ASO_CHECK_TCA_PVT.CUST_ACCT_RELATIONSHIP (Doc ID 1635596.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Order Capture - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Teleservice - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
ORA-01422: exact fetch returns more than requested number of rows

Goal

After applying patch 11826764 to fix "ASO_invalid_ACCT_RELTN" error,  additional errors are seen;


ERROR
-----------------------
You cannot update column created_by_module.

Error returned in ASO_CHECK_TCA_PVT.CUST_ACCT_RELATIONSHIP

ORA-00972: identifier is too long
ORA-06512: at APPS.ASO_UTILITYP_PVT, line 107
ORA-06512: at APPS.ASO_PARTY_INT, line 2580
ORA-06510: PL/SQL: unhandled user-defined exception


Please advise if another patch is needed to fix this condition
 

Solution

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