1. Implementing Order Management
  2. Import Return Orders

Import Return Orders

Import a source order that returns an item.

Here's how you do it.

Import a source order that doesn't reference the original sales order.

Use a technology to import the return.

  • Order import template. The template is SourceSalesOrderImportTemplate.xlsm. Many of the return attributes are on tab DOO_ORDER_LINES_ALL_INT.

  • Web service in Oracle Application Development Framework (ADF).

  • Web service in Oracle Service-Oriented Architecture (SOA).

Required Attributes

Here are the attributes that your import must include.

Attribute

Description

Attribute that identifies the item.

Select from the group. For example, Product Number.

Ordered Quantity

Make sure quantity is greater than 0 for a new source order. You can use 0 for a revise order.

If your set up.

  • Allows decimals. Make sure the number of digits after the decimal point doesn't exceed the maximum number of digits allowed according to profile Quantity Decimal Precision. For details, see Control Decimal Precision.

  • Doesn't allow decimals. Make sure the source order doesn't include decimal values.

Ordered UOM

Make sure the unit of measure is appropriate for the item.

For example, Quart is appropriate for a liquid, but Amperage isn't because amperage measures electrical current.

If the item returns a coverage, then make sure the unit of measure is appropriate for the covered item.

Return Type

Identifies type of order line. Use a value from the Return Order Line Types lookup.

If you use the order import template, then use the Transaction Line Type Code attribute in column AB of tab DOO_ORDER_LINES_ALL_INT.

Return Location

If Return Type is Return for credit and return the item, then the import requires Return Location.

If you use the order import template, then use the Requested Fulfillment Organization Identifier attribute in column N of tab DOO_ORDER_LINES_ALL_INT.

Return Reason

If you use the order import template, then use the Return Reason attribute in the DJ column and the DK column of the DOO_ORDER_LINES_ALL_INT tab.

Coverage

If you cancel a coverage, then include the Covered Item attribute, the Source System Reference for Covered Product attribute, and at least one of these attributes.

  • Identifier for Covered Product

  • Number for Covered Product

  • Description for Covered Product

  • Identifier for Covered Customer Product

  • Number for Covered Customer Product

  • Description for Covered Customer Product

Cancel a Service

A service can be a coverage and subscription. For details, see Import Source Orders That Include Coverages and Subscriptions.

Here are the attributes you can use when you cancel a service.

Attribute

Description

Service Duration, Service Duration Code, or Service Duration UOM

If Service Duration Type is.

  • Fixed or variable, include Service Duration, and include Service Duration Code or Service Duration UOM.

  • Open ended, and if canceling coverage, then Service Duration Code or Service Duration UOM is optional. You must set Period for a coverage item, or if you set Service Duration.

For details, see Set Up Coverages for Sales Orders.

If you include Service Duration.

  • You must include Service Duration Code or Service Duration UOM.

  • Make sure decimal precision doesn't exceed 3.

Note

  • If your source system already priced the source order, and if source order includes Duration, then you must also include the extended amount for duration.

  • If the import includes a coverage, then you must also include the covered item.

Not Allowed

Make sure your import doesn't:

  • Include a configured item.

  • Include recurring billing. The source order must specify one time billing.

  • Modify a return item and its covered item or add or remove the original sales order revision.

Related Topics