You are browsing the archive for SO.

Order Entry Tables

Oracle Order Entry Module Tables:

  • OE_BIS_BBB_INFO
  • OE_BIS_CUST_SAT_T
  • OE_BIS_CUST_SAT_T2
  • OE_BIS_TOP_CUSTOMERS
  • SO_ACTIONS
  • SO_ACTION_CLAUSES
  • SO_ACTION_PRE_REQS
  • SO_ACTION_RESULTS
  • SO_AGREEMENTS_B
  • SO_AGREEMENTS_TL
  • SO_ATTRIBUTES
  • SO_ATTRIBUTE_STD_VALUE_SOURCES
  • SO_ATTRIBUTE_USES
  • SO_CREDIT_CHECK_RULES_115
  • SO_CYCLES
  • SO_CYCLE_ACTIONS
  • SO_DISCOUNTS
  • SO_DISCOUNT_CUSTOMERS
  • SO_DISCOUNT_LINES_115
  • SO_DROP_SHIP_SOURCES
  • SO_ENTITIES
  • SO_ENTITY_USES
  • SO_EXCEPTIONS
  • SO_FREIGHT_CHARGES
  • SO_FREIGHT_CHARGE_TYPES
  • SO_GENERAL_STD_VALUE_SOURCES
  • SO_HEADERS_ALL
  • SO_HEADERS_INTERFACE_ALL
  • SO_HEADER_ATTRIBUTES
  • SO_HEADER_ATTRIBUTES_INTERFACE
  • SO_HOLDS
  • SO_HOLD_AUTHORIZATIONS
  • SO_HOLD_RELEASES
  • SO_HOLD_SOURCES_ALL
  • SO_ITEM_GROUPS
  • SO_ITEM_GROUP_LINES
  • SO_LINES_ALL
  • SO_LINES_INTERFACE_ALL
  • SO_LINE_APPROVALS
  • SO_LINE_ATTRIBUTES
  • SO_LINE_ATTRIBUTES_INTERFACE
  • SO_LINE_DETAILS
  • SO_LINE_DETAILS_INTERFACE
  • SO_LINE_DETAIL_ATTRIBUTES
  • SO_LINE_DETAIL_ATTRIBUTES_INT
  • SO_LINE_SERVICE_DETAILS
  • SO_NOTES
  • SO_NOTE_ADDITION_RULES
  • SO_NOTE_REFERENCES
  • SO_NOTE_REPLICATION
  • SO_NOTE_USAGES
  • SO_NOTE_USAGE_ATTRIBUTES
  • SO_OBJECTS
  • SO_ORDER_APPROVALS
  • SO_ORDER_CANCELLATIONS
  • SO_ORDER_HOLDS_ALL
  • SO_ORDER_NUMBER_SOURCES
  • SO_ORDER_SOURCES_115
  • SO_ORDER_TYPES_115_ALL
  • SO_PICKING_BATCHES_ALL
  • SO_PICKING_CANCELLATIONS
  • SO_PICKING_HEADERS_ALL
  • SO_PICKING_LINES_ALL
  • SO_PICKING_LINE_DETAILS
  • SO_PICKING_RULES
  • SO_PRICE_ADJUSTMENTS
  • SO_PRICE_ADJUSTMENTS_INTERFACE
  • SO_PRICE_BREAK_LINES
  • SO_PRICE_COPY_PARAMETERS
  • SO_PRICE_LISTS_B
  • SO_PRICE_LISTS_TL
  • SO_PRICE_LIST_LINES_115
  • SO_PRICING_RULES_B
  • SO_PRICING_RULES_TL
  • SO_PRICING_RULE_LINES
  • SO_PRICING_RULE_LINE_VALUES
  • SO_PURGE_ORDERS
  • SO_REPORTS
  • SO_REPORT_PARAMETERS
  • SO_REPORT_PRINTERS
  • SO_REPORT_SETS
  • SO_REPORT_SET_LINES
  • SO_REPORT_SOURCE_PARAMETERS
  • SO_REPORT_USAGES
  • SO_RESULTS_B
  • SO_RESULTS_TL
  • SO_RULE_FORMULA_COMPONENTS
  • SO_SALES_CREDITS
  • SO_SALES_CREDITS_INTERFACE
  • SO_SALES_CREDIT_TYPES_115
  • SO_SECURITY_RULES
  • SO_SERVICE_DETAILS_INTERFACE
  • SO_STANDARD_VALUE_RULES
  • SO_STANDARD_VALUE_RULE_SETS
  • WSH_CONTAINER_LOAD
  • WSH_DELIVERIES
  • WSH_DELIVERIES_INTERFACE
  • WSH_DELIVERY_TEMPLATES
  • WSH_DEPARTURES
  • WSH_DEPARTURE_TEMPLATES
  • WSH_FREIGHT_CHARGES_INTERFACE
  • WSH_INVOICE_NUMBERS
  • WSH_PACKED_CONTAINERS
  • WSH_PACKED_CONTAINER_INTERFACE
  • WSH_PARAMETERS
  • WSH_PICK_SLIP_RULES
  • WSH_RELEASE_SEQ_RULES
  • WSH_REPORT_TEMP

