Work Status Issue in SAP BPC NW 10

[Former Member]

Hello Experts,

We are currently on SAP BPC NW 10 SP12 EPM ADDIN SP19 and I am facing following issue with Work Status:

Currently, I have made Entity (PRC) dimension as Owner Dimension and following user ids as maintained there against some members:

   Following setting is done for Work Status:

Now, when I try to input data by any other id (that is not maintained in OWNER Property of PRC dimension), when the state is submitted, I am able to save data. How is it possible? 

Also, I am able to change the change work status by id maintained for Manager at the submitted state though I have set Controlled by "Owner".

Please help.

Regards,

Apoorva

[former_member190501 · Accepted solution]

Hi,

Only Owner should be able to change as per your setting when it is submitted.

Can you just check following  scenario:

Under Manual Entry maintain Locked for Submitted , approved and locked.

Check whether will it locked or not after changing the status.

Hope it works..

regards,

Raju

[Former Member · Accepted solution]

Hi Raju,

When I choose Locked at Manual Entry for Submitted state and this time I am unable to input data which is correct.

This part is working fine.

But my requirement is not to keep locked at Submitted state. I want only owner to input data at Submitted state which is not working fine.

Also, another important problem, I am facing is, any user is able to change the work status though the user is neither Owner nor Manager.

I am unabe to understand this weird behaviour.Please help.

Regards,

Apoorva

[dinesh_veluru · Accepted solution]

Hi Apoorva,

Please check the work state table entries in UJW_STATCODE for the Submitted and the status code that is setting for the data region in the work status lock table are same for action Submitted.

run the program UJ0_GET_GEN_TABNAME find the workstatus table for your respective model and check status code for the desired data region.

Thanks,

Dinesh.V

[Former Member · Accepted solution]

Hi Dinesh,

I am not able to follow your instructions.

Can you please explain them in detail.

Thanks.

Regards,

Apoorva

[dinesh_veluru · Accepted solution]

Hi Apoorva,

1)There will be one status code for each work state that we define in the work status front end.

Entries are available in table UJW_STATCODE. Sometime it is possible to have 2 work status codes for the same work state.

2) there will be system generated work status lock table available for every model.run the program UJ0_GET_GEN_TABNAME to get the table related to the model

when ever we change the work status from one state(unlocked) to another state(submitted) for a particular data region entries will be captured in the work status table.check whether it is updating the the correct status code for the data region in scope.

Thanks,

Dinesh.V

[Former Member · Accepted solution]

Hi Dinesh,

I am attaching  UJW_STATCODE table screenshot. Here where I can see the work status codes for Work State?

Regards,

Apoorva

[dinesh_veluru · Accepted solution]

Hi Apoorva,

Please click on the button left to "technical settings"

Thanks,

Dinesh.V

[Former Member · Accepted solution]

Hi Dinesh,

Thanks for guiding me..

I checked th codes.. They have been maintained correctly.

So what could be the other reason?

Regards,

Apoorva

[damovand · Accepted solution]

Hello,

Please check and confirm that dynamic tables show the status of submitted.  The locks are saved in table with this table name: /1cpmb/lkws/<appset-prefix>/<app-prefix>.  You can execute program UJ0_GET_GEN_TABNAME to get the names for dynamically generated tables.  Please check note 1529062 for further details.

Regards,

Leila

[former_member190501 · Accepted solution]

Hi,

Can you change some thing in your Entity dimension and process in Offline mode .

Thanks,

Raju

[dinesh_veluru · Accepted solution]

HI,

Please check the second point in the previous comment.

to narrow down the issue can please try below.

1) Please take 2 entities base level members and assign 2 user id's in the owner dimension and have data access profile user1 will have access to entity A and user2 have both entity A & entity B

Entity  Owner

a          user1   

b          user2

2) Disable the work status and enable it again.

3) Now try changing the work state from unlocked to submitted for entity A with user 1

check the work status code in dynamic work status table by run the program UJ0_GET_GEN_TABNAME to get the table related to the model and the status code should be "1" for entity A

4) login with user 2 now try changing the work state for Entity A and he should not be authorised to change the state for entity A

Thanks,

Dinesh.V

[Former Member · Accepted solution]

Hello Dinesh,

My work status started working fine after processing my Entity Dimension agin.

Thanks a lot to you and all who helped me in resolving my issue.

Regards,

Apoorva

[Former Member · Accepted solution]

Hello Again,

I have one more query related to Work Status:

Suppose I have 3 members A, B and C for Owner dimension and A is parent of B and B is parent of C.

Members            Owner           ParentH1

C                        X                    B 
B                        Y                   A

A                        Z                  

So now, if use manual entry and set that only Manager should able to enter data at submitted level, so should X and Y both will able to enter data at C or only Y would able to enter data?

Regards,

Apoorva

[dinesh_veluru · Accepted solution]

Hi Apoorva,

Both X & Y will be able to enter the data.

Thanks,

Dinesh.V

[Former Member · Accepted solution]

Hi Dinesh,

X is owner for C (which is base level member),so he will able to enter data when Owner is allowed to enter data at Submitted state.

At Approved state, Manager is allowed to enter data, so I was expecting both Y and Z should able to enter data but it is not allowing for Z.

Regards,

Apoorva