Activate Live Cache Lock in PA

[Former Member]

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

[srinivas_krishnamoorthy · Accepted solution]

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)

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

Dear Dogboy,

I went through the link.

Is there any solution to my scenario.I feel that "live cache locking " can solve the issue inoreder to access multiple single entries.

Do you think this change can generate some other issues or lock ? Is there any harm to the data ?

Regards,

AB

[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