Using the Transaction Interface Search

This chapter covers the following topics:

Searching and Viewing Transactions

You can view the inventory material and fulfillment transactions for all organizations or a specific organization that are picked up by the Interface Install Base Lines concurrent program. These transactions are based on the Validation Organization value selected in the concurrent program request parameters.

Access the Interface Install Base Lines concurrent program through the Installed Base Administrator responsibility.

Note: If the Install Base Lines concurrent program is run manually, the User ID will represent the resource who created or modified the transaction. If the concurrent program is run automatically, then the User ID represents the resource who generated the process.

For more information, see Schedule the Interface Install Base Lines Concurrent Program in the Oracle Installed Base Implementation Guide.

To view inventory material and fulfillment transactions picked up by the Interface Install Base Lines concurrent program:

  1. Navigate to the Transaction Interface Search page (Installed Base Administrator > Transaction Interface).

  2. Enter values in any of the following fields to narrow your search:

    • Interface ID

    • Order Number

    • Item Name

    • Transaction Type

    • Material Transaction ID

    • Request ID

  3. Click the Advanced Search button to add the following search parameters:

    • Lot Controlled

    • Serialized

  4. You can also select one of the following four seeded values in the Saved Searches field:

    • Errored-Serial Items

    • Errored-Nonserial Items

    • Errored-Lot Serial Item

    • Errored-Lot Nonserial Item

  5. Click Go.

  6. View the list of transactions.

    the picture is described in the document text

  7. Click the icon in the View Output column to view transaction interface details in a text file.

Viewing Errored Transactions from Installed Base Agent User Responsibility

You can view transaction errors through the Installed Base Agent User responsibility:

  1. Navigate to Installed Base Agent User > Item Instance.

  2. Click Item Instance > Transaction Interface, and the Transaction Interface Search page appears.

  3. Click the Table Diagnostics button to enable the List Search view.

    The Table Diagnostics page appears.

    1. Click the Enable List Search button.

      When the FND_ENABLE_LIST_SEARCH profile option is enabled at the page level, the Filters region appears on the page.

      See Oracle Installed Base System Profile Options, Oracle Installed Base Implementation Guide

    2. Select values in the fields, and click Go.

  4. Select one of the four seeded values to further narrow the results.

    • Errored-Serial Items: Number of errored transactions for serialized items.

    • Errored-Nonserial Items: Number of errored transactions for non-serialized items.

    • Errored-Lot Serial Item: Number of errored transactions for lot and serialized items.

    • Errored-Lot Nonserial Item: Number of count of errored transactions for lot nonserial controlled items.

      the picture is described in the document text

  5. Optionally click the Hide Filters link.

  6. View the transaction errors.

  7. Click the Output icon for the transaction error to view details on the Transaction Interface Output Page.

    the picture is described in the document text

  8. Review the error message information in the Transaction Error Information region to determine the appropriate action to correct the error.

  9. Click the Return to Transaction Interface Search link.

  10. Optionally create a new search by selecting New Search Criteria.

    Note: The existing searches can also be managed by selecting Manage Saved Searches. Existing searches can be set to default or configured to be displayed as a tile at header.

    1. Enter the required fields.

    2. Click the Save button.

    the picture is described in the document text