You are browsing the archive for Oracle eCommerce Gateway.

Oracle eCommerce Gateway Tables

Oracle e-Commerce gateway module table information:

  • ECE_ADVO_DETAILS
  • ECE_ADVO_DETAILS_INTERFACE
  • ECE_ADVO_DETAILS_INTERFACE_X
  • ECE_ADVO_HEADERS
  • ECE_ADVO_HEADERS_INTERFACE
  • ECE_ADVO_HEADERS_INTERFACE_X
  • ECE_AP_CHECKS_INTERFACE
  • ECE_AP_CHECKS_INTERFACE_X
  • ECE_AP_INVOICES_INTERFACE
  • ECE_AP_INVOICES_INTERFACE_X
  • ECE_AR_TRX_ALLOWANCE_CHARGES
  • ECE_AR_TRX_ALLOWANCE_CHARGES_X
  • ECE_AR_TRX_HEADERS
  • ECE_AR_TRX_HEADERS_X
  • ECE_AR_TRX_HEADER_1
  • ECE_AR_TRX_HEADER_1_X
  • ECE_AR_TRX_LINES
  • ECE_AR_TRX_LINES_X
  • ECE_AR_TRX_LINE_TAX
  • ECE_AR_TRX_LINE_TAX_X
  • ECE_ATTACHMENT_DETAILS
  • ECE_ATTACHMENT_DETAILS_X
  • ECE_ATTACHMENT_HEADERS
  • ECE_ATTACHMENT_HEADERS_X
  • ECE_COLUMN_RULES
  • ECE_COLUMN_RULES_UPG
  • ECE_DSNO_ALLOWANCE_CHARGES
  • ECE_DSNO_ALLOWANCE_CHARGES_X
  • ECE_DSNO_CONTAINERS
  • ECE_DSNO_CONTAINERS_X
  • ECE_DSNO_DELIVERIES
  • ECE_DSNO_DELIVERIES_X
  • ECE_DSNO_DELIVERY_ATTRIBS
  • ECE_DSNO_DELIVERY_ATTRIBS_X
  • ECE_DSNO_ITEMS
  • ECE_DSNO_ITEMS_X
  • ECE_DSNO_ITEM_DETAILS
  • ECE_DSNO_ITEM_DETAILS_X
  • ECE_DSNO_ORDERS
  • ECE_DSNO_ORDERS_X
  • ECE_ERROR
  • ECE_EXTERNAL_LEVELS
  • ECE_EXTERNAL_LEVELS_UPG
  • ECE_INTERFACE_COLS_UPG
  • ECE_INTERFACE_COLUMNS
  • ECE_INTERFACE_TABLES
  • ECE_INTERFACE_TBLS_UPG
  • ECE_LEVEL_MATRICES
  • ECE_LEVEL_MATRICES_UPG
  • ECE_MAPPINGS
  • ECE_MAPPINGS_UPG
  • ECE_MVSTO_DETAILS
  • ECE_MVSTO_DETAILS_X
  • ECE_MVSTO_HEADERS
  • ECE_MVSTO_HEADERS_X
  • ECE_MVSTO_LOCATIONS
  • ECE_MVSTO_LOCATIONS_X
  • ECE_OUTPUT
  • ECE_PO_DISTRIBUTIONS
  • ECE_PO_DISTRIBUTIONS_X
  • ECE_PO_INTERFACE_HEADERS
  • ECE_PO_INTERFACE_HEADERS_X
  • ECE_PO_INTERFACE_LINES
  • ECE_PO_INTERFACE_LINES_X
  • ECE_PO_INTERFACE_SHIPMENTS
  • ECE_PO_INTERFACE_SHIPMENTS_X
  • ECE_PO_PROJECT_INFO
  • ECE_PO_PROJECT_INFO_X
  • ECE_PROCEDURE_MAPPINGS
  • ECE_PROCESS_RULES
  • ECE_PROCESS_RULES_UPG
  • ECE_PROC_MAPPINGS_UPG
  • ECE_RULE_LIST
  • ECE_RULE_LIST_DETAILS
  • ECE_RULE_NULL_DEFAULT
  • ECE_RULE_NULL_DEP
  • ECE_RULE_NULL_DEP_DETAILS
  • ECE_RULE_SIMPLE_LOOKUP
  • ECE_RULE_VALUESET
  • ECE_RULE_VIOLATIONS
  • ECE_SPSO_HEADERS
  • ECE_SPSO_HEADERS_X
  • ECE_SPSO_ITEMS
  • ECE_SPSO_ITEMS_X
  • ECE_SPSO_ITEM_DET
  • ECE_SPSO_ITEM_DET_X
  • ECE_SPSO_SHIP_DET
  • ECE_SPSO_SHIP_DET_X
  • ECE_STAGE
  • ECE_TP_DETAILS
  • ECE_TP_GROUP
  • ECE_TP_HEADERS
  • ECE_TRAN_PARAMETERS
  • ECE_TRAN_STAGE_DATA
  • ECE_TRAN_STAGE_DATA_UPG
  • ECE_XREF_CATEGORIES
  • ECE_XREF_DATA

