You are browsing the archive for Oracle Order Management.

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

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