Release
|
Symptom/Presentation
|
Cause
|
Fix
|
11.5.x
|
Attempting to run
Customer Interface and receive the following error:
ORA-01422: exact fetch returns more than requested number of rows racict: Error inserting contacts
Import only BILL_TO
and SHIP_TO the interface ends succesfully
Import more than two BILL_TO and SHIP_TO record, the interface ends with error |
Possible sequence
issue
|
Increase these
sequences manually:
HZ_ACCOUNT_NUM_S HZ_CUSTOMER_PROFILES_S HZ_CUST_SITE_USES_S HZ_ORGANIZATION_PROFILES_S HZ_PARTIES_S HZ_PARTY_NUMBER_S HZ_PARTY_SITES_S HZ_PARTY_SITE_NUMBER_S HZ_PARTY_SITE_USES_S HZ_PERSON_PROFILES_S Note: Can use a LOOP 1..20000 and sequence_name.nextval |
Home
»
Oracle Receivables
»
Oracle apps Functional
»
Oracle apps Technical
» Oracle APPS :Customer Interface errors part-3
July 18, 2018