Customize mobile scanning of locator field

[sinipiiro]

Hi -

Thanks for all of the help provided on these pages thus far. I am new to mobile scanning and know little of java, but have knowledge of PL/SQL.

I will be scanning in locator fields and need to insert segment separators into the locator. As an example, our bar code has a locator of 001001A, and I need it to be input as 001.001.A. It appears that pre processing scanning is the preferred method to accomplish this?

Our bar codes do not appear to have DFI's or AI's.

Using PL/SQL preprocessing scan, is there a way to perform a modification only if the current field is the locator field on the telnet screen? How does one reference the form/field name?

If JAVA based pre processing customization is the only manner to do this..Does anyone have a very simple example of the code that should be used? As stated, I have no java experience.

Thanks!

[kthomas]

Hello sinipiiro,

Can you do me a favor? Can you post your trace.log file so I can actually see what is being called when the scan takes place?

More than likely there is a DFI or something set up that is defining this field. If that's the case we would probably want to use JAVA.

If it is a more generic scan in that you could use the PL/SQL preprocessing scan procedure if it always begins with:
001

or if you could put something at the begining of the barcode to specify that its a locator code:

Ex:

Create a barcode surrounded by pipes: |001001A|

When it is scanned it's read into the PL/SQL procedure. In that procedure you just parse out the PIPES | and format it to 001.001.A

Then at the end you just set 001.001.A to a variable and RETURN that variable.

This will only work if you are just now printing these barcodes and they don't already exist. If they do already exist we'll have to figure a way around that.

But please post your trace.log file so I can take a look. Also a screenshot of your mobile page will help too.

[sinipiiro]

Hi- Thanks for the quick response.

Let me work on getting a trace file and screen print of the telnet screen.
Sadly, the bar codes already exist, and it doesnt appear that printing new ones are an option.

[kthomas]

no worries ... i can help you figure out a solution

[sinipiiro]

Hello..That took a bit .

When scanning the locator for this particular session, the screen looks like this..It is the locator inquiry screen:

Locator Inquiry(WMS)
Sub >
Loc ]
Item >
Desc :
CG >
<Find>
<Cancel>

The log close to the point of scanning locator 001001A is as follows. The item R1-2/5-9 was entered manually on the mobile.

[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) loadPage: done loading 'oracle.apps.mwa.beans.LOVRuntimePageBean' (pageIx = 4, fieldIx = 0)
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) handleEvent: entering new page (pageIx = 4)
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) callListeners: executing 1 listeners, action = 0
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) callListeners: PageBean
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) Entering pageEntered of LOVRuntimePageHandler
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) lov stmt :INV_UI_ITEM_SUB_LOC_LOVS.GET_INQ_PRJ_LOC_LOV_NVL
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[0] :
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[0] :C
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[0] :null
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[1] :ORGID
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[1] :N
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[1] :914
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[2] :SUBINVENTORY
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[2] :S
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[2] :R1-2/5-9
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[3] :RESTRICTLOCCODE
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[3] :N
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[3] :null
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[4] :ITEMID
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[4] :N
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[4] :null
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[5] racle.apps.inv.invinq.server.ItemOnhandQueryPage.FromLocatorQuery
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[5] :S
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[5] :001001A%
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[6] :ItemOnhandQueryPage.PROJECTID
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[6] :S
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[6] :null
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParams[7] :ItemOnhandQueryPage.TASKID
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) inputParamsType[7] :S
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) value of inputParams[7] :null
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) No result is found
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) Exiting pageEntered of LOVRuntimePageHandler
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) handleEvent: backing off (empty LOV/MultiList)
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) handleEvent: Closing opened LOV statement
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) setCurrentPagePtr: ptr = 3
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) (LSINISAL) purgePageStack: purging at pageIx = 3
[Fri Mar 13 09:03:57 EDT 2009] (Thread-22) in initializePage...
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) Entered Input: 001001A
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) Pre-preocessing the inv scan
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) Trying to load custom class oracle.apps.inv.lov.server.InvScanManager
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) oracle.apps.inv.lov.server.InvScanManager class not found, but OK.java.lang.ClassNotFoundException: oracle.apps.inv.lov.server.InvScanManager
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) handleEvent: entering LOVRuntimePageBean
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) loadPage: trying to load 'oracle.apps.mwa.beans.LOVRuntimePageBean'; customization :null
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) loadPage: trying to load 'oracle.apps.mwa.beans.LOVRuntimePageBean'
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) purgePageStack: purging at pageIx = 3
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) addPage: old current page = 3
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) addPage: new current page = 4
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) addPage: adding 0 fields to hashtable
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) loadPage: done loading 'oracle.apps.mwa.beans.LOVRuntimePageBean' (pageIx = 4, fieldIx = 0)
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) handleEvent: entering new page (pageIx = 4)
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) callListeners: executing 1 listeners, action = 0
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) callListeners: PageBean
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) Entering pageEntered of LOVRuntimePageHandler
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) lov stmt :INV_UI_ITEM_SUB_LOC_LOVS.GET_INQ_PRJ_LOC_LOV_NVL
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[0] :
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[0] :C
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[0] :null
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[1] :ORGID
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[1] :N
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[1] :914
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[2] :SUBINVENTORY
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[2] :S
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[2] :R1-2/5-9
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[3] :RESTRICTLOCCODE
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[3] :N
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[3] :null
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[4] :ITEMID
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[4] :N
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[4] :null
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[5] racle.apps.inv.invinq.server.ItemOnhandQueryPage.FromLocatorQuery
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[5] :S
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[5] :001001A%
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[6] :ItemOnhandQueryPage.PROJECTID
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[6] :S
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[6] :null
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParams[7] :ItemOnhandQueryPage.TASKID
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) inputParamsType[7] :S
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) value of inputParams[7] :null
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) No result is found
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) Exiting pageEntered of LOVRuntimePageHandler
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) handleEvent: backing off (empty LOV/MultiList)
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) handleEvent: Closing opened LOV statement
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) setCurrentPagePtr: ptr = 3
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) (LSINISAL) purgePageStack: purging at pageIx = 3
[Fri Mar 13 09:04:10 EDT 2009] (Thread-22) in initializePage...
[Fri Mar 13 09:04:19 EDT 2009] (Thread-8) SSR thread starts running...
[Fri Mar 13 09:04:20 EDT 2009] (Thread-11) DispatcherRegistrarThread: dispatcher response from stinger.kaz.com:10250 was 'ALREADY_REGISTERED'
[Fri Mar 13 09:05:00 EDT 2009] (Thread-22) Entered Input: 001001A
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) Pre-preocessing the inv scan
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) Trying to load custom class oracle.apps.inv.lov.server.InvScanManager
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) oracle.apps.inv.lov.server.InvScanManager class not found, but OK.java.lang.ClassNotFoundException: oracle.apps.inv.lov.server.InvScanManager
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) (LSINISAL) handleEvent: MWA_MAIN_MENU handling
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) (LSINISAL) callListeners: executing 1 listeners, action = 2
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) (LSINISAL) callListeners: PageBean
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) setCurrentPagePtr: ptr = 1
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) (LSINISAL) purgePageStack: purging at pageIx = 1
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.CancelBtn
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.CancelBtn
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.FindBtn
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.FindBtn
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.SNQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.SNQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.UNITNUMBER
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.UNITNUMBER
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.LotNumberQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.LotNumberQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.CostGroupQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.CostGroupQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.TASK
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.TASK
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.PROJECT
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.PROJECT
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.RevisionQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.RevisionQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.ItemDescr
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.ItemDescr
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.ItemQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.ItemQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.FromLocatorQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.FromLocatorQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.inv.invinq.server.ItemOnhandQueryPage.SubinventoryQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: removing instance from HToracle.apps.inv.invinq.server.ItemOnhandQueryPage.SubinventoryQuery
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) (LSINISAL) callListeners: executing 1 listeners, action = 0
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) (LSINISAL) callListeners: PageBean
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN7
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN6
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN5
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN4
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN3
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN2
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN1
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN0
[Fri Mar 13 09:05:01 EDT 2009] (Thread-22) removeFieldBean: fieldName = oracle.apps.mwa.beans.MenuPageBean.MENUITEMBEAN-1

