You are browsing the archive for Setups.

OM Transaction Types Setup

 

Form Application: Oracle Order Management
Form Name:  OEXDTTYP
Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ont/12.0.0/forms/US/OEXDTTYP.fmx

Transaction types are used to differentiate different types of sales orders. It will have sales order header and line level workflows that control the steps in a sales order cycle. Apart from this transaction types also contain the additional information that will default to sales orders. Transaction types are operating Unit specific.

Transaction Types Setup - Oracle Order Management
Description
Order Management Transaction Types control the different steps in a life cycle of sales order. Oracle Transactions types are mapped to Oracle workflow that controls the process steps. Transactions types are assigned to Sales Orders when entered.
For detailed tutorial on how to setup OM Transaction Types visit at
http://oracleappscommunity.com/oracle/blog/9262/om-transaction-types-setup/

 

Navigation: Login to Oracle Apps -> Select Order Management responsibility -> Setup

  • Navigate to  Transaction Types -> Define
  • Query any transaction type to modify or enter transaction type to setup
    • Enter the Transaction type Header details
    •     Enter the Transaction type Name
    •     Enter the Transaction type description
    •     Sales document type
    •     Order Category
    •     Transaction Type Code
    •     Fulfillment Flow
    •     Negotiation Flow
    •     Effective Dates
    •     Default transaction phase
  • Click on ‘Approvals’ to attach Approval List
  • Enter ‘Main’ tab details
    •     Agreement type
    •     Agreement required
    •     Purchase order required
    •     Default return line type
    •     Default order line type
    •     Enforce list price
    •     Price list
    •     Minimum margin percent
    •     Credit check rules for ordering, Packing, Picking/Purchase release and Shipping
  • Enter ‘Shipping’ tab details
    •     Warehouse
    •     Shipment priority
    •     FOB
    •     Demand Class
    •     Inspection required
    •     Line Set
    •     Freight Terms
    •     Shipping Source type
    •     Scheduling level
    •     Auto schedule
    •     Fulfillment set
  • Enter ‘Finance’ tab details
    •     Invoicing Rule
    •     Accounting Rule
    •     Invoice Source
    •     Non Delivery Invoice source
    •     Credit method for invoices with rules, split term invoices
    •     Receivables transaction type
    •     Cost Of Goods Sold Account
    •     Conversion Type
    •     Tax Event
    •     Currency
  • Click on ‘Assign Line Flows’
    • Enter line type, item type, workflow process name, start date and end date

Save the changes

Order Management Profile Options

