Transactions Workbench: List Of Values For Sales Rep Is Showing "No Sales Credit" Multiple Times
Last updated on MAY 12, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms