OASIS Universal Business Language (UBL) TC

  • 1.  Revised update list

    Posted 10-24-2007 13:59
    Hello UBL TC,
    
    Here's what I've got so far for the changes we need to make to
    produce the Update Package for UBL 2.0.  I'm sure that I've missed
    something.  Please review.
    
    Jon
    
    ##################################################################
    
    All references to the .xls versions of the spreadsheets apply to
    the .ods versions as well, and vice-versa.
    
    ==================================================================
    
    CATEGORY 1: SPREADSHEET DICTIONARY ENTRY NAME (DEN) ERRORS AND
    CORRESPONDING SCHEMA DOCUMENTATION ERRORS
    
    Note that these are also errors in the localization spreadsheets
    and that cell references change in the versions being used for
    localization.  Our strategy will be to correct the original 2.0
    spreadsheets and then correct the localization spreadsheets
    programmatically.
    
    Neither the spreadsheet errors nor the few corresponding schema
    documentation errors are substantive per OASIS definition.
    
    1.1 In both UBL 2.0 Common Library spreadsheets, cell B455 reads
        "Hazardous Item. Medical First Aid Guide Code Code" and should
        read "Hazardous Item. Medical First Aid Guide Code. Code"
    
    1.2 In both UBL 2.0 Catalogue Request spreadsheets, cell B28 reads
        "Catalogue Request. Catalogue Request B28Line" and should read
        "Catalogue Request. Catalogue Request Line"
    
    1.3 DENs in UBL 2.0 Common Library cells B117, B118, B119, B252,
        B279, B895, B896 and B897 should be corrected as follows:
    
        B117: Catalogue Pricing Update Line. Contractor_ Customer Party. Customer Party
        B118: Catalogue Pricing Update Line. Seller_ Supplier Party. Supplier Party
        B119: Catalogue Pricing Update Line. Required_ Item Location  Quantity. Item Location Quantity
        B252: Credit Note Line. Discrepancy_ Response. Response
        B279: Debit Note Line. Discrepancy_ Response. Response
        B895: Shipment Stage. Loading Port_ Location. Location
        B896: Shipment Stage. Unloading Port_ Location. Location
        B897: Shipment Stage. Transship Port_ Location. Location
    
    1.4 UBL 2.0 Common Library cell B38 has an invalid value
        "Allowance Charge. Reason. Text"; this should be "Allowance
        Charge. Allowance Charge_ Reason. Text"
    
    1.5 UBL 2.0 Common Library cells B253 and B254 have a DEN starting
        with "Credit Note" when the DEN should start with "Credit Note
        Line"
    
    1.6 UBL 2.0 Common Library cells B280 and B281 have a DEN starting
         with "Debit Note" when the DEN should start with "Debit Note
         Line"
    
    1.7 UBL 2.0 Common Library cell B423 has a DEN "Goods Item.
        Quantity. Quantity" that should be "Goods Item. Quantity"
    
    1.8 UBL 2.0 Common Library cell G424 reads "Criterion" and should
        read "Code" because the representation term is "Code", which
        then changes F424 from "Preference" to "Preference Criterion"
    
        Schema documentation: change "Goods Item. Preference
        Criterion. Code" to "Goods Item. Preference Criterion
        Code. Code"
    
    1.9 UBL 2.0 Common Library cell G577 reads "Method" and should
        read "Code" because the representation term is "Code", which
        then changes F577 from "Inspection" to "Inspection Method"
    
        Schema documentation: change "Line Item. Inspection
        Method. Code" to "Line Item. Inspection Method Code. Code"
    
    1.10 UBL 2.0 Common Library cell B653 reads "Order Reference.
         Customer_Reference. Text" and should read "Order
         Reference. Customer_ Reference. Text"
    
    1.11 UBL 2.0 Common Library cell I779 is empty and should be "Line
         Item"
    
    1.12 UBL 2.0 Common Library cell B796 reads "Receipt Line. Timing
         Complaint. Code" and should read "Receipt Line. Timing
         Complaint Code. Code" because of the property term
    
    1.13 UBL 2.0 Common Library cell G856 reads "Level" and should
         read "Code" because the representation term is "Code", which
         then changes F856 from "Shipping Priority" to "Shipping
         Priority Level"
    
         Schema documentation: change "Shipment. Shipping Priority
         Level. Code" to "Shipment. Shipping Priority Level Code. Code"
    
    1.14 UBL 2.0 Common Library cell E881 reads "First Arrival Port "
         and the trailing space should be removed to read "First Arrival
         Port"
    
    1.15 UBL 2.0 Common Library cell E882 reads "Last Arrival Port "
         and the trailing space should be removed to read "Last Arrival
         Port"
    
    1.16 UBL 2.0 Common Library cell B939 has a DEN "Status. Percent.
         Percent" that should be "Status. Percent"
    
    1.17 UBL 2.0 Common Library cell B1027 reads "Transport Event.
         Transport Event Type. Code" and should read "Transport Event.
         Transport Event Type Code. Code" because of the property term
    
    1.18 In the following spreadsheets, cells H4 and H5 are wrong 
         because they are the fixed string "Identifier" rather than
         the formula found in H3 which produces the correct value.
         Copying the formula from H3 to H4 and H5 repairs these cells
         (turns out to be every one *except*
         UBL-TransportationStatus-2.0.ods which is already correct in
         UBL 2.0):
    
         UBL-ApplicationResponse-2.0.ods
         UBL-AttachedDocument-2.0.ods
         UBL-BillOfLading-2.0.ods
         UBL-Catalogue-2.0.ods
         UBL-CatalogueDeletion-2.0.ods
         UBL-CatalogueItemSpecificationUpdate-2.0.ods
         UBL-CataloguePricingUpdate-2.0.ods
         UBL-CatalogueRequest-2.0.ods
         UBL-CertificateOfOrigin-2.0.ods
         UBL-CreditNote-2.0.ods
         UBL-DebitNote-2.0.ods
         UBL-DespatchAdvice-2.0.ods
         UBL-ForwardingInstructions-2.0.ods
         UBL-FreightInvoice-2.0.ods
         UBL-Invoice-2.0.ods
         UBL-Order-2.0.ods
         UBL-OrderCancellation-2.0.ods
         UBL-OrderChange-2.0.ods
         UBL-OrderResponse-2.0.ods
         UBL-OrderResponseSimple-2.0.ods
         UBL-PackingList-2.0.ods
         UBL-Quotation-2.0.ods
         UBL-ReceiptAdvice-2.0.ods
         UBL-Reminder-2.0.ods
         UBL-RemittanceAdvice-2.0.ods
         UBL-RequestForQuotation-2.0.ods
         UBL-SelfBilledCreditNote-2.0.ods
         UBL-SelfBilledInvoice-2.0.ods
         UBL-Statement-2.0.ods
         UBL-Waybill-2.0.ods
    
    1.19 in UBL-CreditNote-2.0.ods cell B3 reads "Credit Note. UBL
         Version. Identifier" and should read "Credit Note. UBL Version
         Identifier. Identifier"
    
    1.20 in UBL-DespatchAdvice-2.0.ods cell J1 is empty and should
         read "Data Type Qualifier"
    
    1.21 in UBL-DespatchAdvice-2.0.ods cell F11 should change from
         "Document" to "Document Status" and G11 from "Status" to
         "Code" (specifically leaving J11 as is)
    
          Schema documentation: change "Despatch Advice. Document
          Status. Code" to "Despatch Advice. Document Status
          Code. Code".
    
    1.22 in UBL-Invoice-2.0.ods cell B36 has "Invoice. Tax_
         Representative_ Party. Party" and should be "Invoice. Tax
         Representative_ Party. Party"
    
    1.23 The values in UBL-Reminder-2.0.ods row 12 are correct as they
         stand, but the literal "Reminder Sequence" in H12 "should be
         the formula in every other row of column 12"
    
    1.24 in UBL-CatalogueRequest-2.0.xls cell B30 (row 27) must be
         "Catalogue Request. Catalogue Request Line" [reference is to
         IDD versions; need cell number for 2.0 versions]
    
    1.25 in UBL-SelfBilledCreditNote-2.0.xls cell B38 must be "Self
         Billed Credit Note. Legal_ Monetary Total. Monetary Total"
         [reference is to IDD versions; need cell number for 2.0
         versions]
    
    ==================================================================
    
    CATEGORY 2: OTHER SPREADSHEET ERRORS
    
    Note that these are also errors in the localization spreadsheets
    and that cell references change in the versions being used for
    localization.  As before, we plan to fix the originals and then
    update the localization spreadsheets programmatically.
    
    2.1 mod/maindoc/UBL-Waybill-2.0.xls: cell A4 has the UBLName
        "FALSE"; this should be the word "CustomizationID"
    
    2.2 mod/common/UBL-CommonLibrary-2.0.xls: cell Q99 has
        "assiciation" for "association" (this also appears in
        xsd/common/UBL-CommonAggregateComponents-2.0.xsd, though not a
        substantive error)
    
    ==================================================================
    
    CATEGORY 3: ERRORS IN THE LOCALIZATION SPREADSHEETS THAT ARE NOT
    ALSO ERRORS IN THE ORIGINAL SPREADSHEETS
    
    ACTION: Need to check the latest versions of the finished
    translations to see whether these problems have already been
    corrected.
    
    3.1 UBL-FreightInvoice-2.0.xls: Recorded as follows: Title in first
        row should be "UBL FreightInvoice 2.0" instead of "UBL Freight
        Invoice 2.0" (but in fact all the titles should have exactly
        the name used for the file except for the extension, e.g.,
        "UBL-FreightInvoice-2.0," or they should be written as if they
        were English, that is, with spaces)
    
    3.2 UBL-PackingList-2.0.xls: Same comment as above
    
    ==================================================================
    
    CATEGORY 4: CODE LIST CHANGES
    
    4.1 cl/gc/default/CountryIdentificationCode-2.0.gc has two broken
        entries for Bosnia and Herzegovina when there should be just
        one correct entry:
    
          
          [...]
          
    
    4.2 cl/gc/special-purpose/PortCode-2.0.gc is missing a country
        subdivision column, resulting (for example) in 11 different
        locations named "Columbus" with no way of disambiguating them
    
    4.3 cl/gc/UnitOfMeasureCode-2.0.gc needs to be replaced by later
        version from UNECE
    
    4.4 cl/gc/TransportationStatusCode-2.0.gc needs to be replaced by
        later version from UNECE
    
    ==================================================================
    
    CATEGORY 5: CODE LIST UPDATE
    
    All the genericode files need to be updated to genericode 1.0.