Troubleshooting

General

Opening an exported CSV file in Excel can result in a loss of data or improper formatting (e.g. not recognizing application identifiers, dropping leading zeroes, scientific notation conversion).

  1. Open a blank Excel workbook.
  2. Select Data > From Text.
  3. Choose the CSV file in the Import Text File window.
  4. Select Import:
    1. Select the Delimited option, and then select Next.
    2. Deselect the default Tab option, and then either:
      • Select the Comma option, and then select Next.

        or

      • Select the Period option, and then select Next.
    3. Select all columns and the Text option, then select Finish.
  5. In the Import Data window, select the New worksheet option and then select OK.
  6. Select File > Save As and make sure Save as type is set to Text (Tab delimited).
  7. Select Save to save the active sheet.

    The file displays the correct data and formatting.

Reports

The appropriate workflows must be enabled in Company Administration to automatically generate Saudi Arabia reports. Reports generate automatically in response to certain TraceLink events and conditions.

If there is an issue generating the report automatically, Owners can generate it manually using the Serialized Operations Manager Web UI.

See the events that generate each report

Report Type Event Conditions
Supply (Foreign) Product Status Set to Released
  • The Owner of the Saudi Arabia Compliance application is listed as the product's MAH in Product Master Data.
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The commission location is a country other than Saudi Arabia.
Received Product Released Event
  • The Owner of the Saudi Arabia Compliance application is listed as the product's MAH in Product Master Data.
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The commission location is a country other than Saudi Arabia.
Supply (In-Country) Product Status Set to Released
  • The Owner of the Saudi Arabia Compliance application is listed as the product's MAH in Product Master Data.
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The commission location is Saudi Arabia.
Received Product Released Event
  • The Owner of the Saudi Arabia Compliance application is listed as the product's MAH in Product Master Data.
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The commission location is Saudi Arabia.
Deactivate Product Destroyed
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
ESM Product Destroyed
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
Product Decommissioned
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
ESM Product Decommissioned
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
Report Type Event Conditions
Sales shipments
Dispatch (Foreign Sale) Product Shipped - Foreign Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The shipment has a Sale Type of Sale - Export.
ESM Product Shipped - Foreign Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The shipment has a Sale Type of Sale - Export.
PTS Upload (Foreign Sale) Product Shipped - Export Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The shipment has a Sale Type of Sale - Export.
ESM Product Shipped - Export Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The shipment has a Sale Type of Sale - Export.
Import (Purchase) and Accept (Import Purchase) Receipt Message Processed Successfully - Import Purchase
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The Receipt Type is Purchase - Import.
  • Saudi Arabia Compliance first submits the Import (Purchase) report to the DTTS, which the DTTS accepts only if the Pharmaceutical Manufacturer outside of Saudi Arabia registered the products as importable. If the DTTS rejects the Import (Purchase) report with an error code of 21025 (i.e. the Pharmaceutical Manufacturer registered the products as non-importable), Saudi Arabia Compliance then submits the Accept (Import Purchase) report instead.
ESM Product Received - Import Purchase
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The Receipt Type is Purchase - Import.
  • Saudi Arabia Compliance first submits the Import (Purchase) report to the DTTS, which the DTTS accepts only if the Pharmaceutical Manufacturer outside of Saudi Arabia registered the products as importable. If the DTTS rejects the Import (Purchase) report with an error code of 21025 (i.e. the Pharmaceutical Manufacturer registered the products as non-importable), Saudi Arabia Compliance then submits the Accept (Import Purchase) report instead.
Dispatch Cancel (Voided Foreign Shipment) Void Shipment - Foreign
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.

Only sales shipments can be voided.
ESM Void Shipment - Foreign
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.

Only sales shipments can be voided.
Transfer shipments
Dispatch (Foreign Transfer) Product Shipped - Foreign Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The shipment has a Sale Type of Transfer - Export.
ESM Product Shipped - Foreign Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The shipment has a Sale Type of Transfer - Export.
Import (Transfer) and Accept (Import Transfer) Receipt Message Processed Successfully - Import Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The Receipt Type is Transfer - Import.
  • Saudi Arabia Compliance first submits the Import (Transfer) report to the DTTS, which the DTTS accepts only if the Pharmaceutical Manufacturer outside of Saudi Arabia registered the products as importable. If the DTTS rejects the Import (Transfer) report with an error code of 21025 (i.e. the Pharmaceutical Manufacturer registered the products as non-importable), Saudi Arabia Compliance then submits the Accept (Import Transfer) report instead.
ESM Product Received - Import Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship From Country Code is not Saudi Arabia.
  • The Ship To Country Code is Saudi Arabia.
  • The Receipt Type is Transfer - Import.
  • Saudi Arabia Compliance first submits the Import (Transfer) report to the DTTS, which the DTTS accepts only if the Pharmaceutical Manufacturer outside of Saudi Arabia registered the products as importable. If the DTTS rejects the Import (Transfer) report with an error code of 21025 (i.e. the Pharmaceutical Manufacturer registered the products as non-importable), Saudi Arabia Compliance then submits the Accept (Import Transfer) report instead.