E-Commerce Gateway Concurrent Programs

Oracle E-Commerce Gateway Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
ECEPOO OUT: Purchase Order (850/ORDERS)
ECEINO OUT: Invoice (810/INVOIC)
ECEPOCO OUT: Purchase Order Change (860/ORDCHG)
ECSSSO OUT: Shipping Schedule (862/DELJIT)
ECEADVO OUT: Application Advice (824/APERAK)
ECSPSO OUT: Planning Schedule (830/DELFOR)
ECEDOCID EDI Inbound Document ID
ECEREQID EDI Inbound Request ID
ECESTATUS EDI Inbound Status
ECEINI IN: Invoice (810/INVOIC)
ECCATI IN: Price Catalog (832/PRICAT)
ECERRQI IN: Response to RFQ (843/QUOTES)
ECASNI IN: Ship Notice/Manifest (856/DESADV)
ECESBNI IN: Shipment and Billing Notice (857)
ECETRANSACTION EDI Inbound Transaction
ECETPSTATUS EDI Inbound TP Status
ECRDCCV Code Conversion Values
ECRDTLD Transaction Layout Definition
ECRDIFD Interface File Data
ECRDTPT Transaction/Trading Partners
ECRDTPD Trading Partners
ECMVSTO OUT: Movement Statistics (for INTRASTAT)
ECEGPOAO OUT: OPM Purchase Order Acknowledgment (855/ORDRSP)
ECEGASNO OUT: OPM Advanced Ship Notice (856/DESADV)
ECEGPOI IN: OPM Purchase Order (850/ORDERS)
ECTRIGO Triggering Process Outbound
ECSEEDUPG Seed Data Reconciliation Process
ECEPO2I Purchase Order Inbound (Generic)
ECEPOCI IN: Purchase Order Changes (860/ORDCHG)
ECEPOAO OUT: Purchase Order Acknowledgments (855/ORDRSP)
ECEPOCAO OUT: Purchase Order Change Acknowledgments (865/ORDRSP)
ECECDMO OUT: Credit/Debit Memo (812)
WSHDSNO OUT: Ship Notice/Manifest ( 856/DESADV )
ECEPOI875 IN: Grocery Purchase Orders (875/ORDERS)
ECEPOI IN: Purchase Orders (850/ORDERS)

E-Commerce Gateway Profile Options

