You are browsing the archive for ONT.

by oracleguru

Order Management Descriptive Flex Field

ORACLE APPS COMMUNITY > Tutorial > ONT

Oracle Order Management Module DFF list

DFF View DFF CODE NAME DFF name
OE_PC_CONSTRAINTS_DFV Constraint Qualifier Attribute Constraint Qualifier Attribute
OE_APPROVER_LISTS_DFV OE_APPROVAL_LISTS Additional Approval List Information
OE_APPROVER_LIST_MEMBERS_DFV OE_APPROVER_LIST_MEMBERS Approval List Members Additional Information
OE_SYS_PARAMETERS_ALL_DFV OE_SYS_PARAMETERS Additional Information for System Parameters
OE_DEF_CONDN_ELEMS_DFV Defaulting Flexfield Defaulting Flexfield
OE_DEF_ATTR_DEF_RULES_DFV Defaulting Rules Flexfield Defaulting Rules Flexfield
OE_ORDER_HEADERS_ALL_DFV OE_HEADER_ATTRIBUTES Additional Header Information
OE_ORDER_HEADERS_ALL1_DFV OE_HEADER_GLOBAL_ATTRIBUTE Additional Header Global Information
OE_ORDER_LINES_ALL_DFV OE_LINE_ATTRIBUTES Additional Line Attribute Information
OE_ORDER_LINES_ALL1_DFV OE_LINE_INDUSTRY_ATTRIBUTE Additional LIne Industry Information
OE_ORDER_LINES_ALL2_DFV OE_LINE_PRICING_ATTRIBUTE Additional Line Pricing Information
OE_ORDER_LINES_ALL3_DFV OE_LINE_RETURN_ATTRIBUTE Additional Line Return Information
OE_TRANSACTION_TYPES_ALL_DFV OE_ORDER_TYPES Additional Order Type Information
OE_PC_VTMPLT_COLS_DFV OE_PC_VTMPLT_COLS Validation Template Columns
OE_PRICE_ADJUSTMENTS_DFV OE_PRICE_ADJUSTMENTS Additional Price Adjustment Information
OE_SALES_CREDITS_DFV OE_SALES_CREDITS_ATTRIBUTES Additional Sales Credits Information
OE_PAYMENT_TYPES_ALL_DFV OE_PAYMENT_TYPES Additional Payment Type Information
OE_CUST_ITEM_SETTINGS_DFV OE_CUST_ITEM_ATTRIBUTES Additional Customer-Item Settings
OE_ACTIONS_IFACE_ALL_DFV OE_OI_ACTIONS Order Import Actions Flexfield
OE_CREDITS_IFACE_ALL_DFV OE_OI_CREDITS Order Import Credits Flexfield
OE_PRICE_ADJS_IFACE_ALL_DFV OE_OI_DISCOUNTS Order Import Discounts Flexfield
OE_HEADERS_IFACE_ALL_DFV OE_OI_HEADER_ATTRIBUTES Order Import Orders Flexfield
OE_LOTSERIALS_IFACE_ALL_DFV OE_OI_LOTSERIALS Order Import LotSerials Flexfield
OE_RESERVTNS_IFACE_ALL_DFV OE_OI_RESERVATIONS Order Import Reservations Flexfield
OE_PRICE_ADJUSTMENTS1_DFV OE_PRICE_ADJUSTMENTS_AC AETC / Allowances and Charges
OE_ORDER_LINES_ALL4_DFV OE_LINE_TP_ATTRIBUTES Trading Partner Flexfield
OE_SYSTEM_PARAMETERS_ALL_DFV OE_SYSTEM_PARAMETERS Additional System Parameter Information
OE_BLANKET_HEADERS_ALL_DFV OE_BLKT_HEADER_ATTRIBUTES Additional Sales Agreement Header Information
OE_BLANKET_LINES_ALL_DFV OE_BLKT_LINE_ATTRIBUTES Additional Sales Agreement Line Information
OE_LOT_SERIAL_NUMBERS_DFV OE_LOT_SERIAL_ATTRIBUTES Additional Lot Serial Information
OE_ATTACHMENT_RULE_ELEMENT_DFV OE_ATTACHMENT_RULE_ELEMENTS Additional Attachment Rule Elements Info
OE_ORDER_HEADERS_ALL2_DFV OE_HEADER_TP_ATTRIBUTES Header Level Trading Partner Information
OE_HOLD_AUTHORIZATIONS_DFV OE_HOLD_AUTHORIZATIONS Additional Hold Authorization Info
OE_HOLD_DEFINITIONS_DFV OE_HOLD_DEFINITIONS Additional Hold Information
OE_HOLD_RELEASES_DFV OE_HOLD_RELEASES Additional Hold Release Information
OE_HOLD_SOURCES_ALL_DFV OE_HOLD_SOURCES Additional Hold Source Information
OE_LINES_IFACE_ALL_DFV OE_OI_LINES Order Import Lines Flexfield
OE_SALES_CREDIT_TYPES_DFV OE_SALES_CREDIT_TYPES Additional Sales Credit Type Information
OE_ITEM_ORDERABILITY_RULES_DFV OE_ITORD_ATTRIBUTES Additional Item Orderability Rule Attributes
OE_CREDIT_CHECK_RULES_DFV OE_CREDIT_CHECK_RULES Additional Credit Check Information

