Reference Agreement Lines When You Import Sales Orders
Reference an agreement line on an order line when you import a sales order through REST API or FBDI. Use this feature when you need to apply a different price for the same item. For example, apply a different price according to date or to the physical location where you sell the item.
Before Update 25C, if you specified a sales agreement when you imported an order line, then Oracle Order Management used the item and the unit of measure on the order line to determine which agreement line to use. If the set up for the agreement in the Contracts work area had more than one agreement line for that item and unit of measure, and if the effective dates for those agreement lines overlapped each other, then Order Management couldn't determine which agreement line to use on the order line and displayed an error.
Starting with Update 25C, you can use the new Sales Agreement Line Identifier attribute or Sales Agreement Line Number attribute on the order line to specify the agreement line that you want to use on the order line.
Assume you sell frozen food and you need to adjust price according to the warehouse on the order line. You need to keep that food frozen during transit, so the longer the transit time, the higher the price. To meet this need, go to the Contracts work area, then create a sales agreement and give it a number, such as 123675. Add two agreement lines and specify different pricing for each one:
|
Attribute |
Agreement Line 1 |
Agreement Line 2 |
|
Number |
Mochi 1 |
Mochi 2 |
|
Type |
Product |
Product |
|
Name |
Mochi Ice Cream |
Mochi Ice Cream |
|
UOM |
Each |
Each |
|
Adjustment Type |
Markup Percent |
Markup Percent |
|
Adjustment |
5 |
10 |
|
Start Date |
6/1/25 |
7/1/25 |
|
End Date |
6/1/25 |
7/1/25 |
Next, reference the agreement lines when you import the order line. For example, use these values on the DOO_ORDER_LINES_ALL_INT worksheet of SourceSalesOrderImportTemplate when you import through FBDI:
|
Source Transaction Line Number |
Product Number |
Product Description |
Ordered UOM |
Sales Agreement Number |
Sales Agreement Line Number |
|
1 |
MOCHI_123 |
Mochi Ice Cream |
Each |
123675 |
Mochi 1 |
|
2 |
MOCHI_123 |
Mochi Ice Cream |
Each |
123675 |
Mochi 2 |
Or if you use the Sales Orders for Order Hub REST API:
Line 1
"SourceTransactionLineNumber" : "1",
"ProductNumber" : " MOCHI_123",
"ProductDescription" : "Mochi Ice Cream",
"OrderedUOM" : "Each",
"AgreementNumber" : "123675",
"AgreementLineNumber" : "Mochi 1",
Line 2
"SourceTransactionLineNumber" : "2",
"ProductNumber" : " MOCHI_123",
"ProductDescription" : "Mochi Ice Cream",
"OrderedUOM" : "Each",
"AgreementNumber" : "123675",
"AgreementLineNumber" : "Mochi 2",
Realize this benefit:
- Get more flexibility in how you import and use agreement lines to price order lines.
Steps to Enable
You don't need to do anything to enable this feature.
Tips And Considerations
You can import through the SalesOrdersforOrderHub REST API, SalesOrdersforOrderHubRequests REST API, or FBDI with REST API. See Guidelines for Using REST API, Web Services, and FBDI to Integrate Order Management.
You can reference an agreement line on an order line or an unreferenced return line.
Key Resources
Access Requirements
Users who are assigned a configured job role that contains these privileges can access this feature:
- Create Sales Order Requests Using REST Services (FOM_SALES_ORDER_REQUEST_REST_POST)
- Create Sales Orders Using REST Services (FOM_SALES_ORDER_REST_POST)
- Update Sales Order Requests Using REST Services (FOM_SALES_ORDER_REQUEST_REST_PATCH)
- Update Sales Orders Using REST Services (FOM_SALES_ORDER_REST_PATCH)
These privileges were available prior to this update.