Error Message Encountered when Trying to Modify Price on a Subline

(Doc ID 2281965.1)

Last updated on JUNE 29, 2017

Applies to:

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


On : 12.1.3 version, Pricing Integration

When trying to modify the price in a service contract, manually on pricing/products tab, on pricing level, the following error occurs on some of the sublines:

Error Codes
Call to QP engine API "qp_preq_pub.price_request" returned the following error: Routine QP_PREQ_GRP.INSERT_LDETS2 ORA-01400: cannot insert NULL into ("QP"."QP_PREQ_LDETS_TMP_T"."CREATED_FROM_LIST_HEADER_ID")

The issue can be reproduced at will with the following steps:
1. Author a service contract
2. Navigate to Sublines
3. Try to enter change the price and receive the 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