How To Fix FTR_TEX1189 - Some of the selected transactions not found in database

SAP Error Message - Details

• Message type: E = Error

• Message class: FTR_TEX1 - Messages for raw exposures

• Message number: 189

• Message text: Some of the selected transactions not found in database

What causes this issue?

One or more of the transactions selected for processing were not found
in the database.

System Response

Somebody has already processed the transaction(s) and deleted it/them
from the database.

How to fix this error?

Refresh the transaction data again from the selection screen.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FTR_TEX1189 - Some of the selected transactions not found in database ?

  The SAP error message FTR_TEX1189 indicates that some of the selected transactions could not be found in the database. This error typically occurs in the context of financial transactions, particularly in the area of Treasury and Risk Management (TRM) when dealing with financial instruments.
  Causes:
  
  Transaction Deletion: The transactions you are trying to access may have been deleted or archived, making them unavailable in the current database.
  Incorrect Selection Criteria: The selection criteria used to retrieve the transactions may be too restrictive or incorrect, leading to no results being found.
  Data Synchronization Issues: There may be issues with data synchronization between different systems or modules, leading to discrepancies in the available transaction data.
  Authorization Issues: The user may not have the necessary authorizations to view certain transactions, which could lead to them being "invisible" in the selection.
  Database Issues: There could be underlying database issues, such as corruption or connectivity problems, that prevent the retrieval of transaction data.
  
  Solutions:
  
  Check Transaction Status: Verify if the transactions you are trying to access still exist in the system. You can do this by checking the relevant transaction codes or reports.
  Review Selection Criteria: Ensure that the selection criteria you are using to filter transactions are correct and not overly restrictive. Adjust the criteria if necessary.
  Data Consistency Check: Run consistency checks or reports to ensure that the data in the database is accurate and complete. This may involve checking for any inconsistencies or missing data.
  Authorization Check: Confirm that you have the necessary authorizations to view the transactions. If not, contact your system administrator to obtain the required permissions.
  Database Maintenance: If you suspect database issues, consult with your IT department or database administrator to perform maintenance tasks, such as database repair or re-indexing.
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes or patches that may address this specific error message.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes in SAP Treasury and Risk Management, such as FTR_EDIT, FTR_LIST, etc.
  SAP Documentation: Review SAP documentation related to Treasury and Risk Management for more insights into transaction handling and error messages.
  Support Community: Engage with the SAP Community or forums to see if other users have encountered similar issues and what solutions they found effective.
  
  If the problem persists after trying the above solutions, it may be necessary to escalate the issue to SAP support for further assistance.