My Oracle Support Banner

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

Last updated on JULY 10, 2020

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.