©

This Help Center is a preview of a future release. The final Help Center will be available on the Validation date.

Aggregation

MAHs that own Russia Health Products Compliance can generate an Aggregation report to capture the serial number of a parent container along with the serial numbers of its contents.

The Aggregation report can be generated only after the Utilisation report is submitted to the Order Management Station (OMS) and the Status of the submitted Utilisation report is Accepted.

Configure the report

The report for a product is generated when its product type is set to the corresponding product group in Product Master Data:

  • Product type as Food Supplement for BAFS

  • Product type as Medical Device for Medical Products

The event triggers (i.e. workflow subscriptions) for the report can be set in Administer for Russia Health Products Compliance. Make sure one of the following event triggers are enabled:

Source Application Event Action Description
Serialized Operations Manager Released Generate OMS Utilisation and Aggregation Reports from Core Integration TraceLink generates Utilisation and Aggregation reports for products that are quality released when they are submitted via core integration or the Web UI, as long as all of the event trigger conditions are met.
Serialized Operations Manager Released Generate OMS Utilisation and Aggregation Reports from Event Exchange Integration TraceLink generates Utilisation and Aggregation reports for products that are quality released when they are submitted via event exchange integration, as long as all of the event trigger conditions are met.

For more information on how to enable the event triggers, see the Administer Help Center.

Russia Health Products Compliance generates the Aggregation report when TraceLink processes a Product Release or Product Release Inbound event and the following conditions are met:

  • The product's MAH, which is identified by the MAH ID for the RU Target Market in Product Master Data, exists in Company Master Data at the company or location level.
  • The products have a Packaging Code Type of GTIN-14 with a Packaging UOM (unit of measure) of Each.
  • In Product Master Data, the serialized item is associated with an Item Code and Lot Number that has a Target Market as Russia.
  • In Product Master Data, the Product Type of the serialized item is Food Supplement for Biologically Active Food Supplements or Medical Devices for Medical Products.
  • The commission event occurred outside Russia. Use the serial number (SN) to look up the lot aggregate and determine the commission location.
  • For the Aggregation report, aggregation occurs before the product is released.

Generate the report

To generate the Aggregation report automatically, enable the appropriate event triggers and ensure that the relevant event trigger conditions are met in Master Data Exchange. When configured, Russia Health Products Compliance generates the Aggregation report automatically when Aggregation occurs in one of the following interfaces:

Use the following Serialized Operations Manager API to trigger the Aggregation report:

Product Release (XML)

Complete the elements required for the report as follows. See the Serialized Operations Manager Core Integration API Guide for more information.

Element Values
cmn:LocationId Specify the company or location performing the product release for the serial numbers matching the specified item code and lot number.
cmn:InternalMaterialCode Specify the internal material number configured in Product Master Data.
cmn:LotNumber Specify the lot number associated with the cmn:InternalMaterialCode.
cmn:QualityControlEntityId Specify the company or location where the product is tested for quality.

Use Serialized Operations Manager to trigger the Aggregation report from the Web UI. See the Serialized Operations Manager Online Help for more information.

  1. In Track & Trace Services (TTS), hover over Modules, and then select Serialized Operations Manager.
  2. Expand the Status Update drop-down and then select Set Product Release Status.
  3. Select the manufacturing location that provisioned the serial numbers from the Show Data From drop-down in the upper right.
  4. Complete the fields required for the report as follows:
    FieldValues
    Item CodeThe Internal Material Number or country drug code from Product Master Data.
    Lot NumberThe number associated with the packaging code.
    Quality Control Entity The company or location where the product is tested for quality.
    Transaction IDs

    The following fields are mandatory when the lot's commissioning location and target market are Russia:

    • Identifier Type – The type of identifier for the transaction.
    • Identifier Value – The value of the identifier for the transaction.
    • Document Date – The date printed on the corresponding transaction document.
  5. Complete any other fields that are required in the UI or that your company uses for a specific purpose.
  6. Select Submit.

    The Set Product Release Status screen displays, and Russia Health Products Compliance begins automatically generating the report from the event trigger.

To generate the Aggregation report manually, use the Russia Health Products Compliance Web UI. This option is useful if a report failed to generate automatically, and the information must still be submitted to the OMS.

  1. Select the Main Menu icon .
  2. Select Russia Health Products Compliance.

    A new tab opens and displays information for the Russia Health Products Compliance app.

  3. Select the Generate Report icon.
  4. Fill in the following fields:
    • Report Type drop-down – Required. Select Aggregation as Report Type.
    • Packaging Code field – Required. The packaging code for the product.
    • Lot Number field – Required. The lot number for the serialized item.

  5. Select Generate.

    The panel closes, and TraceLink begins generating the report. Filter to find the new report.

