【无标题】

API Process_Price_List Gives Error "This Price List Belongs To Source System QP and Pricing Transaction Entity ORDFUL and cannot be updated or deleted by others." (Doc ID 2644788.1)

正在上传…重新上传取消To Bottom

---

In this Document Goal Solution References APPLIES TO: Oracle Advanced Pricing - Version 12 and later Information in this document applies to any platform. QP_PRICE_LIST_PUB.Process_Price_List Phrase - PRICING TRANSACTION ENTITY PTE GOAL QP_PRICE_LIST_PUB.Process_Price_List gives error   This price list belongs to Source System QP and Pricing Transaction Entity ORDFUL and cannot be updated or deleted by others. How can one resolve this error?   SOLUTION One needs to set the value for the following profiles:  1. QP: Pricing Transaction Entity = Order Fulfillment  2. QP: Source System Code = Oracle Pricing This can be set at site or responsibility level as follows: A) Set Profile Options at Site Level (only) Please set the following profile options at site before running QPPLXMP5.sql as username = apps.  1. QP: Pricing Transaction Entity = Order Fulfillment  2. QP: Source System Code = Oracle Pricing Responsibility: System Administrator Navigate to: Profiles > System Query profile, set value at Site level. Save. Please log into sql as username = apps, and run the following queries to confirm needed values are returned.    select FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY') from dual;       -- should return: ORDFUL    select FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE') from dual;       -- should return: QP or B) Another approach is to assign the profile values at responsibility level. Query one could run to get the responsibility_id value. One will be prompted to enter the responsibility's name.    select responsibility_id RESP_ID , responsibility_name RESP_NAME   from fnd_responsibility_tl    where upper(responsibility_name) like upper('&1')   and language = userenv('lang'); Query one could run to get the user id. One will be prompted to enter the username.    select user_id, user_name from fnd_user where upper(user_name) = upper('&Username');    For example, say you have a Pricing responsibility (responsibility_id = 12345) which has the following profiles set:   QP: Pricing Transaction Entity = Order Fulfillment   QP: Source System Code = Oracle Pricing. One could then add the following lines of code to set value at responsibility level.    BEGIN    MO_GLOBAL.INIT('ONT');    MO_GLOBAL.SET_POLICY_CONTEXT('S', 204);    fnd_global.apps_initialize(9999,12345,661); -- pass in user_id, responsibility_id, and application_id ...    Therefore a price list created with the above profile settings will have: Pricing Transaction Entity = ORDFUL Source System Code = QP And one would need to have profiles set as such to do an update or delete to this price list or any price list with those values.