Load custom pricing for an Oracle Learning offering

Load custom pricing for an existing course offering using the OfferingCustomPricing object and OfferingCustomPricingComponent component.

To verify that the self-paced activity successfully loaded, go to My Client Groups > Learning and Development > Learning Catalog.

Pricing component types

For the PricingComponentType attribute of OfferingCustomPricingComponent, use a value from the ORA_WLF_PRICING_TYPE lookup type. These values are delivered:

Value	Meaning
ORA_LIST_PRICE	List price
ORA_LIST_PRICE_ADJ	List price adjustment

1. Create Offering Custom Pricing Objects

Use the OfferingCustomPricing object and its user key. Here's an example:

METADATA|OfferingCustomPricing|EffectiveStartDate|PricingRuleNumber|CurrencyCode|OfferingNumber
MERGE|OfferingCustomPricing|2018/02/04|PR-201802041723-HDL|USD|OFFERING-201802041712-HDL

2. Create Offering Custom Pricing Components

Use the OfferingCustomPricingComponent component and its user keys. Here's an example that creates two components:

METADATA|OfferingCustomPricingComponent|EffectiveStartDate|PricingComponentNumber|PricingComponentType|Price|IncludeInSelfServicePricing|PricingRuleId|PricingRuleNumber
MERGE|OfferingCustomPricingComponent|2018/02/04|PC-201802041724-HDL|ORA_LIST_PRICE|100|N|PR-201802041723-HDL
MERGE|OfferingCustomPricingComponent|2018/02/04|PC-201802041725-HDL|ORA_LIST_PRICE_ADJ|200|N||PR-201802041723-HDL