Tcktdnld Batch Fails with Error 'No container item record found in cursor c_container_item'

(Doc ID 2327653.1)

Last updated on NOVEMBER 14, 2017

Applies to:

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

Symptoms

When attempting to add ticket to a item that has type UOM, TCKTDNLD (Download of Data to be Printed on Tickets) batch assumes that it is part of a deposit item and should have a container.  

ERROR
--------------
tcktdnld_1~20170526071040~get_container_item~item_master~1403~ORA-01403: no data found~No container item record found in cursor c_container_item for item xxxx


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. Verify that the batch fails with the above mentioned error.

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