Skip to Content

EPMWorkStatus does not work properly

Dear all,

I'm facing an issue with EPMWorkStatus formula.

I'm running SAP BPC 10.1 NW, my EPM add-in version is 23, installed on Excel 2013.

Basically the formula works only with the first parameter ( 0 = Status ), but it retrieves an empty value for the other ones (1=User and 2=Time).

It is strange because I am able to see the Status (such as unlocked or approved) but, as soon as I change the parameter, I cannot see any results.

Have someone of you experienced the same issue? Would you suggest any solution?

Thank you so much for your feedback

Best regards

Andrea

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 19, 2015 at 05:44 PM

    Hello Andrea

    Could be related to a missing record in UJW_STATCODE

    See: 1862768 - EPMWorkStatus function displays wrong status

    Thanks

    Marc

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      the first screenshot is this one:

      As you can see the result of the formula = Under Approval. Under Approval is not the default work status

      The second screenshot is this one:

      As you can see the only difference is Parameter = 1, but the result of the formula is "".

      Honestly I don't understand why..

      thanks for your reply

      Best regards

      Francesco

      pastedImage_2.png (20.8 kB)
      pastedImage_4.png (19.7 kB)
  • avatar image
    Former Member
    Apr 20, 2016 at 07:41 AM

    Hi Andrea/Nico,

    This is a program error in BPC.

    Please refer to the SAP NOTE which suggests to apply note or upgrade the support package.

    2286302 - EPM function EPMWorkstatus parameters 1 and 2 does not return last modification by user and last modification date,time

    Thanks,

    Varsha

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Varsha. This is exactly gives me the solution. An issue that got in in SP9, but will be fixed in SP10 thus or with this note.

      Regards

      Nico

  • Oct 21, 2015 at 03:00 PM

    If you have status "DEFAULT WORK STATE" then user and time will be blank...

    But for non default status I am always able to see the user and time...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded