Order import failing with error "ORA-01422: exact fetch returns more than requested number of rows i

Hi All,

We are getting 'Exact fetch returns more than requested number of rows' during Order import, on further debugging the code for the above package, we have noticed that there is more than 1 record in ra_salesreps view for 'No sales credit' sales rep for each OU. We have about 5 OU's in the instance, and each OU has 'No sales rep', thus having 5 records in ra_salesreps.

Any ideas how this can be resolved?

Thank you.