My Oracle Support Banner

Performance Problem When Generating Or Creating An LPN (Doc ID 550211.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Warehouse Management - Version and later
Information in this document applies to any platform.


You are experiencing a performance problem when generating an LPN or manually entering a new LPN in the mobile environment. You are experiencing this issue in all forms that require an LPN entry.

In a typical INV: Debug log file the following might be seen. It can be seen below there is an approximate 4 minute gap between print request calls. This is directly related to the degraded performance you are experiencing.

[18-JAN-08 09:11:58] LABEL_MAIN: Populate History Record ReqID=43939
[18-JAN-08 09:11:58] LABEL_MAIN: Record Inserted to WDRH
[18-JAN-08 09:11:58] LABEL_MAIN: Custom Labels Trace [INVLABPB.pls]: After populate_history_record()
[18-JAN-08 09:11:58] LABEL_MAIN: Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 27
[18-JAN-08 09:11:58] LABEL_MAIN: Custom Labels Trace [INVLABPB.pls]: Inside DEMAND Driven -> TCP/IP Synchronous mode code
[18-JAN-08 09:11:58] LABEL_MAIN: Custom Labels Trace [INVLABPB.pls]: l_variable_data(k).label_status: S
[18-JAN-08 09:11:58] LABEL_MAIN: Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 28
[18-JAN-08 09:11:58] LABEL_MAIN: Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP()
[18-JAN-08 09:11:58] PRINT_REQUEST: Found PRINTER NAME as oracle001
[18-JAN-08 09:11:58] PRINT_REQUEST: IP address: XX.X.XX.XX, Port number:XXXX
[18-JAN-08 09:11:58] PRINT_REQUEST: Calling SEND_XML_TCPIP
[18-JAN-08 09:15:45] PRINT_REQUEST: Called SEND_XML_TCPIP, l_return=-1, l_return_msg=, l_printer_status=
[18-JAN-08 09:15:45] PRINT_REQUEST: Expected Error in SYNC_PRINT_TCPIP
[18-JAN-08 09:15:45] PRINT_REQUEST: ERROR Code =1
[18-JAN-08 09:15:45] PRINT_REQUEST: ERROR Message=User-Defined Exception






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.