Attribute Mapping for Oracle Sales Quote Line Integration

Overview

Oracle CPQ 21A also introduces a new Attribute Mapping page that allows administrators to customize their Oracle Sales integration without the use of XSL. This page provides a user-friendly interface to map attributes. It supports text based searches to find attributes and drag and drop functionality to add attributes. CPQ attributes are grouped by Transaction and Transaction Line levels. Transaction attributes are displayed first and have a blue sidebar. Transaction Line attributes are displayed after Transaction attributes and have a lavender sidebar.

The Attribute Mapping page displays the CPQ attributes on the left side of the page and the Oracle Sales attributes on the right side. The mapped attributes are displayed in the middle. Icons identify the attribute type and the attribute variable name is displayed when hovering over an attribute name. Administrators can add new attribute mappings and edit or delete existing attribute mappings.

Predefined Oracle Sales Quote Lines Integration Items

Oracle CPQ 21A provides new customers with predefined Oracle Sales integrations. Existing customers can import a migration package to implement the predefined integration content.

The following table shows the predefined Oracle Sales predefined attribute mappings. An asterisk (*) precedes new Sales Reference Application attributes.

ATTRIBUTES		CPQ ATTRIBUTES
Attribute Name	Variable Name	Attribute Name	Variable Name	Type	Description
Order Header Id	OrderHeaderId	OSC Transaction ID	oRCL_OSC_TransactionID_t	Text	The ID generated by Oracle Sales to identify this transaction.
External Line Number	ExternalOrderLineNumber	Document Number	_document_number	Text	Unique sub-document number to be used as an identifier in a Commerce Process
Inventory Organization ID	InventoryOrgId	OSC Inventory Org ID	oRCL_OSC_InventoryOrgID_l	Text	The inventory organization in OSC used for sales products.
Inventory Item ID	InventoryItemId	*OSC Inventory Item ID	oRCL_OSC_InventoryItemID_l	Text	The inventory item id of the sales product in OSC.
Revenue ID	RevnId	*Opportunity Revenue Line ID	oRCL_OSC_RevnId_l	Text	The ID generated by OSC to identify the revenue line.
Line Status	LineStatusCode	Status	status_l	Menu	The status of this line.
Item Type	TypeCode	*Line Type	lineType_l	Menu	The type of a transaction line whether it represents a model or a part.
Quantity	Quantity	Quantity	requestedQuantity_l	Integer	Quantity of associated line being requested. Can be user entered or set logically.
UOM	UOMCode	Unit of Measure	requestedUnitOfMeasure_l	Menu	The unit of measure of the item requested by the customer (e.g. "Cases").
Line Price Type	PriceTypeCode	Price Type	priceType_l	Menu	Indicates whether the amount on this line is charged once or periodically.
Line Price Period	PricePeriodCode	Period	pricePeriod_l	Menu	The period of service purchased at this price.
Line Currency	CurrencyCode	Currencyt	currency_t	Menu	The currency used to price and invoice this transaction.
Price	Price	Price (Net)	netPrice_l	Currency	The price paid by the customer for the item.
Line Amount	Amount	Amount (Net)	netAmount_l	Currency	The extended list amount minus any discounts for this line.
Line Contract Value	ContractValue	Contract Value (Net)	contractValue_l	Currency	The total contract value of this line including all one-time and recurring charges.
Line Discount	DiscountPercentage	*Discount %	discountPercent_l	Float	The percentage of the Contract Value (List) that is discounted off of the transaction line.
Line Contract Periods	ContractPeriods	Contracted Periods	contractedPeriods_l	Integer	Number of periods the customer has contracted to receive the item.
Line Contract Start Date	ContractStartDate	Contract Start Date	contractStartDate_l	Date	Date that the customer starts to receive the service.
Line Contract End Date	ContractEndDate	Contract End Date	contractEndDate_l	Date	Date that the customer stops to receive the service.
Line Request Date	RequestDate	Request Date	requestDate_l	Date	The date on which the user requests that fulfillment occur for this transaction line.
Line Win Loss Status	WinLossStatusCode	OSC Status	oRCL_OSC_Status_l	Text	The determining status of whether the line represents a won or a lost sale. This can be used in Deal Management analysis.
Line Order Date	OrderDate	Order Date	orderDate_l	Date	The date and time the order was placed for fulfillment.
Order Number	OrderNumber	*Order Number	oRCL_OSC_OrderNumber_l	Text	The order number assigned by the external Order Management and ERP system.

Administration

Edit Attribute Mapping for Oracle Sales Quote Line Integration

Related Topics

Search My Oracle Support for more information focused on Oracle CPQ to Oracle Sales integrations and documents to assist with your CPQ-Oracle Sales integration implementation.

See Also