You are browsing the archive for ECE.

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 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

Views in E-Commerce Gateway Module

Views in Oracle E-Commerce Gateway Module

ECE_ADVO_DETAILS_V
ECE_ADVO_HEADERS_V
ECE_ATTACHMENT_V
ECE_CDMO_ALLOWANCE_CHARGES_V
ECE_CDMO_HEADER_1_V
ECE_CDMO_HEADER_V
ECE_CDMO_LINE_TAX_V
ECE_CDMO_LINE_V
ECE_CDMO_TRX_NUMBER_V
ECE_INO_ALLOWANCE_CHARGES_V
ECE_INO_HEADER_1_V
ECE_INO_HEADER_V
ECE_INO_LINE_TAX_V
ECE_INO_LINE_V
ECE_LOOKUP_VALUES
ECE_MTL_MOV_STAT_V
ECE_MVSTO_DETAILS_V
ECE_MVSTO_HEADERS_V
ECE_MVSTO_LOCATIONS_V
ECE_PO_DISTRIBUTIONS_V
ECE_PO_PROJECT_INFO_V
ECE_POCO_HEADERS_V
ECE_POCO_LINES_V
ECE_POCO_SHIPMENTS_V
ECE_POO_HEADERS_V
ECE_POO_LINES_V
ECE_POO_SHIPMENTS_V
ECE_PROFILE_OPTIONS
ECE_PYO_INVOICE_V
ECE_PYO_PAYMENT_V
ECE_SPSO_HEADERS_V
ECE_SPSO_ITEMS_V
ECE_SSSO_HEADERS_V
ECE_SSSO_ITEMS_V
ECE_STAGE_LEVEL1_V
ECE_STAGE_LEVEL2_V