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.


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.  

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.




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