Tcktdnld.pc Writes UOM Record For A Deposit Item Incorrectly

(Doc ID 2324309.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

In the TCKTDNLD output file, the meas_of_price is being multiplied by 10000 to remove decimals resulting in writing e.g. 'per 1000000 ml' as the supplement field.

Steps to reproduce :

1.Create a ticket type of UOM.
2.Attach to an item (which is a regular, approved transaction level item).
3.Navigate to item maintenance, More -> Locations.
4.Enter values as follows in the Ticket Price per Uom fields.
5.Ticket Price = 500 per 100 ML.
Check the full item price of the item in ITEM_LOC (e.g. if 69.96, then these values indicate the unit is 500ML, and the comparison is 100ML.
For 69.96, divide the price by 5 to get 13.992 per 100ML
6.Create a ticket_request for this item.
7.Run the Tcktdnld batch.
8.The supplement field in tcktdnld.pc is a concatenation of ' per '||meas_of_price||' '||uom_of_price. The meas_of_price is being multiplied by 10000 to remove decimals resulting in writing e.g. 'per 1000000 ml' as the supplement field.
When entering this field in the UI, it rounds it so there can be no decimals as the value should be whole numbers e.g. 1ml, 10ml, 100ml or 1000ml so the *10000 is not needed for the meas_of_price.

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