Report Type Event Conditions
Sales shipments
Dispatch (In-Country Sale) Product Shipped - In-Country Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The shipment has a Sale Type of Sale - In Country.
ESM Product Shipped - In-Country Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The shipment has a Sale Type of Sale - In Country.
PTS Upload (In-Country Sale) Product Shipped - In-Country Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The shipment has a Sale Type of Sale - In Country.
ESM Product Shipped - In-Country Sale
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The shipment has a Sale Type of Sale - In Country.
Accept (In-Country Purchase) Receipt Message Processed Successfully - In-Country Purchase
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The receipt has a Receipt Type of Purchase - In Country.
ESM Product Received - In-Country Purchase
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The receipt has a Receipt Type of Purchase - In Country.
Dispatch Cancel (Voided In-Country Shipment) Void Shipment - In Country
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.

Only sales shipments can be voided.
ESM Void Shipment - In Country
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.

Only sales shipments can be voided.
Transfer shipments
Dispatch (In-Country Transfer) Product Shipped - In-Country Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The shipment has a Sale Type of Transfer - In Country.
ESM Product Shipped - In-Country Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The shipment has a Sale Type of Transfer - In Country.
Accept (In-Country Transfer) Receipt Message Processed Successfully - In-Country Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The receipt has a Receipt Type of Transfer - In Country.
ESM Product Received - In-Country Transfer
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Ship To and Ship From Country Codes are both Saudi Arabia.
  • The receipt has a Receipt Type of Transfer - In Country.
Return shipments
Return (In-Country) Product Shipped - Return
  • The products have a Packaging Code Type of GTIN-14.
  • The products have a Target Market of Saudi Arabia.
  • The Sale Type is Return - In Country.
  • The Ship From Country Code is Saudi Arabia.
  • The Ship to Country Code is Saudi Arabia.
  • The serial numbers were previously reported in a Supply or Import report, or were included in a receipt with a Receipt Type of Purchase - In Country.
ESM Product Shipped - Return
  • The products have a Packaging Code Type of GTIN-14.
  • The products have a Target Market of Saudi Arabia.
  • The Sale Type is Return - In Country.
  • The Ship From Country Code is Saudi Arabia.
  • The Ship to Country Code is Saudi Arabia.
  • The serial numbers were previously reported in a Supply or Import report, or were included in a receipt with a Receipt Type of Purchase - In Country.
PTS Upload (In-Country Return) Product Shipped - Return
  • The products have a Packaging Code Type of GTIN-14.
  • The products have a Target Market of Saudi Arabia.
  • The Sale Type is Return - In Country.
  • The Ship From Country Code is Saudi Arabia.
  • The Ship to Country Code is Saudi Arabia.
  • The serial numbers were previously reported in a Supply or Import report, or were included in a receipt with a Receipt Type of Purchase - In Country.
ESM Product Shipped - Return
  • The products have a Packaging Code Type of GTIN-14.
  • The products have a Target Market of Saudi Arabia.
  • The Sale Type is Return - In Country.
  • The Ship From Country Code is Saudi Arabia.
  • The Ship to Country Code is Saudi Arabia.
  • The serial numbers were previously reported in a Supply or Import report, or were included in a receipt with a Receipt Type of Purchase - In Country.
Return receipts
Dispatch Cancel (In-Country Return Receipt) Product Received - In-Country Return
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Receipt Type is In-Country Return.
ESM Product Received - In-Country Return
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM of Each.
  • The products have a Target Market of Saudi Arabia.
  • The Receipt Type is In-Country Return.
Report Type Event Conditions
PTS Download --

There is no event workflow to generate the PTS Download report.

The PTS Download report generates automatically when TraceLink retrieves serialization data from the PTS. TraceLink checks the PTS once per hour for serialization data associated with any of the GLNs specified on the DTTS Credentials tab in Company Administration for the Saudi Arabia Compliance app and downloads the data, if available.

A report Status of Failed indicates that there was a problem submitting the report to the DTTS or PTS . This can occur if:

  • The DTTS or PTS was unavailable when the report was sent (e.g. because of planned system downtime). In this case, wait for the DTTS or PTS to become available and resend the report.
  • The DTTS or PTS could not authenticate the credentials for the location. Ensure that the correct credentials are entered in Company Administration, on the Configure Published Service Settings screen for the Owner's Saudi Arabia Compliance application. See the Company Administration Online Help for more information.
    Each location performing actions that generate compliance reports must register credentials with the SFDA.

When the Saudi Arabia Compliance app retrieves serialization data from the PTS and the PTS Download Received event workflow is enabled, TraceLink attempts to create an Unsubmitted Receipt in Serialized Operations Manager with the serial numbers in the downloaded file. Owners can manually retry this process if the Unsubmitted Receipt could not be created successfully.

To retry processing, on the Compliance Reports screen, select the Reprocess icon to the right of the PTS Download report for the file that failed to process, and then select Submit in the confirmation dialog. TraceLink retries downloading the file from the PTS, if necessary, and processes the information to register and aggregate the serial numbers, creating the Unsubmitted Receipt in Serialized Operations Manager with the serial numbers in the Pending Receipt state. The receipt can then be submitted to generate an Import or Accept report.

TraceLink automatically checks the PTS once per hour for serialization data associated with any of the GLNs specified on the DTTS Credentials tab in Company Administration for the Saudi Arabia Compliance app and downloads the data, if available. After downloading the serialization data, the Saudi Arabia Compliance app generates a PTS Download report as a record of the download.