Receivables - EBS (MOSC)

MOSC Banner

Error : The PRIMARY_SALESREP_ID column in the HZ_CUST_ACCOUNTS table must be null

edited Dec 18, 2013 3:46PM in Receivables - EBS (MOSC) 2 commentsAnswered

We upgraded from 11.5.10.2 to 12.1.3 a few months ago and have seen the error "The PRIMARY_SALESREP_ID column in the HZ_CUST_ACCOUNTS table must be null" when amending some customers.
I have seen notes 1556005.1 and 733760.1 which say the primary_salesrep_id has moved from HZ_CUST_ACCOUNTS to HZ_CUST_SITE_USES_ALL.

I have checked these tables and primary_salesrep_id is populated on HZ_CUST_ACCOUNTS but is null on HZ_CUST_SITE_USES_ALL

I am confused by 2 things

1) Why do we not get the error when updating any customer (some update OK, some do not - I have not established a pattern yet)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Receivables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center