Discrepancy in Sales Order Line Number Sequence: UI vs. Backend Database

Summary:

We have an integration for sales order creation that utilizes Oracle Utilities Work and Asset Cloud Service (WACS) through Oracle Integration Cloud (OIC). Due to a limitation in WACS, sync requests can time out after five minutes, which can lead to multiple retries when creating sales orders in the ERP, particularly for large orders.

Recently, I observed a work order (WO) with 99 ISO lines. All lines were created after several retries, and in the sales order user interface (UI), the ISO line numbers are sequentially ordered. However, in the DOO_lines_all table, the sequence of line numbers deviates; after line number 80, the next line number starts at 105.