Thanks!

[kthomas]

Question:

Is this the only thing scanned on this page?

If so, the procedure:

Code: Select all

PROCEDURE process_scan(x_return_status     OUT nocopy VARCHAR2,
                   x_processed_value   OUT nocopy VARCHAR2,
                   p_current_page_name IN  VARCHAR2,
                   p_scanned_value     IN  VARCHAR2)

You see that there is a p_current_page_name, on this you can do an if then condition to basically parse what is scanned and return it to the field it was scanned on.

If there are other barcodes being scanned this will not work ...

Let me know and hopefully I can provide further input.

[sinipiiro]

Hello

Sadly, this is not the only page in which locators will be scanned, and on other pages, other fields will be scanned.

My guess is that the PL/SQL method will not really work sincethere are no DFI's , and that the JAVA call out is the best option? Is that correct?

I am asking our DBA to work with me on setting up a custom directory/CustomScanManager file.

[kthomas]

Hello

Sadly, this is not the only page in which locators will be scanned, and on other pages, other fields will be scanned.

My guess is that the PL/SQL method will not really work sincethere are no DFI's , and that the JAVA call out is the best option? Is that correct?

I am asking our DBA to work with me on setting up a custom directory/CustomScanManager file.

Sinipiiro,

If its on other pages that's fine ... Basically what I was asking was, is the LOCATOR "barcode" the onlything scanned on these pages?

If it is you could just do this:

Code: Select all

if page_name = 'com.company.xxcus.SOMEPACKAGE.SOMEPAGE' then
  -- code to parse out and concatenate the . ie(00.1A.000)
elsif page_name = 'com.company.xxcus.SOMEPACKAGE.SOMEPAGE2' then
  -- code to parse out and concatenate the . ie(00.2A.000)
end if
return PARSEDVARIABLE


but if you have some pages that scan the locator and the item number, lot number, etc. then you will need to create a customscanmanager.class file to do your conidtions and return the value.

This would be a combination of DFIs to determine ITEM, QTY, LOT, etc and then would also be able to determine if you're scanning in a LOCATOR.

Regardless it returns only one value back to the scanned field.

[sinipiiro]

Thanks for your help kthomas.

Yes, we will have some pages that scan locator, item number, lot, etc, so it looks as though customscanmanager.class is the way to go.

Apparently we are not using DFI's on any of our bar codes, so that has opened a new area of discussion.

Never a dull moment!

[kthomas]

good luck and let me know if i can help you.