Rule set is creating additional instances

[ashish25bp]

Hello Experts

We are updating SERC data after 2.5 years. We have uploaded the content data for PS and DG. Now we are at a stage of running the expert rules. There are several 'multiple rules' files configured earlier for GHS rules, Hazardous component rules, Notification Rules , composition etc. Now while executing Expert rues we have some questions and request expert's help on that.

1) While running a multiple rule set e.g GHS_MR ,the system is creating additional instances for the same regulation and validity area. I understand that if the earlier data is manually changed the data origin turns to 'EH&S' and thus the earlier data is not overwritten but a new instances is created. However,I want to know how to overcome this situation where the execution of rule set is also necessary and also do not want to have repeated instances for same validity area.

OR

2) Normally after the Regulatory data updates (in our case it is after 2.5 yrs) what is the process adopted generally in terms of rule sets execution.

Are all rule sets run?

Are these rule sets executed on pure & Real sub as well after updates?

Is it better to run the individual rule or running combined multiple rule?

Thanks In advance

Ashish

[christiaan_deroost]

Hello Ashish,

For your Question1, there is actually an option... though it'll only be usefull for future changes. That's because this option has to be used before doing the manual change to the data.

What you can do is enable the option 'retain data origin/provider' before doing the manual change:

You'll find this option when on a hitlist, then access the top menu: Utilities --> Settings --> Data Provider.

If you do the manual change with this option enabled, the instance will keep its origin from the ruleset. The next time the ruleset runs, it'll be able to overwrite it again... .

Regards, Christiaan

[former_member541723]

Ashish,

Option 1: Radical Idea. Turn OFF the Expert Rule Parameter for EXPERT_RES_BY_SRSID_OWNID_FLG

Option 2: The Rule behavior is controlled the EXPERT_COMMIT_MODE Parameter. Note that I have had unexpected results with Change and Replace modes. From the IMG Documentation:

Activities

1. In Customizing for

Basic Data and Tools, call the IMG activity Manage User Exits.

2. Create a new user exit of the user exit category

SUB_SEDACA. To do so, use the reference modules as a copy template.

3. Choose

Parameters and Values. The following environment parameters must be set up for the reference modules C1E5_SUB_EXPERT_EVALUATE and C1R3_SUB_EXPERT_EVALUATE:

• EXPERT_COMMIT_MODE

Specifies the backup mode for secondary data determination by the EH&S Expert.

If you enter the value

I, the SAP system creates the new data records that were determined by the EH&S Expert without changing other data records.

If you enter the value

D, the SAP system deletes all the existing data records and creates the newly determined data. If the EXPERT_RES_BY_SRSID_OWNID_FLG parameter is set, then only those data records are deleted that were determined during previous runs of the EH&S Expert. Using the data origin (parameter EXPERT_WRITE_SOURCE_ID) and the data provider (parameter EXPERT_WRITE_OWNER), the SAP system recognizes which data was determined previously by the EH&S Expert.

Note:

You can determine the address number of the data provider in Customizing for Basic Data and Tools in the IMG activity Specify Authorization Groups. To do this, call the input help for the Data prov. field in the IMG activity. You will find the value you require in the Addr. no. field. The address number is not displayed in address management in the Product Safety component.

If you enter the value

C, the SAP system resets the active indicator for the newest of the data records and deletes all other existing ones. The number of data records to be deactivated can be derived from the parameter

EXPERT_NUM_OF_DEACT_VALUATIONS. The data records that were newly determined by the EH&S Expert are also created. If the EXPERT_RES_BY_SRSID_OWNID_FLG parameter is set, then only those data records are deleted that were determined during previous runs of the EH&S Expert. This helps you prevent data records from being deleted inadvertently. Using the data origin (parameter EXPERT_WRITE_SOURCE_ID) and the data provider (parameter EXPERT_WRITE_OWNER), the SAP system recognizes which data was determined previously by the EH&S Expert.

If you enter the value

R, the SAP system deletes all the existing data records for which new data values were determined and creates the newly determined data. Header data for specifications with the exception of the identifiers is not deleted in this mode.

If the

EXPERT_RES_BY_SRSID_OWNID_FLG parameter is set, then only those data records are deleted that were determined during previous runs of the EH&S Expert. Using the data origin (parameter EXPERT_WRITE_SOURCE_ID) and the data provider (parameter EXPERT_WRITE_OWNER), the SAP system recognizes which data was determined previously by the EH&S Expert.

[Ralph_P]

Hi Ashish,

Question 1: There is no workaround. If the instances created by a rule set are manually changed, the rule set cannot see them anymore as being created by itself and it will create new instances. Therefore never edit an instance created by a rule set.

Question 2: With every SERC update you get a list of those LIST_SUBs or UN-numbers that have been changed with that particular update. Via a where-used search you can easily determine which of your product might be affected by the update and then execute the rule sts on those.

Ralph

[christoph_bergemann]

Dear Ashish

you need to understand the link between "content", "Rule set" etc.

Therefore. YOu should get a "SErc" dcoumentation with some guideline (what is to be done, step by step)

But overall: this is related to a "big" term called "Management of Change" process. Before you execute a ruleset (or multiple ones) you should ask your self:

1.) is the ruleset to be used on LIST_SUB/PURE_SUB Level?

2.) is it to be used in "REAL_SUB" level?

What is the ruleset really "doing"? Onyl by "blindly" using the ruleset you will not gain something. E.g. as we talk here in many cases of a "combination" of change of content with a change of ruleset (in some cases: ruleset was corrected/optimzed etc.)

So a may be good strategy is: Check first; can i list the effected objects for which the rulesets should be executed? Second: is there the need to add "primary" data (new one) on e.g. REAL_SU level before you execute the ruleset etc.?

May be take a short look here:

https://blogs.sap.com/2016/10/22/chemical-regulations-challenge/

https://blogs.sap.com/2016/04/30/about-content-providing-a-challenge-for-provider-and-company-who-ne...

https://blogs.sap.com/2013/11/24/how-to-deal-with-legalregulatory-changes-using-sap-ehs-management/

These blogs are discussing some "types" of changes on "very high"/high" level

Any companies should have a "guideline" document in place considering changes (e.g. new / change ruleset available) and in many cases. you need to understand the difference before you "do something" (and if you do something: check first ! in Quality System)

C.B.

[former_member408313]

Hi Ashish

1) Please check your EHS Expert Version and master data and validity for any issue

OR

2) Are all rule sets run? It depends on the version of the rules which are changed over the year. Business needs to make decision here.

Are these rule sets executed on pure & Real sub as well after updates? Yes, For GHS Rules you need to run the rule both as Real sub and Pure Substance level.

Is it better to run the individual rule or running combined multiple rule? You need to test individual rule so that you can check the output individually and then can run all the rules in sequence as part of multi -rules.

Thanks and Regards

Jayakumar