Transactions Workbench: List Of Values For Sales Rep Is Showing "No Sales Credit" Multiple Times (Doc ID 1511258.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Salesrep "No Sales Credit" is showing multiple times in the list of values when entering a invoice. When you choose this salesrep on the AR invoice you receive the following error:

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01422.
ORA-01403: No Data Found


If you choose this salesrep on the customer record, it allows you to save the record, but it will not show up on the AR Invoice. This only occurs for this one salesrep.

If you look up the salesrep on invoice and customer record, you see multiple records. When you look at salesrep form, it only shows up once.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms