Skip to Main Content

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!

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

Comments
Post Details
Added on Mar 11 2020
9 comments
1,243 views