LE_HST_TL.MO_NO_TX_TOT Column Value Not Updated When Both Taxable and Non-Taxable Items Exist In The Transaction (Doc ID 2259770.1)

Last updated on APRIL 28, 2017

Applies to:

Oracle Retail Point-of-Service - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

LE_HST_TL.MO_NO_TX_TOT (NontaxableTotalAmount) column is not updated correctly when both Taxable and Non-Taxable Items exist in the transaction.

Steps to reproduce:
1. Scan Item:41 (Non-Taxable)
2. Scan Item:42 (Taxable)
3. Click on "Tender F6" >> "Cash F2" and complete the transaction
4. Check the value on LE_HST_TL.MO_NO_TX_TOT and notice that it's value is zero for the transaction

Changes

 

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