SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need API for Converting GS1 string scanned from Barcode to UDI format

User_TRMHVMar 11 2020 — edited Apr 3 2020

Hi,

We have a requirement to convert GS1 barcode string to UDI format. Do we have any Standard API/Stored procedure parser to convert GS1 Barcode to UDI format? Any help at the earliest would be highly appreciated.

Ex:

Raw data scanned from GS1 barcode as below,

GS1%90123456789012%011234567892345%111707021712030321123456@

After parsing the string, Expected UDI Format as below,

(01)1234567892345(90)123456789012(17)03032012(21)123456(11)07022017

Elements of the UDI string:

(90)123456789012 ---> PART

(01)1234567892345 ---> GTIN

(17)03/03/2012 ----> Expiration Date

(21)123456 -----> Serial Number

(11)07/02/2017 ----> production date

Below is the code mapping and size of the string. Codes 21,90 and 10 are variable string and remaining are fixed.

Code	Description	Data Length
1	Global Trade Item Number (GTIN)	14
21	Serial Number	1-20 Variable
90	SKU ID (PART)	1-30 Variable
10	Batch/Lot Number	1-20 Variable
11	Production Date	6
17	Expiration Date	6
422	County of Origin	3

Thanks,

Venkat

Added on Mar 11 2020

9 comments

1,137 views