Searching for EBICS transactions

An EBICS license must be installed in order for EBICS transactions to be available for searching.

To search for EBICS transactions:

  1. From the Basic Search page, click EBICS Search in the upper right corner.
  2. On the EBICS Search page, specify any combination of the following search criteria, as appropriate. Leave any field blank to search for files that match all possible values of that field.
    Field Description Action
    Search Location The location of the tables you wish to search. Select from:
    • Live Tables (default) - to view active data
    • Restore Tables - to view archived business process data that has been restored.
    Note: EBICS activity, such as Transaction, Message, and associated EBICS events, is archived and can be searched from the restore tables or live tables. Sterling File Gateway activity is purged, not archived, and purged data cannot be searched.
    Bank ID (Host ID) Identifier for the bank. Type the Host ID or select from the list.
    Transaction ID Identifier for a specific transaction. Type the Transaction ID.
    Transaction Status The status of the transactions.

    Select from the following:

    • Open
    • Received
    • Rejected
    • Pending
    User ID Identifier for a specific user. Type the User ID.
    Partner ID Identifier for a specific partner. Type the Partner ID.
    Order ID Identifier for a specific order. Type the Order ID.
    Protocol Version Identifies the protocol version Select one of the following protocol versions:
    • H000
    • H003
    • H004
    Order Type Type of order. Select the order type from the dropdown list.
    Order Status

    (Applies only when Order Type = FUL)

    		 Status of the order. Select from the following:
    • Open
    • Received
    • Rejected
    • Pending
    • Cancelled
    • VEU
    File Format Format of file. Select from the list of available file formats that have been transferred.
    Date (From) Documents in progress or completed after the specified start date. Click on the calendar icon to select the date to begin the search.
    Time (From) Documents in progress or completed after the specified start time. Select the hour, in 24-hour format, and minutes to begin the search.
    Date (To) Documents in progress or completed before the specified end date. Click on the calendar icon to select the date to end the search.
    Time (To) Documents in progress or completed before the specified end time. Select the hour, in 24-hour format, and minutes to end the search.
  3. Click Find to initiate the search.

    The Transaction Summary tab opens and displays results matching all of your criteria. A maximum of 1000 files is displayed. The following default information is provided for each EBICS transaction:

    • Order Status (only displayed for Order Type = FUL)
    • Transaction Status
    • Transaction ID
    • Partner ID
    • User ID
    • Order ID
    • Protocol Version
    • Order
    • File Format
    • Last Activity
    • Mailbox Messages (click to view list of mailbox messages and links to arrived files in a popup window.)

    Right-click on a column heading to change the sort order, or to show or hide different columns.

    The following columns are available but hidden by default:

    • Bank ID (Host ID)
    • Message ID (FUL only, link to Arrived File)
    • Order Attribute
    • Security Medium
    • Direction
    • Order Data Type
    • Transaction Phase
    • Total Segments
    • Transaction Start
    • Transaction End
    • Original Transaction ID
    • Process Status
    • System ID
    • Segment Received
    • Recovery Counter
    • Recovery Point
  4. Under the column for Mailbox Messages, a graphic icon is presented. When you click on the icon, a popup window is displayed with the list of mailbox messages.
    • Mailbox Message ID
    • Document ID
    • Document Type
    • Arrived File Search
    If links to Arrived Files are present, click those links to navigate to the Arrived File details.
    Note: Search displays information with respect to Arrived Files only. Therefore, if the search parameter is Protocol=EBICS, only files for which the Arrived File protocol is EBICS, such as files resulting from an FUL transaction, are displayed. For an FDL transaction, the Arrived File protocol is not EBICS and the transaction will not be displayed under the search results with search parameter Protocol=EBICS.
  5. From the Transaction Summary tab, click any row to display the Transaction Events pane and Message Details tab for the transaction in that row.
  6. The Transaction Events pane displays the following information:
    • Event Code (Event codes in a red font denote error conditions.)
    • Time
    • Description

    Right-click on a column heading to change the sort order, or to show or hide different columns. The Counter column is available, but hidden by default.

    In the Description column, you can click the hyperlinks (underlined in blue font) to view other information such as unpackaged output documents, dataflows, order parameters, routing channel templates, or workflows (business process details).

  7. The Message Details tab displays the following information:
    • Message Type
    • Message Status
    • Segment Number
    • Data Flow
    • Timestamp

    Right-click on a column heading to change the sort order, or to show or hide different columns.

    You can click any available hyperlinks to view other information.