Why can’t I find the Salesrep NAME!

An issue that seems to come up regularly is that the Salesrep name is elusive!  This problem is most often reported in the context of custom reports that use JTF_RS_SALESREPS table to retrieve the salesrep name.

In fact JTF_RS_SALESREPS.NAME is obsolete as from 11i onwards and is retained for backward compatibility only.  This field should not be used to retrieve the name of a salesperson.  All salesreps are resources, so the resource name should be used instead of salesrep name.

For example SQL to retrieve the resource name see: Why is the NAME field in the table JTF_RS_SALESREPS sometimes null? (Doc ID 550284.1) .