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 FEBRUARY 12, 2019

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

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
Symptoms
Cause
Solution
References


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