Shipping Labels Complete In Warning When Using Custom SQL (Doc ID 1957766.1)

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.

Symptoms

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.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Labels > Select Label Type and Printer > Print Shipping Label


Cause

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