You are browsing the archive for Oracle Order Entry.

Collect Sales Channel Dimension

 

NAME: Collect Sales Channel Dimension
SHORT CODE: EDW_OE_SLCHNL_M
MODULE: Oracle Entry

Description: Collect Sales Channel Dimension
Navigation: Oracle Entry Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_from_date : Collect From Date
  • p_from_date : Push From Date
  • p_to_date : Push To Date
  • p_to_date : Collect To Date

 

Order Entry Forms

Oracle Order Entry Forms:

FORM SHORT CODE ORACLE FORM NAME
CZFDCFGR Configurator
OEXCYMAR Assign Action Results
OEXCYMCA Define Cycle Actions
OEXCYMCR Define Cycle Results
OEXCYMOC Define Order Cycle
OEXNTDNU Define Note Usages
OEXNTDSN Define Standard Notes
OEXOECOR Copy Orders
OEXOEEOA Enter Order Approvals
OEXOEMBS Define OrderImport Sources
OEXOEMOE Enter Orders
OEXOEOIN View Invoices
OEXOEONS Define Order Number Sources
OEXOEOSI View Cycle Status
OEXOERMA Enter Return Material Authorizations
OEXOESPB View Shipping Status
OEXOEVOR View Order Lines
OEXOHAOH Apply Holds
OEXOHCCR Define Credit Check Rule
OEXOHDHA Define Holds
OEXOHROH Release Holds
OEXOMCEO Cancel Orders
OEXORDGR View Schedule Results
OEXORRSO Schedule Orders
OEXPRAIG Add Item Groups
OEXPRAII Add Inventory Items
OEXPRCPL Copy Price List
OEXPRDDI Define Discounts
OEXPRDPC Enable Parameters
OEXPRDPL Define Price Lists
OEXPRDPR Define Pricing Rules
OEXPREPG Define Item Groups
OEXPRMPL Adjust Price Lists
OEXPRPFC Define Pricing Components
OEXPRURP Update Rule Prices
OEXRPDRS Define Document Sets
OEXSCDSR Define Security Rules
OEXSSDAF Define Agreements
OEXSSDCT Define Sales Credit Types
OEXSSDOT Define Order Type
OEXSSMLK Define Order Entry QuickCodes
OEXSVDRS Define Standard Value Rule Set
SHPFDDDS Document Sets
SHPFDDFC Freight Charges
SHPFDPSD Choose Printers
SHPFDREL Release Rules
SHPFRREL Launch Pick Release
WSHFDCLD Container Load
WSHFDDPW Departure Planning
WSHFDGRP Pick Slip Grouping Rules
WSHFDPAR Shipping Parameters
WSHFDSEQ Release Sequence Rules
WSHFSCDL Ship Confirm Deliveries
WSHFSCDP Ship Confirm Departures
WSHFTMPL Departure/Delivery Templates
WSHSCOIF Interface Corrections
WSHVWSHP View Ship Information

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