Skip to Content

Using QueryByTypeCodeAndPropertyIDAndPropertyValue in SalesPriceList BO

Hello All,

I have a requirement to fetch the Customer Group Specific Price List from the SalesPriceLsit BO but there is no query in the BO which gives you all data.

I am using QueryByTypeCodeAndPropertyIDAndPropertyValue query which needs to be written in a proper way which I got to know from Query Service documentation.

Even after structuring the query as required I am not able to get data. Whenever the query is executed I get an error saying "(PRC_SALES_PRICE_LIST, ROOT) A technical error (Mandatory initialization missing) occurred: PRC_ESF_CND_MAINT 502. Report an incident."

Following is the code that I have written:

By any chance if anyone have worked on it and can help me?

Thanks & Regards,

Meghna

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Aug 06, 2015 at 06:46 AM

    Hi Meghna,

    We have got the records returns for base price list via using below example:

    Please do not use the PriceSpecificationPropertyValuation1-4. I think it also apply for customer specfic price.

    Best Regards,

    Qiang


    12345678.jpg (247.9 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2015 at 08:13 AM

    No one to help 😔

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27, 2015 at 11:30 AM

    Hi Meghna,

    Did you try this query in repository explorer?

    This seems very complex query and as per error some mandatory initialization is missing

    I guess each valuation have their own identifier, which you also have to pass as parameter.

    Give a try in Repository explorer with all required parameters.

    Regard

    Sunil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2015 at 03:43 AM

    Hi Meghna,

    We also got the same requirement (search customer group specific price list by customer ID)

    and after tested our code. this error appears

    "A technical error (No business configuration to process request) occurred: PRC_ESF_CND_MAINT 109. Report an incident."

    Could you give any suggestion on this problem?

    Thank you,

    Mullika

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 05, 2015 at 08:02 AM

    Hi Meghna,

    does the query work without parameters? I would suggest you start with the query and see if it works. Then you start adding parameters one by one and check the result. Maybe one of the parameters is not set.

    It would help to isolate the problem.

    Best Regards,
    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2015 at 09:54 PM

    Hi there!

    Any progress?

    The problem may be on the SalesPriceList BO. The query don't work even by the Repository Explorer interface ( )

    I'm trying to query by code and it doesn't build =/. The SDK says that the parameters does not exist.

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Alexandre,

      I've checked in the backend: This query requires a special initialization, which is not documented.

      Please raise an incident to the component "Sales Price Specification" (AP-PMD-SPS) to get some knowledge about this initialization.

      Sorry,

      Horst