Oracle E-Commerce Gateway Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
ECE_PYO_ENABLED ECE: PYO Enabled
ECE_RRQI_ADDRESS_PRECEDENCE ECE: RRQI Address Precedence
ECE_RRQI_ENABLED ECE: RRQI Enabled
ECE_SBNI_ADDRESS_PRECEDENCE ECE: SBNI Address Precedence
ECE_SBNI_ENABLED ECE: SBNI Enabled
ECE_SPSI_ENABLED ECE: SPSI Enabled
ECE_SPSO_ENABLED ECE: SPSO Enabled
ECE_SSSI_ENABLED ECE: SSSI Enabled
ECE_SSSO_ENABLED ECE: SSSO Enabled
ECE_CDMO_ENABLED ECE: CDMO Enabled
ECE_DSNO_DEBUG_MODE ECE: DSNO Debug Mode
ECE_POCAO_DEBUG_MODE POCAO: Debug Mode
ECE_POCI_ADDRESS_PRECEDENCE ECE: POCI Address Precedence
ECE_POAO_DEBUG_MODE POAO: Debug Mode
ECE_PRPO_ENABLED ECE: PRPO Enabled
ECE_POI_ADDRESS_PRECEDENCE ECE: POI Address Precedence
ECE_POI_ENABLED ECE: POI Enabled
ECE_DSNO_ENABLED ECE: DSNO Enabled
ECE_SPSO_EXCLUDE_ZERO_SCHEDULE_FROM_FF ECE: SPSO Exclude Zero Schedule From Flat File
ECE_PYO_DEBUG_MODE ECE: PYO Debug Mode
ECE_ADVO_ENABLED ECE: ADVO Enabled
ECE_ASNI_ADDRESS_PRECEDENCE ECE: ASNI Address Precedence
ECE_ASNI_ENABLED ECE: ASNI Enabled
ECE_ATT_SPLIT_WORD_ALLOWED ECE: Split Word Allowed
ECE_CATI_ADDRESS_PRECEDENCE ECE: CATI Address Precedence
ECE_CATI_ENABLED ECE: CATI Enabled
ECE_GASNO_ENABLED ECE: GASNO Enabled
ECE_GPOAO_ENABLED ECE: GPOAO Enabled
ECE_GPOI_ADDRESS_PRECEDENCE ECE: GPOI Address Precedence
ECE_GPOI_ENABLED ECE: GPOI Enabled
ECE_INI_ADDRESS_PRECEDENCE ECE: INI Address Precedence
ECE_INI_ENABLED ECE: INI Enabled
ECE_INO_ENABLED ECE: INO Enabled
ECE_IN_FILE_PATH ECE: Input File Path
ECE_MVSTO_ENABLED ECE: MVSTO Enabled
ECE_OUT_FILE_PATH ECE: Output File Path
ECE_POAO_ENABLED ECE: POAO Enabled
ECE_POCAO_ENABLED ECE: POCAO Enabled
ECE_POCI_ENABLED ECE: POCI Enabled
ECE_POCO_ATT_SEG_SIZE ECE: POCO Attachment Segment
ECE_POCO_ENABLED ECE: POCO Enabled
ECE_POCO_HEAD_ATT ECE: POCO Header Attachment Enabled
ECE_POCO_IITEM_ATT ECE: POCO Inventory Item Attachment Enabled
ECE_POCO_LINE_ATT ECE: POCO Line Attachment Enabled
ECE_POCO_MITEM_ATT ECE: POCO Master Item Attachment Enabled
ECE_POCO_SHIP_ATT ECE: POCO Shipment Attachment Enabled
ECE_POO_ATT_SEG_SIZE ECE: POO Attachment Segment Size
ECE_POO_ENABLED ECE: POO Enabled
ECE_POO_HEAD_ATT ECE: POO Header Attachment Enabled
ECE_POO_IITEM_ATT ECE: POO Inventory Item Attachment Enabled
ECE_POO_LINE_ATT ECE: POO Line Attachment Enabled
ECE_POO_MITEM_ATT ECE: POO Master Item Attachment Enabled
ECE_POO_SHIP_ATT ECE: POO Shipment Attachment Enabled
ECE_PSQI_ENABLED ECE: PSQI Enabled