1. HCM Data Loading Business Objects
  2. Examples of Loading the Custom Pricing of an Oracle Learning Offering

Examples of Loading the Custom Pricing of an Oracle Learning Offering

Here's how you can load custom pricing for offerings to Oracle Learning using user keys.

1. Create Offering Custom Pricing Objects

This example OfferingCustomPricing.dat file identifies the OfferingCustomPricing object by its user key.

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

2. Create Offering Custom Pricing Components

This example OfferingCustomPricing.dat file loads two OfferingCustomPricingComponent components using their user keys.

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