Report details

Field Description Sourced From OMS Report Element
Report Type Displays as Aggregation. The type of report. Not reported
Status

The status of the report:

  • Generated – The report is generated in TraceLink but not yet submitted to the OMS.
  • Generation Failed – The report failed to generate in TraceLink.
  • Submitted – The report is generated and successfully submitted to the OMS.
  • Submission Failed – The report is generated but was not successfully submitted to the OMS.
  • Failed – The OMS received the report successfully but failed to provide a response.
  • Accepted – The OMS received the report successfully and accepted the information.
  • Partially Accepted – The event has multiple reports, and all of them are successfully submitted to the OMS, but the OMS did not accept all of the reports.
  • Rejected – The OMS received the report successfully but rejected the information.

The status of the report.

Not reported
Date Reported The date and time that the report is generated. The system date and time when the report is generated. Not reported
Participant ID The Taxpayer Identification Number (TIN). The Item Code in Product Master Data. participantId
OMS ID The associated GUID. TraceLink obtains this value from the OMS. Order Management Station Identifier. omsId
Product Group

The product group:

  • Biologically Active Food Supplements

  • Medical Products

The product group. productGroup
Event Type

The event type:

  • Product Release
  • Product Release Inbound
The type of event. Not reported
Field Description Sourced From OMS Report Element
Packaging Code The packaging code for the product. The Packaging Code of the serialized item in the shipment.

Not reported
Product Description The name of the product. The description associated with the Packaging Code in Product Master Data.

Not reported
Quantity The quantity of serial numbers for the Packaging Code and Lot Number. The quantity of serial numbers in the shipment for the Packaging Code and Lot Number.

aggregatedItemsCount

Lot Number The lot number associated with the packaging code used to report the serial numbers. The lot number associated with the Packaging Code in Serialized Operations Manager for this product's serialized items. lotNumber

 
Manufacturing Date The manufacturing date for the serialized items. The manufacturing date associated with the Lot Number in Serialized Operations Manager for this product's serialized items. If the product manufacturing date (production date) does not exist in Product Master Data, the Commissioning Date is considered for the report.

Not reported

 
Expiration Date The expiration date for the serialized items. The expiration date in Serialized Operations Manager for the serial numbers in this lot.

Not reported

Tips

  • Select the Export icon to export the serial numbers for a Packaging Code and Lot Number to a CSV file.
  • Serial Number – The serial numbers at the top level of aggregation in the shipment.
  • Packaging Level – The packaging level of the Serial Number (e.g. Case).
  • Child Quantity – The quantity of child serial numbers aggregated to the parent Serial Number.
  • Aggregation Type – The type of aggregation. Displays as Aggregation.
  • Parent Packaging Capacity – The capacity of the parent packaging code captured from Product Master Data if available. If the capacity of the parent packaging code is not available in Product Master Data, the capacity is calculated by counting the total number of children of a given parent.

Tips

  • Select the Export icon to export the serial numbers and their child information to a CSV file.
  • Select the Action icon to view information about the Serial Number and its children.

    Aggregation Information

    • Parent Serial Number – The parent serial number that the child serial numbers are aggregated to.
    • Packaging Level – The packaging level of the Parent Serial Number (e.g. Case).
    • Child Quantity – The number of child serial numbers aggregated to the Parent Serial Number.

    Tips:

    • The parent serial number also displays in the screen title.
    • Select the file to export the child serial numbers aggregated to the Parent Serial Number as a CSV file.

    Child Serial Numbers

    • Serial Number – The child serial numbers aggregated to the Parent Serial Number.
    • Packaging Level – The packaging level of the Serial Number.
    • Child Quantity – The quantity of child serial numbers aggregated to the Serial Number. Displays a value only if the serial number has a Packaging Level of Case or Pallet.
    • Packaging Code – The packaging code for the product.
    • Product Description - The name of the product.
    • Lot Number – The lot number that the serial number belongs to. Displays a value only if the serial number has a Packaging Level of Each.
    • Expiration Date – The expiration date associated with the Lot Number. Displays a value only if the serial number has a Packaging Level of Each.

Response information when using the message status query service:

  • Status – The status returned by the OMS for the submitted compliance report.
  • Report Name – The name of the compliance report submitted to the OMS.
  • Status Code – The HTTPS code returned by the OMS for the submitted compliance report.
  • Report ID – The unique ID returned by the OMS for the submitted compliance report.
  • Description – The description returned by the OMS for the submitted compliance report.
  • Response Date – The date the response is received from the OMS.

Tips

  • Select the Action icon, and then select Export Report File to export the report file generated for the OMS.
  • Select the Action icon, and then select Export Response File to export the response file received from the OMS.