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

Activate Live Cache Lock in PA

Hi,

Can somebody explain to me the Locking Logic of "Activate Live Cache Lock in PA" in SAP APO v5.0? Will flagging this selection prevent the job from cancelling even though someone is using the PA?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 02, 2008 at 06:04 PM

    If the intention is to prevent online users from interfering with batch jobs, you can try to write a small development object using function modules of ENQUEUE_READ and TH_DELETE_USER, There are many other ways as well to prevent online users from editing data while batch job is ON however a development route will be the most effective in my experience.(eg. adding Parameter ID in batch for users with /SAPAPO/SDP94_D_MODE that will force the users to be in display mode)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      In my system , we have aggregated locking in our PA.

      As a result of this multiple single entries are not taken into consideration. So we are getting many errors "Locked by user"

      For exp: If 1 user is in change mode for 1 sales org in selection profile , then another user who has 2 sales org in his selection profile , is getting an error "locked by user 1" and likewise entering into display mode.

      Will using live cache locking solve the issue or is there any performance issue associated with it or do we have a danger to data ?

      Look forward to your reply.

      Regards.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2012 at 11:43 AM

    Dear 'abinashp12' and Ann,

    Can somebody explain to me the Locking Logic of "Activate Live Cache Lock in PA" in SAP APO v5.0?

    Read SAP online help to understand the choices available to you.

    http://help.sap.com/saphelp_scm70/helpdata/EN/77/d4103d2669752de10000000a114084/frameset.htm

    Will flagging this selection prevent the job from cancelling even though someone is using the PA?

    No. There will always be locks of some kind when data is being changed, this is inherent to the design of any database, including the types of databases manged within Planning areas. 'Livecache lock' is a special kind of lock. Deselecting this checkbox will only result in a different type of lock instead.

    Best regards,

    DB49

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      AB,

      Sorry, but I couldn't possibly answer without knowing in detail how your MPOS's, PA's, PB's, Macros, and Data Views have been structured.

      Your best bet would be to test this scenario in your Dev system or Sandbox.

      Best Regards,

      DB49

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.