Oracle Order Management Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
ONT_RESERVATION_TIME_FENCE OM: Reservation Time Fence
ONT_RETURN_FULFILLED_LINE_ACTION OM: Return Unfulfilled Referenced Line Action
ONT_RETURN_ITEM_MISMATCH_ACTION OM: Return Item Mismatch Action
ONT_RISK_FAC_THRESHOLD OM: Risk Factor Threshold for Electronic Payments
ONT_SCHEDULE_LINE_ON_HOLD OM: Schedule Line on Hold
ONT_SHOW_LINE_DETAILS OM: Show Line Details
ONT_SOURCE_CODE OM: Source Code
ONT_UNIT_PRICE_PRECISION_TYPE OM:Unit Price Precision Type
WSH_INVOICE_NUMBERING_METHOD OM: Invoice Numbering Method
OE_CREDIT_TRANSACTION_TYPE_ID OM: Credit Memo Transaction Type
OE_CUST_ITEM_SHOW_MATCHES OM: Cust Item Shows Matches
OE_DISCOUNT_DETAILS_ON_INVOICE OM: Show Discount Details on Invoice
ONT_POPULATE_BUYER OM: Population Of Buyer Code For Dropship Lines
ONT_DBI_INSTALLED OM: DBI Installation
ONT_PROCESS_PAYMENT_IMMEDIATELY OM: Process Payment Immediately at Booking
ONT_COPY_MODEL_DFF OM: Copy Model dff to child lines
ONT_REPORTDEFECT_PROFILE OM: Customer Service Report Defect
ONT_FEEDBACK_PROFILE OM: Customer Service Feedback
ONT_ADD_CUSTOMER_OI OM: Add Customer (Order Import)
OE_COMMITMENT_SEQUENCING OM: Commitment Sequencing
ONT_HONOR_ITEM_CHANGE OM: Item Change Honors Frozen Price
ONT_CONFIG_QUICK_SAVE OM: Configuration Quick Save
ONT_PROMOTION_LIMIT_VIOLATION_ACTION OM: Promotion Limit Violation Action
ONT_ACTIVATE_CMS OM: Activate Change Management System
OM_UI_CASCADE_HEADER_ATTRIBUTES OM: Sales Order Form: Cascade Header Changes to Line
ONT_CHARGES_FOR_BACKORDERS OM: Charges For Backorders
ONT_CHARGES_FOR_INCLUDED_ITEM OM: Charges for included item
ONT_PC_UPDATE_ALL_FOR_DFF OM: Generic Update Constraints Apply to DFF?
OE_RECEIVABLES_DATE_FOR_NONSHIP_LINES OM: Set Receivables Transaction Date as Current Date for Non-Shippable Lines
ONT_MSDS_LOGGING OM: Order Information Regulatory logging
OE_INVOICE_FREIGHT_AS_LINE Tax: Invoice Freight as Revenue
OE_APPLY_AUTOMATIC_ATCHMT OM: Apply Automatic Attachments
OE_CHARGING_PRIVILEGE OM: Charging Privilege
OM_ORDERS_PURGE_PER_COMMIT OM: Orders Purge Per Commit
ONT_GSA_VIOLATION_ACTION OM: GSA Discount Violation Action
OE_RESP_FOR_WF_UPGRADE OM: Context Responsibility for Upgraded Orders
OE_NOTIFICATION_APPROVER OM: Notification Approver
OE_DEBUG_LOG_DIRECTORY OM: Debug Log Directory
ONT_CUSTOMER_RELATIONSHIPS OM: Customer Relationships
ONT_DISCOUNTING_PRIVILEGE OM: Discounting Privileges
OM_CUST_TOTAL_CURRENCY OM: Party Totals Currency
ONT_ADD_CUSTOMER OM: Add Customer
ONT_MANDATE_CUSTOMER_EMAIL OM: E-Mail Required on New Customers
ONT_EMP_ID_FOR_SS_ORDERS OM: Employee for Self-Service Orders
ONT_PREINSERT_MANUAL_ADJ OM: Preinsert Manual Adjustments
ONT_MANUAL_LINEGROUP OM: Manual Linegroup Adjustment Exists
ONT_ICP_DEFAULT_RECORDS OM: Records On Summary Page For External Users
ONT_ITEM_VIEW_METHOD OM: Item View Method
ONT_NO_PRICING_AT_SCHEDULING OM: Deactivate Pricing at Scheduling
ONT_USE_CONFIGURATOR OM: Use Configurator
WSH_CR_SREP_FOR_FREIGHT OM: Credit Salesperson for Freight on Sales
OM_DEF_ORDER_TYPE OM: Default Order Type
OE_CREDIT_CHECK_API_FLOW OM: Credit Check Engine API Code Flow
OE_ID_FLEX_CODE OM: Item Flexfield
OE_INVENTORY_ITEM_FOR_FREIGHT Tax: Inventory Item for Freight
OE_INVOICE_SOURCE OM: Invoice Source
OE_INVOICE_TRANSACTION_TYPE_ID OM: Invoice Transaction Type
OE_NON_DELIVERY_INVOICE_SOURCE OM: Non-Delivery Invoice Source
OE_ORGANIZATION_ID OM: Item Validation Organization
OE_OVERSHIP_INVOICE_BASIS OM: Overshipment Invoice Basis
OE_SET_OF_BOOKS_ID OM: Ledger
OE_SOURCE_CODE OM: Source Code2-1
OM_OVER_RETURN_TOLERANCE OM: Over Return Tolerance
OM_OVER_SHIPMENT_TOLERANCE OM: Over Shipment Tolerance
OM_UNDER_RETURN_TOLERANCE OM: Under Return Tolerance
OM_UNDER_SHIPMENT_TOLERANCE OM: Under Shipment Tolerance
ONT_ADMINISTER_PUBLIC_QUERIES OM: Administer Public Queries
ONT_AUTOSCHEDULE OM: AutoSchedule
ONT_AUTO_PUSH_GRP_DATE OM: Auto Push Group Date
ONT_CREDIT_CARD_PRIVILEGES OM: Credit Card Privileges
ONT_DEBUG_LEVEL OM: Debug Level
ONT_EST_AUTH_VALID_DAYS OM: Estimated Authorization Validity Period
ONT_INCLUDED_ITEM_FREEZE_METHOD OM: Included Item Freeze Method
ONT_NEGATIVE_PRICING OM: Negative Pricing
ONT_ORDER_DATE_TYPE_CODE OM: Order Date Type Code
ONT_RECEIPT_METHOD_ID OM: Payment method for Credit Card Transactions
ONT_TAX_ROLLUP_HDR_AIA OM: Roll Up Tax on Header Level for AIA Synch
ONT_BYPASS_ATP OM: Bypass ATP
PARALLEL_QUERIES_IN_CUST_MERGE OM : Use Parallel Queries in Customer Merge
ONT_DELAY_SCHEDULING OM: Delay Scheduling
ONT_USE_MVIEW_FOR_ITEMS_LOV OM: Use Materialized View for Items LOV (Honors Item Orderability Rules)
ONT_BSA_MIN_MAX_VIOLATION OM: BSA Min-Max Limit Violation Action
DISPLAY_NEW_ORDER_AFTER_COPY OM: Display New Order After Copy
ONT_VIEW_INTERCOMPANY_INVOICE OM: View Intercompany AR Invoice
ONT_GENERATE_CREDIT_REJECTED_RETURNS OM: Generate credit for rejected returns
ONT_MIN_ITEM_LENGTH OM: Minimum Item Length
ONT_CHARGES_ROLLUP_LINE_AIA OM: Roll Up Charges on Line Level for AIA Synch
ONT_CHARGES_ROLLUP_HDR_AIA OM: Roll Up Charges on Header Level for AIA Synch
ONT_SCH_ATO_ITEM_WO_BOM OM: Schedule ATO Item Without BOM
ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG OM: Allow model fulfillment without configuration
ONT_GENERATE_DIAGNOSTICS OM:Generate Diagnostics for Error Activities
ONT_TAX_CODE_FOR_FREIGHT OM: Interface freight tax classification code from line
ONT_UOM_CLASS_CHARGE_PERIODICITY OM: UOM Class for Charge Periodicity
ONT_BUTTON_POPLIST OM: Display Actions Button vs. Poplist
ONT_AGENT_ACTION_PROFILE OM: Contact Center Actions Menu Name
ONT_PRESERVE_EXT_CR_BAL OM: Preserve External Credit Balances
ONT_ENFORCE_DUP_PO OM:Enforce Check For Duplicate Purchase Order
ONT_DEFAULT_PERSON_ID OM: Default Salesrep
ONT_QOE_UI_REFRESH_METHOD OM: Quick Sales Order Form: Auto Refresh
ONT_SALES_ORDER_FORM_PREFERENCE OM: Sales Orders Form preference
OM_UI_REFRESH_METHOD OM: Sales Order Form: Refresh Method (Query Coordination)
ONT_ENABLE_MSG OM: Show Process Messages Flag
ONT_SCHEDULING_ROLE OM: Scheduling Role
ONT_QOE_UI_DEFER_PRICING OM: Quick Sales Order Form: Defer Pricing
ONT_INTERNAL_CHANGED_LINE OM: Send Changed Lines to Pricing
ONT_AUTOMATIC_ACCOUNT_CREATION OM: Create Account Information
ONT_OPEN_RELATED_ITEMS OM: Automatically Open Related Items Window
ONT_VIEW_PRICING_AVAILABILITY OM: View Pricing & Availability Information in Related Items
ONT_ENABLE_RELATED_ITEMS OM: Enable Related Items and Manual Substitutions
ONT_OVERRIDE_ATP OM: Authorized To Override ATP
OE_DEFAULT_BLANKET_ORDER_TYPE OM: Default Sales Agreement Type
ONT_SET_FOR_EACH_LINE OM: Assign New Set For Each Line
ONT_GRP_PRICE_FOR_DSP OM: Enable Group pricing for DSP lines
ONT_INCLUDE_CUST_IN_OI_KEY OM: Unique Order Source, Orig Sys Document Ref Combination For Each Customer
ONT_RESTRICT_CUST_ITEMS OM: Restrict Customer Items for Line Level Ship To Address
ONT_DEFAULT_TRANSACTION_PHASE OM: Default Sales Transaction Phase
ONT_DEF_BSA_TRANSACTION_PHASE OM: Default Sales Agreement Transaction Phase
ONT_PRC_AVA_SO_DISPLAY OM: Sales Order navigation from Pricing/Availability form
ONT_PANDA_DISPLAY OM: Display Current Selections in Pricing/Availability
ONT_3A7_RESPONSE_REQUIRED OM: Change SO Response Required
ONT_XML_ACCEPT_STATE OM: Order Accept State for XML
ONT_PRINT_CUSTOMER_EXTN_OBJECT OM: Printed Document Extension Class Name
ONT_SHIP_DEADLINE_SEQUENCE OM: Sequence for TP Ship/Deliver Deadline
ONT_EARLY_SHIP_DATE_SOURCE OM: Source for TP Early Ship/Deliver Date
ONT_CASCADE_SERVICE OM: Cascade Service
ONT_NEW_EDI_ACK_FWK OM: New EDI Acknowledgment Framework
ONT_LIST_PRICE_OVERRIDE_PRIV OM: List Price Override Privilege
ONT_EM_INTEG_SOURCES OM: Electronic Message Integration Event Sources
ONT_DAYS_TO_BACKDATE_BANK_ACCT OM: Number of Days to Backdate Bank Account Creation
ONT_SHIP_METHOD_FOR_SHIP_SET OM: Enforce Shipping Method for Ship Sets
ONT_3A8_RESPONSE_ACK OM: Send Acknowledgment for Change PO Response
ONT_BRANCH_SCHEDULING OM: Branch Scheduling
ONT_TRANSACTION_PROCESSING OM: Run Order Import for XML
ONT_VIEW_CANCEL_LINES OM: View Cancel Lines
ONT_VIEW_CLOSED_LINES OM: View Closed Lines
ONT_UI_RESTRICT_CUSTOMERS OM: Sales Order Form: Restrict Customers
ONT_IMP_MULTIPLE_SHIPMENTS OM: Import Multiple Shipments
ONT_DEFAULT_LINE_TYPE_FROM_MODEL OM: Default Line Type from Model
ONT_PREVENT_BOOKING OM: Prevent Booking for Line Generic Holds
ONT_MODIFY_SEEDED_HOLDS OM: Modify Seeded Holds

Order Management Descriptive Flex Field

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