My Oracle Support Banner

Tcktdnld Batch Fails with Error 'No container item record found in cursor c_container_item' (Doc ID 2327653.1)

Last updated on OCTOBER 28, 2022

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.




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.