You are browsing the archive for Oracle Order Management.

Oracle Configure to Order R12 enhancements

1) Auto create Internal requisitions

When a configured line is entered on a sales order it can either manufactured in a warehouse or transferred from another organization (through internal sales order). New enhancement in R12 suports Internal sales order process.
Upon progressing the sales order line it creates Internal requisition in the receiving organization, then it can converted into internal sales order by running the concurrent program ‘Create Internal Sales Order’. Once this sales order is shipped and received by buying organization, its inventory is automatically reserved for the customer sales order.

2) Autocreate OPM requisitions

Back-to-back orders can create internal or purchase requisitions in Process Manufacturing (OPM) organizations.

3) Enhanced Reservations for Configure To Order (CTO) and Back to Back orders.

Oracle Order Management Forms

Oracle OM module forms:

FORM SHORT CODE ORACLE FORM NAME
OEXCCRLS Credit Check Rules Definition
OEXDEFWK Defaulting Rules
OEXDSCRT Define sales types for OM
OEXDTTYP Define Transaction Types
OEXERMSG Process Messages
OEXOEADJ Adjustments Screen
OEXOEORD Sales Orders
OEXOHDEF Holds Definition
OEXOIMPT Corrections
OEXOISRS Define OrderImport Sources
OEXPCFRS Define Record Sets
OEXPCFVT Define Validation Templates
OEXPCFWK Define Processing Constraints
OEXSSDTF Shipping Tolerances
OEXWFWFA Workflow Assigments
OEXOIADC Order Import Add Customers
OEXPARAM Parameters
OEXAUDHF View Audit History
OEXOEAVA Price/Availability Query
OEXITMWB Export Compliance Workbench
OEXOETEL Quick Sales Orders
OEXOEBSO Sales Agreements
OEXOEPUR OM: Order Purge
OEXOECHG Charges
OEXOEINL Add Customer
OEXOECSF Cycle Status and Approval History
OEXATRUL Attachment Addition Rules
OEXOERET Retrobill Summary
OEXOERLI Retrobill Results
OEXOIEMH Open Interface Tracking
OEXOEFCH Display Freight Choices
OEXOEVER Version History
OEXOEBVR Sales Agreement Version History
OEXOEPMT Payments
OEXPMTYP Payment Types
OEXPMVAL System Parameter Values
OEXAPDEF Define Approval Lists
OEXPMDEF System Parameters Definition
OEXPRAVA Pricing and Availability
OEXOEMCG Mass Change
OEXITORD Item Orderability Rules
OEXFSAIA AIA – Sales Order Status Synchronization

Order Management Tables

