Incorrect Related Line Item Sequence Number is Created for Voided Items (Doc ID 1932532.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle Retail Point-of-Service - Version 13.4.7 to 13.4.9 [Release 13.4]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Point of Service (ORPOS) 13.4.x, a transaction containing voided (deleted) related items is written to the database with incorrect related line item sequence numbers.  These appear in column TR_LTM_SLS_RTN.AI_LN_ITM_RLTD.


Steps to Reproduce:

  1. Create a transaction with 3 items, all having related items.
  2. Void (delete) the first 2 primary items (their related items will delete at the same time).
  3. End transaction with cash tender.
  4. Observe incorrect line sequence numbers in column TR_LTM_SLS_RTN.AI_LN_ITM_RLTD.

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