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:

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

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