Order Entry Profile Options

Oracle Order Entry Module Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
OE_FORCE_VALID_CONFIGURATIONS OE: Force Valid Configurations
OE_EXTERNAL_PRICER_INSTALLED OE: External Pricer Installed
OE_INCLUDED_ITEM_FREEZE_METHOD OE: Included Item Freeze Method
OE_ITEM_VIEW_METHOD OE: Item View Method
OE_RPC_DEBUG_FLAGS OE: Trans. Manager Debug Level
OE_SCHEDULE_DATE_WINDOW OE: Schedule Date Window
OE_UNIT_PRICE_PRECISION_TYPE OE: Unit Price Precision Type
OE_VALIDATE_OPTION_LINE_ITEM OE: Validate Option Line Item
OE_VALIDATE_STANDARD_LINE_ITEM OE: Validate Standard Line Item
OE_WEIGHT_UOM_CLASS OE: Weight Unit Of Measure Class
CZ_CFG_DISPLAY_SELECTED_ONLY OE: Configurator Display Mode
SHP_EXCEPTION_REPORT SHP: Release Online Exception Report
SHP_PICK_RELEASE_ONLINE SHP: Release Single Orders Online
SHP_PICK_SLIP_REPORT SHP: Release Online Pick Slip Report
SO_DEBUG OE: Debug
SO_DEBUG_TRACE OE: Debug Trace
SO_ENTRY_STATUS_DEFAULT OE: Default RMA Status
SO_GSA_WARNING OE: GSA Discount Violation Action
SO_ID_FLEX_CODE OE: Item Flexfield
SO_INVENTORY_ITEM_FOR_FREIGHT Tax: Inventory Item for Freight-1-1
SO_INVENTORY_LOCATION_FLEX OE: Inventory Stock Location
SO_INVOICE_FREIGHT_AS_LINE Tax: Invoice Freight as Revenue-1-1
SO_ORGANIZATION_ID OE: Item Validation Organization
SO_RELEASE_AUTO_BACKORDER OE: AutoBackorder
SO_RESERVATIONS OE: Reservations
SO_SET_OF_BOOKS_ID OE: Set of Books
SO_SOURCE_CODE OE: Source Code
SO_UNMARK_ELIGIBLE_ACTIONS OE: Cycle Action Changes Affect Existing Orders
SO_VERIFY_GSA OE: Verify GSA Violations
WSH_ALLOW_FUTURE_DEP_DATE WSH: Allow Future Departure Date
WSH_ENFORCE_FREIGHT_CARRIER WSH: Enforce Freight Carrier At Ship Confirm
WSH_SHIPPING_METHOD WSH: Shipping Method
OE_APPLICATION_SERVER OE: Transaction Manager
OE_APPLY_ORDER_ADJS_TO_SERVICE OE: Apply Order Adjustments to Service Lines
OE_AUTODEMAND OE: AutoDemand
OE_AUTOPRICE OE: AutoPrice
OE_CP_SELECTION_ATTRIBUTE OE: Default CP Selection Attribute
OE_CUSTOMER_RELATIONSHIPS OE: Customer Relationships
OE_DEBUG_LEVEL OE: Debug Level
OE_DISCOUNTING_PRIVILEGE OE: Discounting Privilege
OE_DISCOUNT_TUNING OE: Tune for Large Number of Discounts
OE_IMMEDIATE_INVENTORY_UPDATE OE: Immediate Inventory Update