Question & Answer
Question
How do you purge data from YPM_PRICELIST_LINE table in IBM Sterling Order Management?
Cause
YPM_PRICELIST_LINE is a master table. Purges are allowed only for transaction tables.
Answer
YPM_PRICELIST_LINE table is a Master table. Sterling Order Management product provides purge agents only for the transaction data related tables.
If you still wish to either remove the data or do not want to use the data from this table then you can make use of the below mentioned options:
- Deactivate the old price lists which are not needed anymore.
- Make use of managePriceListLine API with delete operation.
[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.4;9.3;9.2.1;9.2;9.1;9.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21977652