My Oracle Support Banner

OKS_IMPORT_SUBLINE_PUB.CREATE_SUBLINE Fails To Create A Subline If The Quantity Is Zero (Doc ID 2102405.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.2.4 version

ACTUAL BEHAVIOR
---------------
Calling API oks_import_subline_pub.create_subline with Quantity (QTY) and PRICE_SUBTOTAL = 0 results in the API call completing successfully but the subline does not get created.

There are no errors, the API return status = 'S'

EXPECTED BEHAVIOR
-----------------------
Expect that the subline would be created.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the oks_import_subline_pub.create_subline with Quantity (QTY) and PRICE_SUBTOTAL = 0

BUSINESS IMPACT
-----------------------
Due to this issue users cannot import sublines with zero quantity and price_subtotal.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.