My Oracle Support Banner

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 MAY 28, 2021

Applies to:

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


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


 This article applies to customers who have already applied <Patch 25776028> - HOTFIX on their POS environment.


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

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