Shipping Labels Complete In Warning When Using Custom SQL
Last updated on APRIL 05, 2016
Applies to:Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
On 12.1.3 version, Label Printing
Shipping Labels occasionally completes in Warning in Production instance. The XML files are generated properly without any missing values.
When re-print, labels come out fine.
The error message 'No value returned by the custom SQL Query.' indicates one of the custom sql query is not returning value, but all custom sqls are returning value and the xml file looks fine too.
This happens 5-6 times a day and very frustrating for the business as they have gone live on 1st December.
The issue can be reproduced at will with the following steps:
1. Labels > Select Label Type and Printer > Print Shipping Label
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms