My Oracle Support Banner

Cannot Assign a Contract to a Sales Order if the Contract Number is Longer Than 20 Characters (Doc ID 2864782.1)

Last updated on APRIL 22, 2022

Applies to:

Oracle Service Contracts - Version 12.2 and later
Information in this document applies to any platform.


When attaching an existing service contract to a service line in the Service Contracts Details form, the following error occurs:

ORA-01403: no data found

FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-06502.

1. Using an Order Management responsibility, open the Sales Orders form.
2. Enter a Sales Order and add a Service line.
3. Click the "Actions" and select "Service Contract Details".
4. Click the "Existing" radio button.
5. Use the contract number LOV and pick a contract number that is more than 20 characters long and click on OK.
6. Click the Save Icon.
7. Get the indicated error.




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.