{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Example","Change Log","Instructions","Notifying Party","References","Exceptions","Additional Information","Lookup Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Example","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["PDG TI Exchange Exception Notification"]
["Example Definition"]
[]
["This Exception Notification is for a product that arrived damaged."]

{"sheet":"Change Log","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["PDG TI Exchange Exception Notification"]
["Change Log"]
["Changes applied to this version of the template."]
["Template Version","Date","Changes","Notes"]
["v1.0.0","2025-12-04","Initial version of the Exception Notification Template"]
["v1.0.1","2025-12-10","Added  Barcode Reading Issue and Barcode Encoding Issue to Exception Type options."]

{"sheet":"Instructions","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["PDG TI Exchange Exception Notification"]
["Instructions"]
["How to use this template."]
["Exception Notification Template Version","01.00.01"]
[]
[null,"PDG makes no representations or warranties regarding the accuracy, completeness, or suitability of the information contained in this template. This template is provided “as is” without any guarantees or warranties of any kind, either express or implied. Users are advised to independently evaluate and verify the information before relying on it for any purpose. PDG shall not be held liable for any errors, omissions, or any outcomes resulting from the use of this template.\n\nAll intellectual property rights in and to this template document are owned by PDG. Users are granted a limited, non-exclusive, non-transferable license to use this template for business purposes only. Any unauthorized use or reproduction of this template, in whole or in part, is strictly prohibited."]
[]
["How to Use the Exception Notification Template:","1.\tStart by reviewing the Exceptions and Lookup Tables Sheets to familiarize yourself with the information you can communicate to your trading partner with this template.  Most fields are optional; however, more information may reduce the time for resolution to the exception(s).\n\n2.\tFill in the References Sheet to provide details your trading partner can use to access information in their systems and reference this occurrence in subsequent conversations and communications.\n\n3.\tComplete the Notifying Party Sheet with accurate contact information to ensure the seller can respond to your exception notification.\n\n4.\tLog the exception details on the Exceptions Sheet, documenting all discrepancies between the Transaction Statement, the product received, and any actions both parties took.\n\n5.\tUse the Additional Information Sheet to attach or link any supporting documents, such as invoices or photos, that may help clarify the exception.\n\n6.\tSelect values from the Lookup Tables to ensure you use standardized terms for exception categories, statuses, and actions, making the notification process smoother and more consistent.\n\n"]
[]
["User Guide:"]

{"sheet":"Notifying Party","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["PDG TI Exchange Exception Notification"]
["Notifying Party"]
["Provide contact information to allow the Seller to follow up with a resolution or questions."]
[]
[]
["Notifying Party's Contact Information"]
[]
["Person or Department Name*:","John Doe"]
[]
["Organization Name*:","Hello Inc"]
[]
["Phone Number*:","555-123-4567"]
[]
["email Address*:","john.doe@example.com"]

{"sheet":"References","index":4,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["PDG TI Exchange Exception Notification"]
["References"]
["Key information associated with the shipment and Exception Notification."]
[]
["Notified Organization*:","ACME Pharma"]
[]
["Notification ID*:","123e4567-e89b-42d3-a456-426614174000","Use a Universally Unique ID "]
[]
["Notification Timestamp*:","2023-12-31T14:30:45Z"]
[]
["Incident ID:","INC98765","Use a Universally Unique ID "]
[]
["Shipment ID:","SHIP12345"]
[]
["P.O. List:","PO123456"]
[]
["Shipment Receipt Date:","2023-12-01"]
[]
["Carrier Tracking Number:","1Z999AA10123456789"]
[null,null,"If \"Other\", please enter your value here."]
["Where in your process was the exception identified:","Receiving"]
[]
["Notifying Party (Owning) GLN:","1234567890123"]
[]
["Notifying Party Name:","Hello Inc"]
[]
["Receiving Location GLN:","9876543210987"]
[]
["Receiving Location Name:","Philadelphia DC"]
[]
["Receiving Location Address:"]
["Street Address Line 1*","123MainStreet"]
["Street Address Line 2"]
["City*","Philadelphia"]
["State, Province or Region*","PA"]
["Postal Code*",19104]
["Country Code*","US"]

{"sheet":"Exceptions","index":5,"n_rows":21,"n_cols":37,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,20,4,28],[4,29,4,36]]}
["PDG TI Exchange Exception Notification"]
["Exceptions"]
["Documentation of the issues observed by the Buyer about the shipment, product,or information provided by the Seller."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physical Product Information",null,null,null,null,null,null,null,null,"Data Information"]
["Exception Line # *","Exception Description *","Buyer \nResolution Request","Buyer Resolution Request if \"Other\"","Buyer \nAction Taken","Buyer Action Taken if \"Other\"","Seller \nResolution Request","Buyer Resolution Request if \"Other\"","Seller\nAction Taken","Buyer Action Taken if \"Other\"","Exception  Applies To","Exception Applies To if \"Other\"","Priority","Priority if \"Other\"","Status","Status if \"Other\"","Exception Category","Exception Category if \"Other\"","Exception Type","Exception Type if \"Other\"","SSCC","GTIN","NDC","Drug Name","Lot Number","Serial Number","Expiration Date","Barcode Scan","Notes","SSCC","GTIN","NDC","Drug Name","Lot Number","Serial Number","Expiration Date","Notes"]
[1,"Product arrived damaged.","Other","call me","Product has been returned",null,null,null,null,null,"Entire Shipment",null,"High",null,"Open",null,"Damaged Product",null,null,"Shipping handling","123456789012345678","00382940500019","12345-6789-01","Sample Drug","LOT12345",null,"2025-12-31",null,"Box was crushed.","123456789012345678","0038294","12345-6789-01","Sample Drug","LOT12345",null,"2025-12-31"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]

{"sheet":"Additional Information","index":6,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["PDG TI Exchange Exception Notification"]
["Additional Information "]
["Additional documents or images sent or available concerning this Exception Notification."]
[]
["Document Links"]
["https://example.com/documents/incident-photo.jpg"]
[]
[]
[]
["Attached Documents"]

{"sheet":"Lookup Tables","index":7,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,11,2,13],[2,15,2,17]]}
["PDG TI Exchange Exception Notification"]
["Lookup Tables"]
["Standardized values used in drop-down lists in this template.",null,null,null,null,null,null,null,null,null,null,"Used if the Buyer is making this Notification to the Seller",null,null,null,"Used if the Seller is making this Notification to the Buyer"]
[]
[null,"Exception Applies To",null,"Exception Categories",null,"Exception Status",null,"Exception Type",null,"Exception Priority",null,"Buyer Resolution Request",null,"Buyer Action Taken",null,"Seller Resolution Request",null,"Seller Action Taken",null,"State Abbreviations"]
[null,"Entire Shipment",null,"Damaged Product",null,"Cancelled",null,"Barcode Reading Issue",null,"High",null,"Credit Account",null,"Product has been returned",null,"Send Back Product",null,"Credit Applied",null,"AL"]
[null,"Items in Shipment",null,"Data Issue",null,"Closed",null,"Barcode Encoding Issue",null,"Medium",null,"Debit Account",null,"Shipment has been refused",null,"Other",null,"RMA Sent",null,"AK"]
[null,"Other",null,"Data No Product",null,"In Progress",null,"Certificate Issue",null,"Low",null,"Return Product",null,"Other",null,null,null,"Other",null,"AZ"]
[null,null,null,"Packaging and Labeling",null,"In Review",null,"Duplicate EPCIS Events",null,"Other",null,"Send Corrected Data",null,null,null,null,null,null,null,"AR"]
[null,null,null,"Product No Data",null,"Open",null,"EPCIS Event Formatting Issue",null,null,null,"Send Product",null,null,null,null,null,null,null,"CA"]
[null,null,null,"Other",null,"Pending Response",null,"EPCIS Event Timestamp Sequence ",null,null,null,"Other",null,null,null,null,null,null,null,"CO"]
[null,null,null,null,null,"Resolved",null,"Missing Attributes",null,null,null,null,null,null,null,null,null,null,null,"CT"]
[null,null,null,null,null,"Other",null,"Missing EPCIS Events ",null,null,null,null,null,null,null,null,null,null,null,"DE"]
[null,null,null,null,null,null,null,"Unrecognized Buyer GCP and/or GLN",null,null,null,null,null,null,null,null,null,null,null,"FL"]
[null,null,null,null,null,null,null,"Unrecognized Seller GCP and/or GLN",null,null,null,null,null,null,null,null,null,null,null,"GA"]
[null,null,null,null,null,null,null,"Unrecognized Product Information",null,null,null,null,null,null,null,null,null,null,null,"HI"]
[null,null,null,null,null,null,null,"Unrecognized Seller",null,null,null,null,null,null,null,null,null,null,null,"ID"]
[null,null,null,null,null,null,null,"Unrecognized Buyer",null,null,null,null,null,null,null,null,null,null,null,"IL"]
[null,"Where in the process was the exception found",null,null,null,null,null,"Unrecognized P.O. #",null,null,null,null,null,null,null,null,null,null,null,"IN"]
[null,"Receiving",null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,"IA"]
[null,"Outbound Picking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS"]
[null,"Returns Processing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
[null,"Reconciliation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP"]