Oracle Order Management Tables:

  • OE_ACTIONS_IFACE_ALL
  • OE_ACTION_PRE_REQS
  • OE_ADJ_ATTRIB_EBS_LOG
  • OE_AK_GEN_OBJECTS_CFG
  • OE_AK_OBJECTS_EXT
  • OE_AK_OBJ_ATTR_EXT
  • OE_AK_OBJ_WF_ITEMS
  • OE_APPROVER_LISTS
  • OE_APPROVER_LIST_MEMBERS
  • OE_APPROVER_TRANSACTIONS
  • OE_ATTACHMENT_OBJECT_REFS
  • OE_ATTACHMENT_OBJECT_REFS_TL
  • OE_ATTACHMENT_RULES
  • OE_ATTACHMENT_RULE_ELEMENTS
  • OE_AUDIT_ATTR_HISTORY
  • OE_BLANKET_HEADERS_ALL
  • OE_BLANKET_HEADERS_EXT
  • OE_BLANKET_HEADERS_HIST
  • OE_BLANKET_LINES_ALL
  • OE_BLANKET_LINES_EXT
  • OE_BLANKET_LINES_HIST
  • OE_BLANKET_ORG_ASSIGN
  • OE_CC_TEMP
  • OE_CONC_REQUEST_IFACE
  • OE_CREDITS_IFACE_ALL
  • OE_CREDIT_BALANCES_ALL
  • OE_CREDIT_CHECK_RULES
  • OE_CREDIT_SUMMARIES
  • OE_CUSTOMER_INFO_IFACE_ALL
  • OE_CUSTOM_ACTIONS
  • OE_CUST_ITEM_SETTINGS
  • OE_CUST_TOTAL_AMTS_ALL
  • OE_DEFAULT_ACTIONS
  • OE_DEF_ATTR_CONDNS
  • OE_DEF_ATTR_DEF_RULES
  • OE_DEF_CONDITIONS
  • OE_DEF_CONDITIONS_TL
  • OE_DEF_CONDN_ELEMS
  • OE_DOC_SEQUENCE_AUDIT
  • OE_DROP_SHIP_SOURCES
  • OE_EM_INFORMATION_ALL
  • OE_EVENT_ATTRIBUTES
  • OE_EXPOSURE_INTERFACE
  • OE_EXP_INTERFACE_ERRORS
  • OE_FOLDER_EXTENSIONS
  • OE_HEADERS_EBS_LOG
  • OE_HEADERS_IFACE_ALL
  • OE_HEADER_ACKS
  • OE_HOLD_AUTHORIZATIONS
  • OE_HOLD_DEFINITIONS
  • OE_HOLD_RELEASES
  • OE_HOLD_SOURCES_ALL
  • OE_INVOICE_NUMBERS
  • OE_ITEM_CUST_VOLS_ALL
  • OE_LINES_EBS_LOG
  • OE_LINES_IFACE_ALL
  • OE_LINE_ACKS
  • OE_LINE_SETS
  • OE_LOTSERIALS_IFACE_ALL
  • OE_LOTSERIAL_ACKS
  • OE_LOT_SERIAL_NUMBERS
  • OE_NOTES_OBJECT_REFS
  • OE_NOTES_OBJECT_REFS_TL
  • OE_NOTES_RULES
  • OE_NOTES_RULE_ELEMENTS
  • OE_ORDER_HEADERS_ALL
  • OE_ORDER_HEADERS_ALL_EFC
  • OE_ORDER_HEADER_HISTORY
  • OE_ORDER_HOLDS_ALL
  • OE_ORDER_LINES_ALL
  • OE_ORDER_LINES_HISTORY
  • OE_ORDER_NUMBER_SOURCES
  • OE_ORDER_PRICE_ATTRIBS
  • OE_ORDER_SOURCES
  • OE_PAYMENTS
  • OE_PAYMENTS_HISTORY
  • OE_PAYMENTS_IFACE_ALL
  • OE_PAYMENT_TYPES_ALL
  • OE_PAYMENT_TYPES_TL
  • OE_PC_ASSIGNMENTS
  • OE_PC_CONDITIONS
  • OE_PC_CONDITIONS_TL
  • OE_PC_CONSTRAINTS
  • OE_PC_EXCLUSIONS
  • OE_PC_RSETS
  • OE_PC_RSETS_TL
  • OE_PC_RSET_SEL_COLS
  • OE_PC_VALIDATION_PKGS
  • OE_PC_VTMPLTS
  • OE_PC_VTMPLTS_TL
  • OE_PC_VTMPLT_COLS
  • OE_PRICE_ADJS_HISTORY
  • OE_PRICE_ADJS_IFACE_ALL
  • OE_PRICE_ADJUSTMENTS
  • OE_PRICE_ADJ_ASSOCS
  • OE_PRICE_ADJ_ATTRIBS
  • OE_PRICE_ADJ_EBS_LOG
  • OE_PRICE_ATTRIB_EBS_LOG
  • OE_PRICE_ATTS_IFACE_ALL
  • OE_PROCESSING_MSGS
  • OE_PROCESSING_MSGS_TL
  • OE_PURGE_ORDERS
  • OE_PURGE_SETS
  • OE_REASONS
  • OE_RESERVATION_SETS
  • OE_RESERVTNS_IFACE_ALL
  • OE_RETROBILL_REQUESTS
  • OE_RSV_SET_DETAILS
  • OE_SALES_CREDITS
  • OE_SALES_CREDIT_HISTORY
  • OE_SALES_CREDIT_TYPES
  • OE_SCH_ID_LIST_TMP
  • OE_SELECTED_ITEMS
  • OE_SETS
  • OE_SYSTEM_PARAMETERS_ALL
  • OE_SYSTEM_PARAMS_UPG
  • OE_SYS_PARAMETERS_ALL
  • OE_SYS_PARAMETER_DEF_B
  • OE_SYS_PARAMETER_DEF_TL
  • OE_TRANSACTION_TYPES_ALL
  • OE_TRANSACTION_TYPES_TL
  • OE_UI_QUERIES_TL
  • OE_UI_QUERY_COLUMNS
  • OE_UPGRADE_DISTRIBUTION
  • OE_UPGRADE_ERRORS
  • OE_UPGRADE_LOG
  • OE_UPGRADE_PC_ATTR_MAP
  • OE_UPGRADE_PC_CONDNS
  • OE_UPGRADE_PC_SCOPE
  • OE_UPGRADE_PC_TEMP
  • OE_UPGRADE_WF_ACT_MAP
  • OE_UPGRADE_WF_HIST_TEMP
  • OE_UPGRADE_WF_OBS_CODES
  • OE_UPGRADE_WF_VLD_CYC
  • OE_UPGRADE_WSH_IFACE
  • OE_WORKFLOW_ASSIGNMENTS
  • ONT_DBI_CHANGE_LOG
  • ONT_PRT_MARGIN_ANALYSIS
  • ONT_PRT_MARGIN_ANA_ERR
  • ONT_WF_SKIP_LOG