ORA-01400: Cannot Insert NULL Into ("OKS"."OKS_BILL_SUB_LINE_DTLS"."AMOUNT") when Terminating Subline

(Doc ID 1531597.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Service Contracts - Version 12.1.2 and later
Information in this document applies to any platform.
Checked for relevance on 13-Aug-2014


On : 12.1.2 version, Contracts Billing/Termination

When attempting to terminate a billed subline and entering an override amount, the following error occurs.

ORA-01400: cannot insert NULL into ("OKS"."OKS_BILL_SUB_LINE_DTLS"."AMOUNT") in Package OKS_BSD_PVT Procedure DTLS_insert_row

The issue can be reproduced at will with the following steps:
1. Query a billed contract
2. Open the contract
3. Go to any subline that has an amount.
4. Tools >> Terminate subline
5. Enter 01-MAR-2012 for date and choose any reason
6. Click on Review
7. Enter Override 0.00
8. Click on Terminate and receive error.


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