Adjust Price According to FOB Attribute
Set up pricing so it adjusts price according to the FOB attribute on the order line.
The example in this topic describes one way to set up pricing. It is intended only as a general outline that you can use to learn about different ways to set up Pricing. You will need to use different procedures, different steps, different values, and different objects for your implementation, depending on your business requirements.
FOB (free on board) indicates you won't charge your customer for shipping costs you incur to get them item from your warehouse or factory to the FOB location.
Assume.
-
The customer is Computer Service and Rentals.
-
The item is the AS54888.
-
Your factory is in
Culver City
, a suburb of Los Angeles, but you ship from the Port of Los Angeles. -
You don't charge for shipping you incur to get the AS54888 from
Culver City
to the Port of Los Angeles. -
You do charge for the cost of shipping from the Port of Los Angeles to the ship-to site.
-
You offer a $100 discount when you ship the AS54888 out of the Port of Los Angeles.
-
You already added the AS54888 to the Corporate Segment Price List, and set the base price to 2500.
Summary of the Set Up
-
Examine the current behavior.
-
Modify the lookup.
-
Set up the service mapping.
-
Create the pricing basis.
-
Create lookup type.
-
Modify the matrix class.
-
Modify the price list.
-
Test your set up.
Examine the Current Behavior
-
Sign into Order Management with administrative privileges.
-
Go to the Order Management work area, then create a sales order.
Attribute
Value
Customer
Computer Service and Rentals
Business Unit
Vision Operations
-
Add the AS54888 item to an order line, then notice the value of Your Price on the order line is 2500.
-
Click Shipment Details > Shipping, change the value in the FOB attribute, then click Save.
Order Management reprices the order when you click Save.
-
Click Lines, then notice the value of Your Price on the order line is still 2500.
-
Notice the sales order number. For this example, assume its 508670.
Modify the Lookup
-
In the Setup and Maintenance work area, click Search, search for, then open Manage FOB Lookup.
-
On the Manage FOB Lookup page, in the Standard Lookup Type area, select the row.
Attribute
Value
Lookup Type
FOB
Meaning
Valid FOB Codes
-
In the Lookup Codes area, Click Actions > New, set the values, then click Save and Close.
Attribute
Value
Lookup Code
FOB_LA
Enabled
Contains a check mark.
Meaning
Port of Los Angeles
Description
Shipping charges start at the Port of Los Angeles.
-
Propagate your lookup across Oracle applications.
-
In the Setup and Maintenance work area, go to the task.
-
Offering: Supply Chain Planning
-
Functional Area: Supply Chain Planning Configuration
-
Task: Collect Planning Data
-
-
On the page that displays, verify that Process Name is Collection Job Set, then set the values.
Attribute
Value
Source System
GPR
Collection Type
Net Change
-
On the Reference Data tab, move Order Orchestration Reference Objects from the Reference Entities list to the Selected Entities list.
You use Order Orchestration Reference Objects for any data entity you need for Order Management, such as free on board, return reason, invoicing and accounting rules, payment terms, document categories, sales credit types, receipt methods, shipment priority, payment method, freight charge terms, and so on.
Note that the Supply Planning Data tab includes the Sales Orders supply entity. You use this entity for each sales order you create or import, and scheduling details for these sales orders.
-
Click Submit.
-
Wait for one hour for the collection process to finish.
For details, see Overview of Data Collections for Supply Chain Planning.
-
Set Up the Service Mapping
-
Sign out, then sign into Oracle Pricing with administrative privileges.
-
Go to the Pricing Administration work area, then click Tasks > Manage Service Mappings.
-
On the Manage Service Mappings page, open the Sales service mapping.
-
Create the source for the order header.
-
On the Edit Service Mappings page, click Sources, then click the row.
Attribute
Value
Source
OrderHeader
-
In the Details area, on the Entity Mappings tab, click the row.
Attribute
Value
Entity
Line
Type
View Object
View Object
Fline
Query Type
Unique Identifier
Query Attribute
HeaderId
-
In the Line Details area, on the Attribute Mappings tab, click Actions > Add Row, then set the values.
Attribute
Value
Attribute
FOB Code
View Object Attribute
FobPointCode
-
In the Line Details area, click Sources, click Actions > Add Row, then set the values.
Attribute
Value
Attribute
FOB Code
View Object Attribute
FobPointCode
-
-
Create the source for the order line.
-
In the Sources list, click the row.
Attribute
Value
Source
OrderLine
-
In the Details area, on the Entity Mappings tab, click the row.
Attribute
Value
Entity
Line
Type
View Object
View Object
Fline
Query Type
Unique Identifier
Query Attribute
HeaderId
-
In the Line Details area, on the Attribute Mappings tab, click Actions > Add Row, then set the values.
Attribute
Value
Attribute
FOB Code
View Object Attribute
FobPointCode
-
Click Save and Close.
-
Create the Pricing Basis
-
Sign out of Pricing, then sign into Order Management with administrative privileges.
-
In the Setup and Maintenance work area, go to the task.
-
Offering: Order Management
-
Functional Area: Pricing
-
Task: Manage Pricing Bases
-
-
On the Manage Pricing Bases page, click Actions > Create, set the values, then click Save and Close.
Attribute
Value
Name
Adjustment Basis for Base Price List
Usage
Adjustment Basis
Price Element
Base List Price
Active
Contains a check mark.
Create the Lookup Type
-
Go to the Order Management work area, then open the sales order you created earlier. In this example, open order 508670.
-
On the order line, set the FOB attribute to Port of Los Angeles, then click Save.
-
Use SQL to query the Oracle database.
SELECT DHA.source_order_number, DFLA.FOB_Point_Code FROM doo_headers_all DHA, doo_lines_all DLA , doo_fulfill_lines_all DFLA WHERE DHA.header_id = DLA.header_id AND DLA.Header_id = DFLA.header_ID AND DLA.Line_id = DFLA.line_ID AND DHA.Source_order_number = '&Source_Order_Number';
For details, see Use SQL to Query Order Management Data.
Replace Source_Order_Number with your order number. For example:
AND DHA.Source_order_number = 508670;
The query gets the numeric value that the database stores in the FOB_Point_Code attribute of table doo_fulfill_lines_all. You need this value because the price adjustment matrix uses the internal ID for the FOB attribute.
Assume the query returns the value 11251.
-
In the Setup and Maintenance work area, click Tasks > Search, then search for and open Manage Standard Lookups.
-
On the Manage Standard Lookups page, click Actions > New, set values, then click Save.
Attribute
Adjustment Basis for Base Price List
Name
FOB_MSC_CODE
Meaning
FOB MSC Codes
Description
FOB MSC Codes for price adjustment
Module
Application Common
-
In the Lookup Codes area, click Actions > New, set the values, then click Save and Close.
Attribute
Adjustment Basis for Base Price List
Lookup Code
11251
Enabled
Contains a check mark.
Meaning
Port of Los Angeles
Modify the Matrix Class
-
Sign out, then sign into Pricing.
-
Click Tasks > Manage Matrix Classes.
-
On the Manage Matrix Classes page, open the Price List Charge Adjustment class.
-
In the Condition Columns area, click Actions > Add Row, set values, then click Save and Close.
Attribute
Value
Name
FOB
Source Code Name
FOB
Comparison
=
Compare to Attribute
Line.FOBCode
Domain
Set Domain Type to Lookup
Set Lookup to FOB_MSC_CODE
Modify the Price List
-
Click Tasks > Manage Price Lists.
-
On the Manage Price Lists page, search for, then open price list Corporate Segment Price List.
-
On the Edit Price List page, search for the AS54888 item.
-
In the Charge area, verify values.
Attribute
Adjustment Basis for Base Price List
Base Price
2500
Allow Manual Adjustment
Contains a check mark.
-
Click Create Charge > Create Price Adjustment Matrix.
-
In the Create Price Adjustment Matrix dialog, add a check mark to FOB, then click OK.
-
In the Price Adjustments area, click Actions > Add Row, set values, then click Save and Close.
Attribute
Value
FOB
Port of Los Angeles
Adjustment Type
Discount Amount
Adjustment Amount
100
Adjustment Basis
Adjustment Basis for Base Price List
Recall that this is the basis you created earlier in this topic. It instructs Pricing to apply the adjustment to the Base List Price.
Test Your Set Up
-
Sign out, then sign into Order Management.
-
Go to the Order Management work area, then open the sales order you created earlier.
In this example, open order 508670.
-
On the order line, set the FOB attribute to any value other than Port of Los Angeles, then click Save.
-
Notice the value of Your Price on the order line is 2500.
-
Set the FOB attribute to Port of Los Angeles, then click Save.
-
Verify that the value of Your Price on the order line is 2400, which is Base Price of 2500 minus discount of 100.