You are browsing the archive for Technical Design.

Oracle Order Management Forms

Oracle OM module forms:

FORM SHORT CODEORACLE FORM NAME
OEXCCRLSCredit Check Rules Definition
OEXDEFWKDefaulting Rules
OEXDSCRTDefine sales types for OM
OEXDTTYPDefine Transaction Types
OEXERMSGProcess Messages
OEXOEADJAdjustments Screen
OEXOEORDSales Orders
OEXOHDEFHolds Definition
OEXOIMPTCorrections
OEXOISRSDefine OrderImport Sources
OEXPCFRSDefine Record Sets
OEXPCFVTDefine Validation Templates
OEXPCFWKDefine Processing Constraints
OEXSSDTFShipping Tolerances
OEXWFWFAWorkflow Assigments
OEXOIADCOrder Import Add Customers
OEXPARAMParameters
OEXAUDHFView Audit History
OEXOEAVAPrice/Availability Query
OEXITMWBExport Compliance Workbench
OEXOETELQuick Sales Orders
OEXOEBSOSales Agreements
OEXOEPUROM: Order Purge
OEXOECHGCharges
OEXOEINLAdd Customer
OEXOECSFCycle Status and Approval History
OEXATRULAttachment Addition Rules
OEXOERETRetrobill Summary
OEXOERLIRetrobill Results
OEXOIEMHOpen Interface Tracking
OEXOEFCHDisplay Freight Choices
OEXOEVERVersion History
OEXOEBVRSales Agreement Version History
OEXOEPMTPayments
OEXPMTYPPayment Types
OEXPMVALSystem Parameter Values
OEXAPDEFDefine Approval Lists
OEXPMDEFSystem Parameters Definition
OEXPRAVAPricing and Availability
OEXOEMCGMass Change
OEXITORDItem Orderability Rules
OEXFSAIAAIA – 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 CODECONCURRENT PROGRAM NAME
OEPCGENUsed to generate constraints validation packages
OEPCCOMPCompile Constraints Validation Packages
DEFGENDefaulting Generator
OEDEFCOMPCompile Defaulting Packages
OEOIMPOrder Import Concurrent Program
OMPRELPurchase Release for Order Managment
OEXOHHSAHold Source Activity Report
SCHORDSchedule Order for Order Managment
OEXDERULDefaulting Rules Listing Report
OEXORDTPTransaction Types Listing Report
OEXOHOHSOutstanding Holds Report
OEXOEOCSCancelled Orders Report
OEXOEOCRCancelled Orders Reason Detail Report
OEXOEUBKUnbooked Orders Report
OEXWFASGWorkflow Assignments Report
OEXOEACKSales Order Acknowledgement
OEXOEORSCredit Orders Report
OEXOEIOSOrder/Invoice Summary Report
OEXOEITROrders by Item Report
OEXOECODComprehensive Order Detail Report
OEXOEPCLProcessing Constraints Listing Report
OEXOEOSROrders Summary Report
OEXOEUBDUnbooked Orders Detail Report
OEXAUGENConcurrent Program – Order Management Audit History Consolidator
OEXAUDHRAudit History Report
OEXOEASRAgreement Activity Report
OEOIMPSOrder Import Statistics
OEXAUCRCCredit check a set of sales orders
OEXCEXPCredit Exposure Report
OEXOEWFRSales Order Workflow Status Report
OMRSCHSETRe-scheduling of Ship Sets
OMRSVORDReserve Orders Concurrent Program
OEXOECCHOrders on Credit Check Hold Report
OEXOEIODOrder/Invoice Detail Report
OEXOEORRReturns by Reason Report
OEXCRDISCredit Order Discrepancy Report
OERLSHLDRelease Expired Hold
OEXIODISInternal Order and Purchasing Requisition Discrepancy Report
OEXPODISSales Order and Purchase Order Discrepancy Report
RLSEXPHLDSRelease Expired Holds
ORDPUROrder Purge
GENPSETWHEREOrder Purge Selection
OEXOEORDCredit Order Detail Report
GENPSETCreate Purge Set
OEXOECCLLines on Credit Check Hold Report
OEXOESOSSalesperson Order Summary Report
OEXPRPRDOrder Discount Detail Report
OEXPRPRSOrder Discount Summary Report
EDW_OE_SLCHNL_MPublish Sales Channel Dimension
OEXOEULCOE-OM Order Line Transaction Count Comparison Report
OEXOELCSOrder Line Transaction Count Summary Report
OECSTOTBatch Program to calculate Party level Order Totals, Last Order Date and Order count
OEXINICSInitialize Credit Summaries Table for Precalculated Credit Checking
OMORDERDiagnostics: OM Order Information
OMDEBUGDiagnostics: OM Debug File Retrieval
OMCHECKDiagnostics: Apps Check
INVIFACEInventory Interface for Order Management
OEMPRGPurge of OM Processing Messages
OEXSEVALOrder Management Setup Validation Report
OEXSSOCPShow Sales Order Concurrent program for Periodical Support of 3a6
OEXFRZIIIncluded Items Freeze at Pick Release Concurrent Program
OEHVIMPHigh Volume Order Import
OECSELIGExport Compliance Screening Program
OEXITMGVExport Compliance Report to Government
OEXITMSFExport Compliance Screening Failure Report
OEXCEPRGPurge Imported Credit Exposure program
OEXCEIMPImport Credit Exposure program
OEXPPPMTProcess Pending Payments Concurrent Program
OEXCFDPConcurrent program to progress from firm process
OEXPMTRCPayment Receipt
ONT_BUSDOC_CONCPROGProgram to generate a Sales Agreement/Sales Order or Contracts Attachment
OEXPMSETPopulate System Parameters
OEXOIPCPPurge procedure for the views used by Order Import and EDI/XML messages
GENPSETQTEWHEREQuote Purge selection
OEXRETRPRetroactive Billing Report
OEXRETCPRetrobill Lines
OEXADPRBConcurrent Program to Delete Advanced Item Search Session Data.
OERETPURPurge Retrobilling Requests
ONTIBYCN_WKRPurge Secured Payment Data – Worker
ONTIBYFC_WKRMigrate Payment Data for Closed Orders to Oracle Payment – Worker
OEXVWFValidate OM Workflow
OECARRCustomer Acceptance Report
ONTIBYCN_MGRPurge Secured Payment Data
ONTIBYFC_MGRMigrate Payment Data for Closed Orders to Oracle Payment
OECIARPGenerate pre-billing customer acceptance program
OEXEXMBRRetries workflow activities in error for Order Management workflows
OEXOECOD_XMLComprehensive Order Detail Report
OEXOEIOD_XMLOrder/Invoice Detail Report
OEXOEIOS_XMLOrder/Invoice Summary Report
OEXOEITR_XMLOrders by Item Report
OEXAUCRC_XMLCredit check a set of sales orders
OEXCEXP_XMLCredit Exposure Report (XML)
OEXCRDIS_XMLCredit Order Discrepancy Report
OEXOECCL_XMLLines on Credit Check Hold Report
OEXPRPRD_XMLOrder Discount Detail Report
OEXPRPRS_XMLOrder Discount Summary Report
OEXSEVAL_XMLOrder Management Setup Validation Report (XML)
OEXWFASG_XMLWorkflow Assignments Report
OEXAUDHR_XMLAudit History Report
OEXDERUL_XMLDefaulting Rules Listing Report
OEXIODIS_XMLInternal Order and Purchasing Requisition Discrepancy Report
OEXOEACK_XMLSales Order Acknowledgement
OEXOEASR_XMLAgreement Activity Report
OEXOECCH_XMLOrders on Credit Check Hold Report
OEXOEOCR_XMLCancelled Orders Reason Detail Report
OEXOEOCS_XMLCancelled Orders Report
OEXOEORD_XMLCredit Order Detail Report
OEXOEORR_XMLReturns by Reason Report
OEXOEORS_XMLCredit Orders Report
OEXOEOSR_XMLOrders Summary Report
OEXOEPCL_XMLProcessing Constraints Listing Report
OEXOESOS_XMLSalesperson Order Summary Report
OEXOEUBD_XMLUnbooked Orders Detail Report
OEXOEUBK_XMLUnbooked Orders Report
OEXOEWFR_XMLSales Order Workflow Status Report
OEXOHHSA_XMLHold Source Activity Report
OEXOHOHS_XMLOutstanding Holds Report
OEXORDTP_XMLTransaction Types Listing Report
OEXITORDMVRefresh Order Management Materialized Views
OESPLCSplit action for Model Lines
OEXITORDItem Orderability Rules Listing Report
OMBATCHPRICEBatch Pricing Concurrent Program
OEXPWFPurge Order Management Workflow