Tags: , , , No Comments »

by oracleguru

Order Entry Descriptive Flex Field

ORACLE APPS COMMUNITY > Tutorial > ONT

Oracle Order Entry Module DFF list

DFF View DFF CODE NAME DFF name
SO_ATTRIBUTES1_DFV ATTRIBUTE_DATA_INFORMATION Attribute Data Information
SO_LINE_ATTRIBUTES_DFV INDUSTRY_ATTRIBUTES Additional Industry Attributes
SO_LINES_ALL_DFV PRICING_ATTRIBUTES Pricing Attributes
SO_ACTIONS_DFV SO_ACTIONS Additional Action Information
SO_ACTION_RESULTS_DFV SO_ACTION_RESULTS Additional Action Result Information
SO_AGREEMENTS_B_DFV SO_AGREEMENTS Additional Agreement Information
SO_ATTRIBUTES_DFV SO_ATTRIBUTES Additional Attribute Information
SO_ATTRIBUTE_STD_VALUE_SOU_DFV SO_ATTRIBUTE_STD_VALUE_SOURCES Additional Attribute Std Value Source In
SO_ATTRIBUTE_USES_DFV SO_ATTRIBUTE_USES Additional Attribute Use Information
SO_CYCLES_DFV SO_CYCLES Additional Cycle Information
SO_DISCOUNTS_DFV SO_DISCOUNTS Additional Discount Information
SO_DISCOUNT_CUSTOMERS_DFV SO_DISCOUNT_CUSTOMERS Additional Discount Customer Information
SO_DISCOUNT_LINES_115_DFV SO_DISCOUNT_LINES Additional Discount Line Information
SO_ENTITIES_DFV SO_ENTITIES Additional Entity Information
SO_ENTITY_USES_DFV SO_ENTITY_USES Additional Entity Use Information
SO_FREIGHT_CHARGES_DFV SO_FREIGHT_CHARGES Additional Freight Charge Information
SO_FREIGHT_CHARGES1_DFV SO_FREIGHT_CHARGES_AC AETC / Allowances and Charges
SO_FREIGHT_CHARGE_TYPES_DFV SO_FREIGHT_CHARGE_TYPES Additional Freight Charge Type Info
SO_GENERAL_STD_VALUE_SOURC_DFV SO_GENERAL_STD_VALUE_SOURCES Additional General Std Value Source Info
SO_HEADERS_ALL_DFV SO_HEADERS Additional Header Information
SO_HOLDS_DFV SO_HOLDS Additional Hold Information
SO_HOLD_AUTHORIZATIONS_DFV SO_HOLD_AUTHORIZATIONS Additional Hold Authorization Info
SO_HOLD_RELEASES_DFV SO_HOLD_RELEASES Additional Hold Release Information
SO_HOLD_SOURCES_ALL_DFV SO_HOLD_SOURCES Additional Hold Source Information
SO_ITEM_GROUPS_DFV SO_ITEM_GROUPS Additional Item Group Information
SO_ITEM_GROUP_LINES_DFV SO_ITEM_GROUP_LINES Additional Pricing Information
SO_LINES_ALL1_DFV SO_LINES Additional Line Information
SO_LINE_APPROVALS_DFV SO_LINE_APPROVALS Additional Line Approval Information
SO_LINE_DETAILS_DFV SO_LINE_DETAILS Additional Line Detail Information
SO_LINE_SERVICE_DETAILS_DFV SO_LINE_SERVICE_DETAILS Additional Line Service Detail Info
SO_NOTES_DFV SO_NOTES Additional Note Information
SO_NOTE_ADDITION_RULES_DFV SO_NOTE_ADDITION_RULES Additional Note Addition Rule Info
SO_NOTE_REFERENCES_DFV SO_NOTE_REFERENCES Additional Note Reference Information
SO_NOTE_USAGES_DFV SO_NOTE_USAGES Additional Note Usage Information
SO_OBJECTS_DFV SO_OBJECTS Additional Object Information
SO_ORDER_APPROVALS_DFV SO_ORDER_APPROVALS Additional Order Approval Information
SO_ORDER_CANCELLATIONS_DFV SO_ORDER_CANCELLATIONS Additional Order Cancellation Info
SO_ORDER_HOLDS_ALL_DFV SO_ORDER_HOLDS Additional Order Hold Information
SO_ORDER_NUMBER_SOURCES_DFV SO_ORDER_NUMBER_SOURCES Additional Order Number Source Info
SO_PICKING_BATCHES_ALL_DFV SO_PICKING_BATCHES Additional Picking Batch Information
SO_PICKING_CANCELLATIONS_DFV SO_PICKING_CANCELLATIONS Additional Picking Cancellation Info
SO_PICKING_HEADERS_ALL_DFV SO_PICKING_HEADERS Additional Picking Header Information
SO_PICKING_LINES_ALL_DFV SO_PICKING_LINES Additional Picking Line Information
SO_PICKING_LINE_DETAILS_DFV SO_PICKING_LINE_DETAILS Additional Picking Line Detail Info
SO_PRICE_ADJUSTMENTS_DFV SO_PRICE_ADJUSTMENTS Additional Price Adjustment Information
SO_PRICE_BREAK_LINES_DFV SO_PRICE_BREAK_LINES Additional Price Break Information
SO_PRICE_LISTS_B_DFV SO_PRICE_LISTS Additional Price List Information
SO_PRICE_LIST_LINES_115_DFV SO_PRICE_LIST_LINES Additional Price Information
SO_PRICING_RULES_B_DFV SO_PRICING_RULES Additional Pricing Rule Information
SO_PRICING_RULE_LINES_DFV SO_PRICING_RULE_LINES Additional Pricing Rule Line Info
SO_PRICING_RULE_LINE_VALUE_DFV SO_PRICING_RULE_LINE_VALUES Additional Pricing Rule Line Values Info
SO_REPORT_SETS_DFV SO_REPORT_SETS Report Sets
SO_REPORT_SET_LINES_DFV SO_REPORT_SET_LINES Report Set Lines
SO_RESULTS_B_DFV SO_RESULTS Additional Results Information
SO_RULE_FORMULA_COMPONENTS_DFV SO_RULE_FORMULA_COMPONENTS Additional Component Information
SO_SALES_CREDITS_DFV SO_SALES_CREDITS Additional Sales Credit Information
SO_SECURITY_RULES_DFV SO_SECURITY_RULES Additional Security Rule Information
SO_STANDARD_VALUE_RULES_DFV SO_STANDARD_VALUE_RULES Additional Standard Value Rule Info
SO_STANDARD_VALUE_RULE_SET_DFV SO_STANDARD_VALUE_RULE_SETS Additional Standard Value Rule Set Info
WSH_CONTAINER_LOAD_DFV WSH_CONTAINER_LOAD Additional Vehicle/Container Load Info
WSH_DELIVERIES_DFV WSH_DELIVERIES Additional Delivery Information
WSH_DEPARTURES_DFV WSH_DEPARTURES Additional Departure Information
WSH_PACKED_CONTAINERS_DFV WSH_PACKED_CONTAINERS Additional Packed Container Information
WSH_PARAMETERS_DFV WSH_PARAMETERS Additional Shipping Parameter Info
WSH_PICK_SLIP_RULES_DFV WSH_PICK_SLIP_RULES Additional Pick Slip Rule Information
WSH_RELEASE_SEQ_RULES_DFV WSH_RELEASE_SEQ_RULES Additional Release Sequence Rule Info

Tags: , , , No Comments »

by oracleguru

Return Material Authorization Order

ORACLE APPS COMMUNITY > Tutorial > ONT

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

Tags: , 5 Comments »