Performance Problem When Generating Or Creating An LPN
(Doc ID 550211.1)
Last updated on MARCH 22, 2023
Applies to:
Oracle Warehouse Management - Version 11.5.10.0 and laterInformation in this document applies to any platform.
Symptoms
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
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |