Global Location Number, Global Locator Number(GLN) Related Business Functions For EDI

Purpose of Document

The purpose of this document is to explain business functions related with GLN and new Data Dictionary Items and Tables altered.

History of Global Locator Number (GLN)

EnterpriseOne application release 9.1 provides GLN support for EnterpriseOne. GLN is a 13 digit number assigned to a location. A location can be a building or an area within a building. It is used to represent the mailing or physical address of the location. In E1 Distribution terms a GLN could be assigned to a Sold to, Ship to, Deliver to, B/P, Supplier, Origin, or Destination. The first 7 digits are assigned by the GS1 organization that represents the company, the next 5 are assigned by the company, and the last digit is a check digit.

New Data Dictionary Items for EDI

Data dictionary item added in the 9.1 release.

Business Functions for GLN

The Business functions listed below are edited/validated for GLN for EnterpriseOne EDI:

B4701061 - EvaluateCheckDigit (Evaluate Check Digit)

• Purpose: This business function is to check whether exiting check digit is valid or to compute check digit based on 12 digits are provided.
• Parameter:
• Data Structure: D4701061B - Evaluate CheckDigit

• Detail Routine:

1. Check input mnGLN (If input mnGLN is zero set error "088R"
2. Convert input mnGLN into String value by calling business function B0000083 (MathNumericToStringZeroPad) to handle check digit. If failed to convert then set error "164L"
3. Check "Check Digit". If check digit is not valid then set error "47E09"

• Errors:
• 088R - Blanks Invalid for &1 .
• CAUSE . . . . The &1 field being processed does not allow blanks or zeros
  to be entered.
• RESOLUTION. . Enter a non-blank or non-zero value.
• 164L - Math Numeric to String Error
• Error in converting from Math Numeric to String
• 47E09 - Error in Checkdigit entered by the user
• Cause: Error in Checkdigit entered by the user..
• Resolution: GLN is a 13 digit number. Last digit should be a a modulo-10 number calculated across the preceding digits.
• Other Considerations: Referencing B0000083, B8000094 and B0000580

Below is to explain Check Digit. Supposed that Glocal Locator Number is 301256798014:

Check Digit Calculation:

B4701061 - GenerateGLN (Generate GLN)

• Purpose: This business function generate GLN number based on UDC 47/LN per company and NN 47/4 (47|4) with check digit.
• Parameter:
• Data Structure: D4701061A - Generate GLN

• Detail Routine:

1. Check input szCompany. If input value is Blank then set error "47E06"
2. Read F0005.DL02 based on UDC 47/LN (Company Prefix for GLN) where szUserDefinedCode = input szCompany. If no code exist, then set error "47E07"
3. If szDescription002 is blank OR the the length of szDescription002 is not 6 then set error "47E07"
4. Set szGLN (String value for mnGLN) = UDC.szDescription002
5. Get Next Number NN 47|4 through BSFN X0010 (X0010GetNextNumber). No definition then set error "47E08"
6. Convert numeric value of mnNextNumber001 into 7 digit strings by calling B0000083 (MathNumericToStringZeroPad). If failed to convert then set error "164L"
7. Concat UDC.szDescription002 with mnNextNumber001
8. Validate check digit (I4701061_EvaluateCheckDigit). If fail, then set error "47E09"
9. Convert back to Numeric value

• Errors:
• 47E06 - Company cannot be blank
• Cause: Company is required to generate GLN
• Resolution: Please enter a valid Company.
• 47E07 - Prefix is not in UDC 47/LN for - &1
• Cause: 1. Company Prefix is not found in UDC 47/LN for - &1 or
  2. Length of the company prefix entred in the UDC 47/LN is not equal to 6.
• Resolution: Please enter the 6 digit company prefix provided by GS1 in the 'Description02' field of the UDC 47/LN.
• 47E08 - Next Number generation failed
• Cause: Next Number generation failed while Generating GLN.
• Resolution: Please check the next number(system code - 47) and index(4) entered in P0002.
• 164L - Math Numeric to String Error
• Error in converting from Math Numeric to String
• 47E09 - Error in Checkdigit entered by the user
• Cause: Error in Checkdigit entered by the user..
• Resolution: GLN is a 13 digit number. Last digit should be a a modulo-10 number calculated across the preceding digits.
• Other Considerations: N/A

B4701060 - GetGLNorABNumber (Get GLN or Address book Number)

• Purpose: This business functions returns data from F0101G depending on input parameters specified. In case you need to return F0101G Data Pointer do not set cCloseTable as 'Y'. Combinations of mnAddressNumber and mnGLN the way it gets data from F0101G can be different.
• Parameter:
• Data Structure: D4701060A - Get GLN or Addressbook Number

• Detail Routine: Error routine can be understood through error routine as below,

1. Initialize Environment Handle through JDB_InitBhvr. If failed, set error "078S"
2. Input cCloseTable = Y and idHandleF0101 is NULL then issue error "138H" (below routines handled only when cCloseTable is not Y)

• Errors:
• 078S - Initialization of behavior failed
• CAUSE . . . . The business function was unable to retrieve a valid user
  handle.
• RESOLUTION. . Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• 138H - Parameter Handle not passed in
• CAUSE . . . . A handle to a parameter object is either NULL or invalid
  has been passed in.
• RESOLUTION. . The business function data structure indicates that there
  is a parameter object to be retrieved from the system.
  However, the pointer to this object was not successfully
  retrievd from the passed in handle. There could be a problem
  with the system or with the application passed in an invalid
  handle index.
• 47E01 - Address and GLN supplied are blank
• Cause: The Address book number and GLN are blank.
• Resolution: Please enter a valid Address book number or GLN .
• 47E02 - Address not in F0101G for the GLN &2
• Cause: Address book number not found in F0101G(Global location number for address book) for the GLN &2
• Resolution: Please enter a GLN for the Address book number using the P01012 application
• 47E03 - Address &1 not in F0101
• Cause: Address book number &1 not found in F0101 (Address Book Master)
• Resolution: Please enter a valid Address book number or add a new Address book number using the P01012 application
• 47E04 - Address (&1)and GLN(&2) not in F0101G
• Cause: Address book number (&1)and GLN(&2) combination not found in F0101G(Global location number for address book)
• Resolution: Please enter a valid Address book number and GLN or add a new Address book number and GLN
  using the P01012 application.
• 47E05 - GLN not in F0101G for Address &1
• Cause: GLN not in found in F0101G(Global location number for address book) for Address book number &1
• Resolution: Please enter a valid GLN or add a new GLN for the Address book number using the P01012
  application
• Other Considerations: Refer error routine

List of EDI tables with a column GAN8

The following tables were updated for the GLN enhancement

New Data Dictionary Items Added for GLN

Note: If you leave the value blank 0000000000 is to be populated.

Global Location Number Functional Training

This training provides a functional overview of the JD Edwards EnterpriseOne 9.1 Global Location Number enhancement.

Refer to the Oracle Learning Library (OLL) Tutorial available here. There is no audio in this self-paced training enabling you to view the content at your own pace.