Total Pageviews

July 18, 2018

7/18/2018 12:16:00 PM
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



 
Related Posts Plugin for WordPress, Blogger...