Search for EDI Correlations

Edit online

About this task

Correlation data, often called correlations, is defined as specific pieces of data that you may need to review in the process of monitoring, tracking, and troubleshooting. These data items are defined by type and value. These type-value pairs are known as name-value pairs, and are a powerful tool you can use to record and search for business process- and document-specific data. The name-value pair records are stored in the correlation table in Sterling B2B Integrator.

Correlation searches rely on name-value pairs that define the specific data items you are trying to locate. These defined name-value pairs are tracking points for business processes and documents. The Correlation search feature offers the following benefits:

  • You can receive the results of search queries more quickly.
  • You can further refine document correlation searches by specifying matching restrictions for the indicated value of a name-value pair.
  • You can further refine correlation searches by specifying a start and end date/time range.
  • You can further refine EDI correlation searches by specifying a start and end date/time range for All levels.

Sterling B2B Integrator enables you to find and correlate an AS3 message with an EDI document or data, group, or transaction through a link in the EDI Correlation Search details, a Document Correlation information link that displays detailed interchange information about AS3 messages.

If you are using AS3, the Document Correlation link enables you to quickly and easily view interchange details about AS3 messages, and to see the correlation between an AS3 message and a corresponding EDI document or data.

To search for AS3 correlations:

Procedure

  1. From Sterling B2B Integrator Administration menu, select Business Process > Advanced Search > EDI Correlation.
  2. In the Search Option area, specify any combination of the following search criteria, as appropriate:
    Field Description Action
    All Level Options
    Location EDI correlations maintained in a specific location. Select one of the following options:
    • Live Tables – Display live (active) EDI correlations.
    • Restored Tables – Display EDI correlations restored from an offline location.
    Search Level Type EDI processing level. Select one of the following options:
    • Interchange – For the search query, display results from the interchange level.
    • Group – For the search query, display results from the group level.
    • Transaction – For the search query, display results from the transaction level.
    Test Mode Mode of the system where documents that contain the EDI correlations were created. Select one of the following options:
    • Any (default)
    • Test
    • Production
    • Information
    • Interchange is a test
    • Syntax only test
    • Echo request
    • Echo response
    Direction Flow of the documents that contain the EDI correlations. Select one of the following options:
    • Any (default)
    • Inbound
    • Outbound
    Sender ID ID for the organization that is sending documents. Type the identifier of the sender.
    Receiver ID ID for the receiving organization. Type the identifier of the receiver.
    Sender ID Qualifier Qualifier used with the Sender ID to define the organization that is sending documents. Type the qualifier of the sender.
    Receiver ID Qualifier Qualifier used with the Receiver ID for the receiving organization. Type the qualifier of the receiver.
    Start Date Documents in progress or completed after the specified start date and time. Using the following formats, type a starting date and time range and select AM or PM:
    • Date – MM/DD/YY
    • Time – HR:MN
    Note: Defaults to a range of the last 24 hours.
    End Date Documents in progress or completed before the specified end date and time. Using the following formats, type an end date and time range and select AM or PM:
    • Date – MM/DD/YY
    • Time – HR:MN
    Note: Defaults to a range of the last 24 hours.
    Interchange Level Options
    Interchange Control Number Sequential number, located at the beginning and end of an interchange, used to verify that all interchanges sent have been received and that the information in the interchange is complete. Type the control number that references the interchange.
    Standard EDI standard you agree to use for a trading partnership. Type the name of the standard.
    Acknowledgement Status Status of an expected acknowledgement at the interchange level. Select one of the following options:
    • Any (default)
    • Waiting
    • Accepted
    • Accepted with Errors
    • Rejected
    • Overdue
    • Received
    • None
    • Manually Accepted
    Compliance Status Status of compliance checking at the interchange level. Select one of the following options:
    • Any (default)
    • OK
    • NOT OK
    Start Date EDI correlations generated or completed for documents at the interchange level after the specific start date and time. This date is compared with the interchange date/time in the data. Using the following formats, type a starting date and time range and select AM or PM:
    • Date – MM/DD/YY
    • Time – HR:MN
    Note: Defaults to a range of the last 24 hours.
    End Date EDI correlations generated or completed for documents at the interchange level before the specific end date and time. This date is compared with the interchange date/time in the data. Using the following formats, type an end date and time range and select AM or PM:
    • Date – MM/DD/YY
    • Time – HR:MN
    Note: Defaults to a range of the last 24 hours.
    Group Level Options
    Functional Group ID ID of the functional group indicated in the document. Type the ID of the functional group.
    Group Control Number Sequential number, used to verify that all groups sent have been received and that the information in the group is complete. Type the control number that references the group.
    Acknowledgement Status Status of an expected acknowledgement at the group level. Select one of the following options:
    • Any (default)
    • Waiting
    • Accepted
    • Accepted with Errors
    • Rejected
    • Overdue
    • None
    • Manually Accepted
    • Partially Accepted
    Compliance Status Status of compliance checking at the functional group level. Select one of the following options:
    • Any (default)
    • OK
    • NOT OK
    Start Date EDI correlations generated or completed for documents at the group level after the specific start date and time. This date is compared with the group date/time in the data. Using the following formats, type a starting date and time range and select AM or PM:
    • Date – MM/DD/YY
    • Time – HR:MN
    Note: Defaults to a range of the last 24 hours.
    End Date EDI correlations generated or completed for documents at the group level before the specific end date and time. This date is compared with the group date/time in the data. Using the following formats, type an end date and time range and select AM or PM:
    • Date – MM/DD/YY
    • Time – HR:MN
    Note: Defaults to a range of the last 24 hours.
    Transaction Level Options
    Transaction Set ID ID of the transaction set indicated in the document. Type the ID of the transaction set.
    Compliance Status Status of compliance checking at the transaction set level. Select one of the following options:
    • Any (default)
    • OK
    • NOT OK
    Message Repair Status Status of message repair (for SWIFT documents only). Select one of the following options:
    • Any
    • Ready for Edit
    • Ready for Resend
    • Aborted
    • Resent
  3. Click Go! to display the EDI correlation records that match your search criteria.
  4. In the EDI Correlation Results page, click info in the Detail column for the AS3 interchange for which you want to view details.
  5. In the EDI Correlation Interchange/Group/Transaction Detail Results page, click info to the right of Document Correlations.
  6. In the Document Correlation Details page, view details about the AS3 message you selected, and about the correlation between the AS3 message and corresponding EDI document or data. The details available include:
    • time stamp
    • scope
    • process ID
    • document name
    • data value