After Removing Line Item, Update Price Generates Error [Line items must be in a numerical sequence, (i.e - 1, 2, 3, 4 ...x). The sequence must start with 1. An error occurred with the line item sequence. The order of items may have changed] (Doc ID 2229810.1)

Last updated on MARCH 22, 2017

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 2015 R2 and later
Information in this document applies to any platform.

Symptoms

When removing an item from the Line Item Grid, and then performing Update Price, there is an error about the sequence numbers of the line items.
If, instead, Save is performed after removing the item, this error does not occur.

The displayed and logged error is:

Line items must be in a numerical sequence, (i.e - 1, 2, 3, 4 ...x). The sequence must start with 1.
An error occurred with the line item sequence. The order of items may have changed.

This only happens when attempting to remove certain Line Items, those which represent a parent Line Item while their corresponding children Line Items are hidden from the user.

When the user removes such a product, the desired behavior is that the hidden child items of that product are also deleted.
This functionality is achieved with the help of a commerce library and called inside the function defined in Advanced Modify - After Formulas for the Remove action. The child items are removed using SOAP calls.

Cause

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