You are browsing the archive for Technical Design.

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

Order Management Concurrent Programs

Oracle Order Management Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
OEPCGEN Used to generate constraints validation packages
OEPCCOMP Compile Constraints Validation Packages
DEFGEN Defaulting Generator
OEDEFCOMP Compile Defaulting Packages
OEOIMP Order Import Concurrent Program
OMPREL Purchase Release for Order Managment
OEXOHHSA Hold Source Activity Report
SCHORD Schedule Order for Order Managment
OEXDERUL Defaulting Rules Listing Report
OEXORDTP Transaction Types Listing Report
OEXOHOHS Outstanding Holds Report
OEXOEOCS Cancelled Orders Report
OEXOEOCR Cancelled Orders Reason Detail Report
OEXOEUBK Unbooked Orders Report
OEXWFASG Workflow Assignments Report
OEXOEACK Sales Order Acknowledgement
OEXOEORS Credit Orders Report
OEXOEIOS Order/Invoice Summary Report
OEXOEITR Orders by Item Report
OEXOECOD Comprehensive Order Detail Report
OEXOEPCL Processing Constraints Listing Report
OEXOEOSR Orders Summary Report
OEXOEUBD Unbooked Orders Detail Report
OEXAUGEN Concurrent Program – Order Management Audit History Consolidator
OEXAUDHR Audit History Report
OEXOEASR Agreement Activity Report
OEOIMPS Order Import Statistics
OEXAUCRC Credit check a set of sales orders
OEXCEXP Credit Exposure Report
OEXOEWFR Sales Order Workflow Status Report
OMRSCHSET Re-scheduling of Ship Sets
OMRSVORD Reserve Orders Concurrent Program
OEXOECCH Orders on Credit Check Hold Report
OEXOEIOD Order/Invoice Detail Report
OEXOEORR Returns by Reason Report
OEXCRDIS Credit Order Discrepancy Report
OERLSHLD Release Expired Hold
OEXIODIS Internal Order and Purchasing Requisition Discrepancy Report
OEXPODIS Sales Order and Purchase Order Discrepancy Report
RLSEXPHLDS Release Expired Holds
ORDPUR Order Purge
GENPSETWHERE Order Purge Selection
OEXOEORD Credit Order Detail Report
GENPSET Create Purge Set
OEXOECCL Lines on Credit Check Hold Report
OEXOESOS Salesperson Order Summary Report
OEXPRPRD Order Discount Detail Report
OEXPRPRS Order Discount Summary Report
EDW_OE_SLCHNL_M Publish Sales Channel Dimension
OEXOEULC OE-OM Order Line Transaction Count Comparison Report
OEXOELCS Order Line Transaction Count Summary Report
OECSTOT Batch Program to calculate Party level Order Totals, Last Order Date and Order count
OEXINICS Initialize Credit Summaries Table for Precalculated Credit Checking
OMORDER Diagnostics: OM Order Information
OMDEBUG Diagnostics: OM Debug File Retrieval
OMCHECK Diagnostics: Apps Check
INVIFACE Inventory Interface for Order Management
OEMPRG Purge of OM Processing Messages
OEXSEVAL Order Management Setup Validation Report
OEXSSOCP Show Sales Order Concurrent program for Periodical Support of 3a6
OEXFRZII Included Items Freeze at Pick Release Concurrent Program
OEHVIMP High Volume Order Import
OECSELIG Export Compliance Screening Program
OEXITMGV Export Compliance Report to Government
OEXITMSF Export Compliance Screening Failure Report
OEXCEPRG Purge Imported Credit Exposure program
OEXCEIMP Import Credit Exposure program
OEXPPPMT Process Pending Payments Concurrent Program
OEXCFDP Concurrent program to progress from firm process
OEXPMTRC Payment Receipt
ONT_BUSDOC_CONCPROG Program to generate a Sales Agreement/Sales Order or Contracts Attachment
OEXPMSET Populate System Parameters
OEXOIPCP Purge procedure for the views used by Order Import and EDI/XML messages
GENPSETQTEWHERE Quote Purge selection
OEXRETRP Retroactive Billing Report
OEXRETCP Retrobill Lines
OEXADPRB Concurrent Program to Delete Advanced Item Search Session Data.
OERETPUR Purge Retrobilling Requests
ONTIBYCN_WKR Purge Secured Payment Data – Worker
ONTIBYFC_WKR Migrate Payment Data for Closed Orders to Oracle Payment – Worker
OEXVWF Validate OM Workflow
OECARR Customer Acceptance Report
ONTIBYCN_MGR Purge Secured Payment Data
ONTIBYFC_MGR Migrate Payment Data for Closed Orders to Oracle Payment
OECIARP Generate pre-billing customer acceptance program
OEXEXMBR Retries workflow activities in error for Order Management workflows
OEXOECOD_XML Comprehensive Order Detail Report
OEXOEIOD_XML Order/Invoice Detail Report
OEXOEIOS_XML Order/Invoice Summary Report
OEXOEITR_XML Orders by Item Report
OEXAUCRC_XML Credit check a set of sales orders
OEXCEXP_XML Credit Exposure Report (XML)
OEXCRDIS_XML Credit Order Discrepancy Report
OEXOECCL_XML Lines on Credit Check Hold Report
OEXPRPRD_XML Order Discount Detail Report
OEXPRPRS_XML Order Discount Summary Report
OEXSEVAL_XML Order Management Setup Validation Report (XML)
OEXWFASG_XML Workflow Assignments Report
OEXAUDHR_XML Audit History Report
OEXDERUL_XML Defaulting Rules Listing Report
OEXIODIS_XML Internal Order and Purchasing Requisition Discrepancy Report
OEXOEACK_XML Sales Order Acknowledgement
OEXOEASR_XML Agreement Activity Report
OEXOECCH_XML Orders on Credit Check Hold Report
OEXOEOCR_XML Cancelled Orders Reason Detail Report
OEXOEOCS_XML Cancelled Orders Report
OEXOEORD_XML Credit Order Detail Report
OEXOEORR_XML Returns by Reason Report
OEXOEORS_XML Credit Orders Report
OEXOEOSR_XML Orders Summary Report
OEXOEPCL_XML Processing Constraints Listing Report
OEXOESOS_XML Salesperson Order Summary Report
OEXOEUBD_XML Unbooked Orders Detail Report
OEXOEUBK_XML Unbooked Orders Report
OEXOEWFR_XML Sales Order Workflow Status Report
OEXOHHSA_XML Hold Source Activity Report
OEXOHOHS_XML Outstanding Holds Report
OEXORDTP_XML Transaction Types Listing Report
OEXITORDMV Refresh Order Management Materialized Views
OESPLC Split action for Model Lines
OEXITORD Item Orderability Rules Listing Report
OMBATCHPRICE Batch Pricing Concurrent Program
OEXPWF Purge Order Management Workflow