My Oracle Support Banner

Database Management System (DMS) Error Is Displayed When Printing Receiving Labels For An Advanced Shipment Notice (ASN) Appointment For Perishable Items (Doc ID 810855.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Warehouse Management System - Version 12.0 to 13.1.9 [Release 12.0 to 13.1]
Information in this document applies to any platform.


In Version 12.0, 13.0 and 13.1, when multiple perishable items are sent from a store to a warehouse by creating a
single Return To Warehouse (RTW) through Store Inventory Management (SIM), an Advanced Shipment Notice (ASN) and a Purchase Order (PO) is created in Retail Warehouse Management System  (RWMS) to receive the items into the warehouse. When an appointment is created in RWMS to receive the ASN, and receiving labels are attempted to be printed, a Database Management System (DMS) error is displayed with the error_log entries :

Error_Source : create_rec_pkg.set_ucc128_wip_info
Error_message: FAILURE User-Defined Exception

Error_source : RECEIVING_LABELS_S print_report
Error_message: Create_Receiving_Package FAILED in print_report for appt_nbr='xxxx'

Steps To Reproduce:
1. Create a RTW in SIM for multiple perishable items.
2. An C-type ASN and PO is created in RWMS.
3. Check the CONTAINER_WIP table. WIPs with WIP_CODE FSTSKU and BBDATE and MXDSKU are created.
4. Create an ASN appointment and print the receiving labels. The 'Internet Ready HTM' popup is
displayed. Hit 'Save'.
5. DMS error is generated.
6. Error_log entries are as below :
AK 1 CSWMS12QAU 26-MAR-09 create_rec_pkg.set_ucc128_wip_info FAILURE User-Defined Exception
AK 1 MISHRAA 26-MAR-09 RECEIVING_LABELS_S print_report Create_Receiving_Package FAILED in print_report for appt_nbr=108002




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.