Skip to Content
author's profile photo Former Member
Former Member

SAP IDM 7.2 on Oracle 12 / Performance Problems HCM to VDS

Hi there,

a few days ago we upgraded a SAP IDM 7.2 DB System on Oracle11 to Oracle12. Now we have a negative perfomance impact on a specifically job from a connected HCM system. It exports data into a VDS

It is apparent on the job log screen in the Indentity Center. The Job is called "Write HCM Employee To SAP Master". The Export from the HCM system is done by the abap program "RPLDAP_EXTRACT_IDM"

This job took about 7000 to 9000 sec under Oracle11. Now in Oracle12 it takes about 60000 to 80000 sec.

I installed the latest patchlevel of SAP IDM 7.2 (Stack 10) with the latest patchlevel for the IDM DB itself.

Does anybody else have this problem?

PS: As i can see in SAP PAM, Oracle 12 is supported ... but it is not mentioned in the IDM 7.2 documentations at all. Also SAP support does not react to a ticket 😔

Greetings

Stefan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 23, 2016 at 11:33 AM

    Hi Stefan,

    I hope your problem got resolved.

    I am just curious, where do you see Oracle 12 is supported?

    In the PAM I see just Oracle 11.2 is supported with IDM 7.2 and 8.0.

    Thanks in advance for your response.

    Regards,

    Ridouan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 11:41 AM

    Hi Stefan,

    a customer of us faces same performance issues with the oracle 12 db. We also opened a ticket, will report back when the problem is fixed.

    @Ridouan It is supported. Look at the online-version of the PAM.

    Regards,

    Aydin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.