Question Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20 in Financial Management Q&A

Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 07:02:36 GMT

Hi Folks,

Greetings!!

We have recently upgraded patch level of BPC 10 NW from SP12 to SP20. There are many issues and majority of them got resolved by self and with SAP intervention but one peculiar issue still exists in the system. Work status is behaving different now as compared to previous patch.

We have three work-status maintained in our project which are listed below.

1. Unlocked - Owner

2. Submitted - Manager

3. Locked - Manager

Two issues of work-status exists in the system:

When we try to change Work Status in BPC it works fine till 2015.05 period for single entity but gives us an authorization issue after this period (E.g. 2015.07) in Consolidation Model. Screenshots attached for your reference .
To unlock whole parent with dependents check in is not at all working for any period.

We patched Quality first before getting into production and setting are same as in Production and there is no scope of changes from BPC front end (admin) side as production is working as expected. I would like to know can we do something from BW end.

I hope experts here can help me out to get a resolution at the earliest.

Thanks in advance. Please revert for any further information.

Thanks and Regards,

Mahesh Reddy

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 07:26:07 GMT

Hi,

According to SAP KBA http://service.sap.com/sap/support/notes/1366676 the last patch for BPC 10.0 NW is SP18 (CPMBPC800), even SP19 is not released

What concrete component have you updated?

Tnx & BR

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

former_member186338 — Tue, 28 Jul 2015 07:27:51 GMT

EPM Add-in ?

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 07:34:01 GMT

I thougt also, but


We patched Quality first before getting into production and setting are same as in Production

If they have terminal access to EPM it is possible (never saw, just imagined)... Let's wait for the answer.

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 08:40:38 GMT

Hi All,

Attached EPM addin version installed in the system and CPMBPC components installed in the BW system.

I hope this will answer the above questions.

Thanks

Mahesh

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 09:24:45 GMT

Hi,

Upgrade your CPMBPC to SP15/higher or apply SN 2050042, see also 2081793

EPM Add-In is also a bit too old (see the link in my previous comment), but it is not the case now.

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 09:25:24 GMT

Hello Mahesh,

Upgrade your .Net version from 3.5 to 4.0 and above.

Regards,

Saida Reddy Gogireddy

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 09:34:49 GMT

Hi Saida Reddy,

We have successfully installed above mentioned version in DEV and it is working fine now.

I think nothing to do with .Net version.

My attachments (Workstatus1 and Workstatus2) above clearly states that this is some sort of authorization issue. Security is completely sync with Dev and Prod. If Dev is working fine after patching then ideally Quality should work.

My question is "Is there any locks in work status tables which will cause this type of issue or any changes to be done in security.

Please advise.

Thanks

Mahesh

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Tue, 28 Jul 2015 13:18:08 GMT

Hello Mahesh,

Please go SE16 table and search UJW*, then you will find the table names like below.

Check the table UJW_LCK_DIM then you will get to know is there any dimension locked or not.

Thank you very much.

Best regards,

Saida reddy Gogireddy

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

damovand — Tue, 28 Jul 2015 16:39:11 GMT

Hello,

Have confirmed if you can change work status in BPC web client->library->Input Form? The user has to be the manager to change the work status. The error message says that the user who is trying to change the status is not authorized to do so.

Please confirm if the user can do that from the BPC web client,

Best Regards,

Leila Lappin

Re: Unable to change work status in BPC 10 NW after patch upgrade from 12 to 20

Former Member — Wed, 29 Jul 2015 06:13:11 GMT

Hi All,

Thanks for your valuable inputs. Issue got resolved now as we transported UJW_STATCODE table to TEST from DEV and we are able to change the work status.

Thanks

Mahesh