You are browsing the archive for Order Management.

Advanced Pricing Descriptive Flex Fields

Oracle Advanced Pricing Module DFF list

DFF View DFF CODE NAME DFF name
OE_AGREEMENTS_B_DFV OE_AGREEMENTS Additional Agreement Information
OE_ITEM_GROUPS_DFV OE_ITEM_GROUPS Additional Item Group Information
OE_ITEM_GROUP_LINES_DFV OE_ITEM_GROUP_LINES Additional Pricing Information
OE_PRICING_RULES_B_DFV OE_PRICING_RULES Additional Pricing Rule Information
OE_PRICING_RULE_LINES_DFV OE_PRICING_RULE_LINES Additional Pricing Rule Line Info
OE_PRC_RULE_LINE_VALUES_DFV OE_PRICING_RULE_LINE_VALUES Additional Pricing Rule Line Value Info
OE_RULE_FORMULA_COMPTS_DFV OE_RULE_FORMULA_COMPONENTS Additional Component Information
QP_ATTRIBUTE_DEFNS_DFV QP_ATTR_DEFNS_PRICING Pricing Contexts
QP_ATTRIBUTE_DEFNS1_DFV QP_ATTR_DEFNS_QUALIFIER Qualifier Contexts
QP_LIST_HEADERS_B_DFV QP_LIST_HEADERS Additional Info for List Headers
QP_LIST_LINES_DFV QP_LIST_LINES Additional Info for List Lines
QP_PRICE_FORMULA_LINES_DFV QP_PRICE_FORMULA_LINES Additional Info for Formula Lines
QP_PRICING_ATTRIBUTES_DFV QP_PRICING_ATTRIBUTES Additional Info for Pricing Attributes
QP_PRICE_FORMULAS_B_DFV QP_PRICING_FORMULAS Additional Information
QP_QUALIFIERS_DFV QP_QUALIFIERS Additional information for Qualifiers
QP_QUALIFIER_RULES_DFV QP_QUALIFIER_RULES Additional information for Qualifier Rules
QP_CURRENCY_DETAILS_DFV QP_CURRENCY_DETAILS Additional Info for Currency Details
QP_CURRENCY_LISTS_B_DFV QP_CURRENCY_LISTS Additional Info for Currency Lists

Return Material Authorization Order

Return Material Authorization (RMA) is a return sales order to process customer returns for damaged parts, repairs, damaged in transit, warranty failures.

Return orders can be combined with regular sales order if order type category is ‘MIXED’. Otherwise order type category must be RETURN to place return order.

Oracle Order Management supports the below RMA order cycle flows

  • RMA with Credit only: In this scenario customer doesn’t have to return the goods, but he will get credit upon notifying you of bad part received.
  • RMA with Repair: Customer returns the product to your facility, your business will repair and return the goods back to customer.
  • RMA with Replacement: Customer returns the parts and you will send replacement part, these are also called exchange orders.
  • RMA with Receipt and No credit: Customers return the goods but they don’t get any credit, example could be parts shipped for demo or trials at customer facility.
  • RMA with Receipt and Credit: Customers returns the goods and also receives the credit amount.

You can create unlimited return flow processes matching your business needs by customizing oracle workflows.

RMA orders can be entered in 3 ways

  • Manually
  • Copy from original sales order
  • Order Import API/Interface

Navigation: Oracle Order Management responsibility -> Orders, Returns -> Sales Orders

Enter the RMA order information in header and other tabs.

RMA Order Header

RMA Order Header

Click on ‘Line Items’ to enter return line information.

RMA Order Line

RMA Order Line

Customer Acceptance Report

Customer Acceptance Report is a standard Oracle Order Management report. This report prints out all customer acceptances based on given parameters. Customer Acceptances is a new feature in R12, it allows order updates beyond shipping. This helps in revenue recognition.

Navigation:

Oracle Order Management responsibility -> Reports, Requests -> Run Reports -> Select Report name as ‘Customer Acceptance Report’ -> Select the Operating Unit

Order Management Customer Acceptance Report

Order Management Customer Acceptance Report

Customer Acceptance Report Parameters:

  • Sort By
  • Customer Name from
  • Customer Name to
  • Customer Number from
  • Customer Number to
  • Order Type from
  • Order Type to
  • Order Number from
  • Order Number to
  • Order Date from
  • Order Date to
  • Fulfillment Dates from
  • Fulfillment Dates to
  • Acceptance Dates from
  • Acceptance Dates to
  • Acceptance Status
  • Item Display
  • Use Functional Currency