2.6 File Inquiry

This topic provides information on how to view and verify the details of uploaded files.

  1. From Home screen, click Interconnect. Under Interconnect, click File Exchange.
  2. Under File Exchange, click File Inquiry.
    The File Inquiry screen displays. For more information on fields, refer to the field description table.

    Table 2-24 File Inquiry - Field Description

    Field Description
    File Reference & Date Time Displays the unique identifier assigned to the uploaded file and .the date and time when the file was uploaded or processed.
    Source System Code & Name Indicates the source system code and name from which the file is uploaded.
    Target System Code & Name Displays the target system code and name for which the file is uploaded.
    File Name Displays the name of the uploaded file, including its format and version details.
    Format Displays the file type or structure (for example, CSV, XML, or JSON).
    Transaction Refers to the Target transaction associated with the uploaded file.
    #Records Displays the total number of records contained in the uploaded file.
    Status Indicates the processing status of the file (for example, Success, Failed, or In Progress).
  3. On File Inquiry screen, click Search icon.
    The File Inquiry - Search screen is displayed.

    Figure 2-27 File Inquiry - Search



  4. On File Inquiry - Search screen, specify the Search Filter to fetch the required inquiry details.

    For more information on fields, refer to the field description table.

    Table 2-25 File Inquiry - Search – Field Description

    Field Description
    Source System Select the source system from the drop-down list.
    Target System Select the target system from the drop-down list.
    File Name Specify the name of the file that will be processed or generated.
    File Status Select the file status from the drop-down list.
    File Reference Specify the unique identifier or name for the file associated with the transaction or integration
    Upload Date Select the upload date from the drop-down list.
    The available options are:
    • Today
    • Last 3 days
    • Last 7 days
    • Last 15 days
    • Date Range
    From Date Specify the from date.

    This field is enabled only when the Upload Date is selected as Date Range.

    To Date Specify the to date.

    This field is enabled only when the Upload Date is selected as Date Range.

  5. Click the hyperlink for each record to view its file details.
    The View File Details - File Journey screen displays.

    Figure 2-28 View File Details - File Journey



    Review the file processing steps:

    1. File Received - Indicates that the file has been successfully received by the system.
    2. Verified - Indicates that the uploaded file has been verified by the system.
    3. Sent to Target - Indicates that the file has been sent to the target system for processing.
    4. Processed - Indicates that the file has been successfully processed by the target system.
  6. Click the Record Details tab to specify the required details.
    The View File Details - Record Details screen displays.

    Figure 2-29 View File Details - Record Details



    For more information on fields, refer to the field description table.

    Table 2-26 View File Details - Record Details - Field Description

    Field Description
    Record Reference Displays the unique identifier assigned to the record.
    Dynamic Columns Columns are dynamic based on the configuration in the target. If selected to show on inquiry, those columns will appear here.
    Record Status Displays the current status of the record.
    Processing Status Indicates the outcome of the record processing.
  7. On the selected file details, click the View File Details hyperlink to view the file information.
    The File Details - Download File screen displays.

    Figure 2-30 File Details - Download File



  8. Click Download File to download the file.