How To Fix EHPRC_CPM_WORKLIST036 - No substance ID found for record &1; change document not created

SAP Error Message - Details

• Message type: E = Error

• Message class: EHPRC_CPM_WORKLIST - Messages for Worklist Management

• Message number: 036

• Message text: No substance ID found for record &1; change document not created

What causes this issue?

No substance ID was found for the requested record number.

System Response

The creation of the corresponding change document was aborted.
It seems that the specification has been deleted.

How to fix this error?

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

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message EHPRC_CPM_WORKLIST036 - No substance ID found for record &1; change document not created ?

  The SAP error message EHPRC_CPM_WORKLIST036 indicates that the system could not find a substance ID for a specific record, which prevents the creation of a change document. This error typically occurs in the context of SAP's Environment, Health, and Safety (EHS) module, particularly when dealing with chemical substances and their management.
  Cause:
  
  Missing Substance ID: The most common cause of this error is that the substance ID is not defined or is missing in the system for the specified record.
  Incorrect Configuration: There may be issues with the configuration of the substance management settings in SAP.
  Data Inconsistency: There could be inconsistencies in the data, such as missing entries in the relevant tables that link substances to their records.
  Authorization Issues: Sometimes, the user may not have the necessary authorizations to view or create records related to substances.
  
  Solution:
  
  Check Substance ID: Verify that the substance ID exists in the system. You can do this by navigating to the relevant transaction (e.g., CODES or CUP for substance management) and checking if the substance is defined.
  Create or Update Substance: If the substance ID is missing, you may need to create a new substance record or update an existing one to ensure it is correctly defined.
  Review Configuration: Check the configuration settings for substance management in the EHS module to ensure everything is set up correctly.
  Data Consistency Check: Run consistency checks on the relevant tables to identify any missing or inconsistent data entries.
  User Authorizations: Ensure that the user has the necessary authorizations to access and modify substance records. This may involve checking roles and permissions in the user profile.
  Consult Documentation: Refer to SAP documentation or help notes related to the EHS module for additional troubleshooting steps or specific configurations that may be required.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as CODES (for managing substances) and CUP (for chemical product management).
  SAP Notes: Check for any SAP Notes related to this error message, as they may provide specific patches or updates that address known issues.
  Support: If the issue persists after trying the above solutions, consider reaching out to SAP support or your internal SAP support team for further assistance.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.