[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Oracle and AIAG Standards

Asked by kstahl in Oracle 11.x Database, Oracle Database

Tags: Oracle, AIAG, ERP

Hi, we're currently implementing Oracle 11.5.9 and our company has always used AIAG prefixes internally for all barcodes.  We require our suppliers to also label their products in this way.

Each barcode used internally has a 1 to 3 digit prefix.  

For example:
(P)  Part number 34591 would be P34591 in the barcode.
(1T) Lot number 0048512 would be 1T0048512 in the barcode.  
(Q)  Quantity 750 would be Q750 in the barcode

Our current WMS strips out these data identifiers today.  I'm trying to find a way to do this with the Oracle WMS.  

I can change our scanners to just drop the first digit, but it is not always the first digit only.

Thanks in advance for the help.
[+][-]11/05/09 03:19 AM, ID: 25748356Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 03:22 AM, ID: 25748369Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625