Skip to Content
Personal Insights
Author's profile photo Christoph Bergemann

OCC (Open Content Connector) / SAP EHS Classic

Introduction

The Blogs:

https://blogs.sap.com/2019/07/23/data-handling-for-the-ehs-open-content-connector/

and

https://blogs.sap.com/2014/11/13/rule-sets-secondary-data-determination/

and

https://blogs.sap.com/2017/07/01/occ-load-options/

seems not to help the EHS community

Questions regarding the use of OCC are asked quite often.

This Blog tries not to provide answers to the questions but to list threads with OCC questions of interest.

To use OCC as an option (in EHS Classic) the following need to be stated:

  1. We have limited documentation in SAP IMG
  2. We have limited documentation on SAP Marketplace
  3. We have some quite good documents in place regarding how to prepare “Load File”
  4. But limited documentation¬† how to do the “specific” set up
    1. E.g. how to enable the needed “RFC” connection
    2. How to install and use the software locally
    3. How to handle “Unicode” related issues
    4. etc

OCC is a good tool for doing regulator updated and if needed you can use it as well to do upload for e.g. “Density” or other data. But it is (like WWI) to a certain extent like: Start the work, crawl, walk and after some time you can run.

The “Load File option with EXCEL” is niece (but tricky to use (e.g. Unicode story etc.)

You should use the most up to date OCC software locally. You should check for SAP errors in this area as well from time to time (check SAP Marketplace for relevant OSS Notes)

Technique

To use the OCC: we need a relevant “User Exit” to do so. Here you have the SAP IMG which tries to guide you. You start with the “hit list” in CG02 (Edit Mode) (Online Mode of use of OCC) and start the job. In most cases: you are on the “safe side” to use the “Online Mode”. This mode has more options than the “offline mode”.

BUT as you block/lock the specifications in CG02 in the “Edit” mode.. you should not do an upoad for to many specifications in one run and you should not try to load for “all properties” in one run.

It is more or less VERY tricky if there is a “load error”… so if your load file was not prepared correct sometimes you will get “useless” data. This is the “nightmare” in using the tool. There are not so many options in the place to “delete” then the useless data and to start again.

Overview of questions

OCC seems now to have more interest as in the past. Here some links discussing the use of OCC. You will find much more like these questions. In many cases: The answers/discussion in the relevant threads will hel you to install and use the tool properly.

The questions can be grouped in:

  • what is the difference of “online” to “offline” mode
  • issues in getting SAP connected to OCC (RFC etc. etc.)
  • Difference regarding “legal content” load and data load a such
  • Topic of “examples” (EXCEL Template, step by step guidelines etc.)
  • Difference “Data Editor” <=> OCC
  • etc.

 

SAP Marketplace

I have done a research in SAP Marketplace. We have many OSS Notes to consider for using SAP EHS OCC tool (October 2022). Please check SAP Marketplace if you have trouble with the OCC tool.

Using as a search term “EHS OCC” i can find roughly 130 threads discussing OCC. If you change your search: you find may be more.

Use of OCC

OCC can be used to load “regulatory content” but as well data like “density” etc.

Depending on the starting postion: the use of OCC can be helpful if you need to support data migration topics.

The only “con” is this:

If you use the “EXCEL” template for doing the load (specification load): It is not easy to understand how to prepare the EXCEL file. This process can take a huge amount of time (e.g. select the correct phrase etc.) as the data model in EHS is such “big” (many properties etc.). Even is you focus on Safety Data Sheet like properties: This is a big work to support.

Therefore: in many cases it is a good idea to “spli” the story. E.g. create first the specifications as such and the do a “step by step” load of the objects using the OCC approach. May be start “simple”. Properties like “Form”, “State of matter”, “Odor” are “simple” properties. Same liek “first Aid” proeprties etc.

Properties in the area of “tox”, “Ecotox” are complex properties.

You should split as well your load between properties of type “composition/Spec. Listing”. To do the load you have first to prepare the objects in the system

Data regarding “Dangerous Good” should be any how seperated from the load.

Examples of threads

 

https://answers.sap.com/questions/13475669/occ-configuration-ehs.html

https://answers.sap.com/questions/8925647/ehs-occ.html

https://answers.sap.com/questions/13712315/real-substance-status-occ-ehs.html

https://answers.sap.com/questions/11731011/registry-entry-not-found-occ-ehs.html

https://answers.sap.com/questions/66885/how-to-upload-xml-file-un-regulation-updates-in-sa.html

https://answers.sap.com/questions/13658726/sap-occ-ehs-risk-classification-dg-data.html

https://answers.sap.com/questions/6543969/ehs-data-upload-from-content-providers-through-ehs.html

https://answers.sap.com/questions/13737956/rfc-error-system-failure-ehs-occ-content-service-1.html

https://answers.sap.com/questions/13559498/ehs-occ-import-substance-nature.html

https://answers.sap.com/questions/64132/sap-ehs-occ-removing-nol.html

https://answers.sap.com/questions/8996734/sap-ehs-occ-question.html

https://answers.sap.com/questions/13666148/how-to-mark-a-checkbox-using-sap-occ-ehs.html

https://answers.sap.com/questions/13646281/sap-occ-ehss-dg-data.html

https://answers.sap.com/questions/688295/ehs-occ-xml-upload.html

https://answers.sap.com/questions/7151480/ehs-occ-open-content-connector–application-error.html

https://answers.sap.com/questions/9353915/difference-between-sap-ehs-expert-server-and-sap-o.html

https://answers.sap.com/questions/13737927/rfc-error-system-failure-ehs-occ-content-service.html

https://answers.sap.com/questions/474439/what-is-the-use-of-application-log-level-in-ehs-oc.html

https://answers.sap.com/questions/186559/occ-data-upload-and-occ-connection.html

https://answers.sap.com/questions/386302/use-of-occ.html

https://answers.sap.com/questions/276384/occ-error-on-rfc.html

https://answers.sap.com/questions/13649265/occ-data-load-template-for-spec-listing-property.html

https://answers.sap.com/questions/13741624/no-match-occ-ehs-regulatory-content-service.html

https://answers.sap.com/questions/186559/occ-data-upload-and-occ-connection.html

https://answers.sap.com/questions/276384/occ-error-on-rfc.html

https://answers.sap.com/questions/13712315/real-substance-status-occ-ehs.html

https://answers.sap.com/questions/386302/use-of-occ.html

https://answers.sap.com/questions/13658726/sap-occ-ehs-risk-classification-dg-data.html

https://answers.sap.com/questions/12398565/occ-capabilities.html

https://answers.sap.com/questions/13017348/inheritance-functionaliy-of-sap-occ.html

https://answers.sap.com/questions/12628359/serc-occ-license.html

https://answers.sap.com/questions/12392919/occ-to-load-specification.html

https://answers.sap.com/questions/13559498/ehs-occ-import-substance-nature.html

https://answers.sap.com/questions/11731011/registry-entry-not-found-occ-ehs.html

https://answers.sap.com/questions/11621380/initial-serc-load-with-occ.html

https://answers.sap.com/questions/8925647/ehs-occ.html

https://answers.sap.com/questions/13737956/rfc-error-system-failure-ehs-occ-content-service-1.html

https://answers.sap.com/questions/495887/is-there-a-document-listing-step-by-step-instructi.html

https://answers.sap.com/questions/13646281/sap-occ-ehss-dg-data.html

https://answers.sap.com/questions/232333/occ-specification-composition-upload-error.html

https://answers.sap.com/questions/11733108/occ-error—state-of-matter-not-found.html

https://answers.sap.com/questions/239097/composition-load-issue-using-occ-data-editor-softw.html

https://answers.sap.com/questions/12338262/occ-dg-set-up-issue.html

https://answers.sap.com/questions/11847406/different-steps-in-loading-data-from-occ.html

https://answers.sap.com/questions/13693341/decimal-separator-issue-in-dat-in-file-occ-tool.html

https://answers.sap.com/questions/8996734/sap-ehs-occ-question.html

https://answers.sap.com/questions/588936/issue-with-occ-for-cas-number.html

https://answers.sap.com/questions/13658542/error-in-occ-tool-after-upgrading-gui-version-770.html

https://answers.sap.com/questions/64132/sap-ehs-occ-removing-nol.html

https://answers.sap.com/questions/13649265/occ-data-load-template-for-spec-listing-property.html

https://answers.sap.com/questions/12947152/packing-requirements-data-importing-issues-for-un.html

https://answers.sap.com/questions/9353915/difference-between-sap-ehs-expert-server-and-sap-o.html

https://answers.sap.com/questions/12501561/how-to-connect-occ-to-sap-for-online-data-load-spe.html

https://answers.sap.com/questions/12899902/any-standard-functionality-exists-to-update-the-sp.html

https://answers.sap.com/questions/7151480/ehs-occ-open-content-connector–application-error.html

https://answers.sap.com/questions/11968099/occ-rule-run-for-product-safety-error-message.html

https://answers.sap.com/questions/6543969/ehs-data-upload-from-content-providers-through-ehs.html

https://answers.sap.com/questions/9972613/regulatory-content–occ.html

https://answers.sap.com/questions/12578781/how-occ-group-helps-in-determining-salts-of-drug-p.html

https://answers.sap.com/questions/136802/want-to-connect-msdgen-tool-legacy-data-to-sap-ehs.html

https://answers.sap.com/questions/62919/bulk-upload-of-identifier.html

https://answers.sap.com/questions/390705/specification-load.html

https://answers.sap.com/questions/11814098/data-editor-tool.html

https://answers.sap.com/questions/11713110/upload-value-assignments-to-substances.html

https://answers.sap.com/questions/12103405/create-mass-specifications-and-update-value-assign.html

https://answers.sap.com/questions/11975201/data-editor.html

https://answers.sap.com/questions/66885/how-to-upload-xml-file-un-regulation-updates-in-sa.html

https://answers.sap.com/questions/9067035/how-to-manage-the-regulatory-data-import-into-spec.html

https://answers.sap.com/questions/11847412/data-editor-for-mass-update.html

https://answers.sap.com/questions/439471/can-i-upload-the-phrases-in-format-other-than-dat-.html

https://answers.sap.com/questions/13016471/mass-chang-of-authorization-group-in-specification.html

https://answers.sap.com/questions/364675/how-to-delete-data-for-one-value-assignment-for-mu.html

https://answers.sap.com/questions/12980031/specification-header-status-mass-change.html

https://answers.sap.com/questions/651723/sap-ehs-spec-master-data-change.html

https://answers.sap.com/questions/148013/i-would-like-to-delete-the-identifier-from-the-lis.html

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.