Troubleshoot a problem

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.

After updating MDLP credentials for a Russia Account Number, the Web UI might continue to show the status of the credentials as Verified if the Configure Published Service Settings screen was not submitted after deleting the row with the original information.

If MDLP credentials still have a status of Verified after updating, delete the row with the credentials, submit Configure Published Service Settings screen, and reenter the information. See Set up TraceLink applications for more information.

Because aggregation and disaggregation happen frequently, the 911 - Unit Pack, 913 - Unit Extract, and 914 - Unit Append reports are hidden by default on the Compliance Reports screen in the Russia Compliance Web UI. This improves performance and provides better visibility into other report types.

Owners must search for these report types to view their details.

The appropriate workflows must be enabled in Company Administration to automatically generate Russia reports. Reports generate automatically in response to certain TraceLink events and conditions. See Generate compliance reports for a list of supported Russia Compliance report types, and select the name of a report to view the events and conditions that generate it.

If there was an issue generating the report automatically, Owners can generate it on demand using the Serialized Operations Manager Web UI. All report types can be generated on demand in Serialized Operations Manager, except for the 701 - Accept report in response to a 614 - Foreign Import Notification. Russia Compliance Owners generate this report type on demand using the Russia Compliance Web UI.

A report Status of Rejected, Partial, or Failed indicates that a government system found a problem with the report:

• The Rejected Status indicates that MDLP received the report successfully, but rejected all of the information.
• The Partial Status indicates that MDLP received the report successfully, but accepted only some of the information.
• The Failed Status indicates that the OMS received the report successfully, but rejected the information. This status is applicable to only the OMS Domestic Utilisation and OMS Foreign Utilisation reports, which TraceLink submits to the OMS and the OMS then submits to MDLP.

MDLP and the OMS might reject a report if the data provided has issues (e.g. a serial number is invalid) or if reports are submitted in the incorrect order. For example, a 913 - Unit Extract report, which captures the disaggregation of serial numbers from their parent containers, might fail because the serial numbers in the report have not previously been reported as aggregated in a 911 - Unit Pack or 915 - Multi Pack report.

If a report fails with a Status of Rejected or Partial, use the Response Information in the report to determine the cause of the issue, and regenerate the report on demand in Serialized Operations Manager if necessary. All report types can be generated on demand in Serialized Operations Manager, except for the 701 - Accept report in response to a 614 - Foreign Import Notification. Russia Compliance Owners generate this report type on demand using the Russia Compliance Web UI.

If a 701 - Accept report fails to generate for a 614 - Foreign Import Notification, Owners can generate the report on demand using the Russia Compliance Web UI.

To generate the 701 - Accept report for a 614 - Foreign Import Notification on demand

1. Hover over Modules, and then select Russia Compliance.
2. Select Compliance Reports.

   A table displays with all available compliance reports and notifications, other than the 911 - Unit Pack, 913 - Unit Extract, and 914 - Unit Append reports, which Owners must search for.

3. Search for the 614 - Foreign Import Notification with the 701 - Accept report that failed to generate.
4. Select the Reprocess icon in the Actions column for the 614 - Foreign Import Notification.
5. Specify how TraceLink determines the serial numbers to include in the 701 - Accept report:

   • Select Generate 701 - Accept Report Without Validation to report exactly the same serial numbers included in the 614 - Foreign Import Notification, regardless of whether the serial numbers exist in TraceLink.

     or

   • Leave Generate 701 - Accept Report Without Validation unselected to report only serial numbers included in the 614 - Foreign Import Notification that also have an Item Status of Shipped in TraceLink.
6. Select Submit.

   TraceLink begins generating the 701 - Accept report, and the report displays in the table when it is ready.

   If Generate 701 - Accept Report Without Validation was not selected, TraceLink requests information from MDLP about the serial numbers included in the 614 - Foreign Import Notification via the outbound 210 - Query Kiz Info message and inbound 211 - Kiz Info message before verifying that the each-level serial numbers in the packaging hierarchy have an Item Status of Shipped in TraceLink.

A crypto code order might fail if there is an issue with the serialization information provided (e.g. the GTIN packaging code is invalid or a serial number is longer than 13 digits).

To troubleshoot:

1. Hover over Modules, and then select Compliance - Russia Crypto Codes.
2. Select the Download Errors icon for the failed order to download the errors.txt file, which contains errors raised by CRPT and TraceLink. If necessary, contact the organization in the Provided By column to correct the issue.

Companies that receive serial numbers from an external system (e.g. a CMO that receives serial numbers from their MAH, or MAH that uses an external serial number manager) do not see an Order ID in the Russia Crypto Codes application because the external system is responsible for requesting crypto codes from the CRPT OMS.

Crypto codes must be enabled in the serial number template assigned to the location.

Check the serial number templates that the company uses for products distributed in Russia and confirm that:

• Crypto codes are enabled.
• The template is assigned to the appropriate locations.
  Russia requires each domestic manufacturing location to have its own unique GTIN packaging code, so the company might use many serial number templates for the same product, each of which is assigned to only one location.
• The MAH Assignee on the OMS Credentials tab in Company Administration is also listed as the MAH ID in Product Master Data.

See the Serial Number Manager Online Help for more information.