My Oracle Support Banner

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

Last updated on NOVEMBER 19, 2018

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.