Thursday 29 October 2015

Oracle e-Commerce Gateway Tables

TABLE NAMEDESCRIPTION
ECE_ADVO_DETAILSContains the status detail for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice (857).
ECE_ADVO_DETAILS_INTERFACEContains the detail data to support the outbound Application Advice (824/APERAK) transaction.
ECE_ADVO_DETAILS_INTERFACE_XExtension table for ECE_ADVO_DETAILS_INTERFACE.
ECE_ADVO_HEADERSContains the status data for inbound transactions:  Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice (857).
ECE_ADVO_HEADERS_INTERFACEContains the header data to support the outbound Application Advice (824/APERAK) transaction.
ECE_ADVO_HEADERS_INTERFACE_XExtension table for ECE_ADVO_HEADERS_INTERFACE.
ECE_AP_CHECKS_INTERFACEContains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction.
ECE_AP_CHECKS_INTERFACE_XExtension table for ECE_AP_CHECKS_INTERFACE.
ECE_AP_INVOICES_INTERFACEContains the invoice data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction.
ECE_AP_INVOICES_INTERFACE_XExtension table for ECE_AP_INVOICES_INTERFACE.
ECE_AR_TRX_ALLOWANCE_CHARGESContains the customer invoice allowance charges information to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_ALLOWANCE_CHARGES_XExtension table for ECE_AR_TRX_ALLOWANCE_CHARGES.
ECE_AR_TRX_HEADER_1Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction.  Continuation of ECE_AR_TRX_HEADERS.
ECE_AR_TRX_HEADER_1_XExtension table for ECE_AR_TRX_HEADER_1.
ECE_AR_TRX_HEADERSContains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_HEADERS_XExtension table for ECE_AR_TRX_HEADERS.
ECE_AR_TRX_LINE_TAXContains the customer invoice line tax data to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_LINE_TAX_XExtension table for ECE_AR_TRX_LINE_TAX.
ECE_AR_TRX_LINESContains the customer invoice line data to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_LINES_XExtension table for ECE_AR_TRX_LINES.
ECE_ATTACHMENT_DETAILSContains the temporary detail data for extracting attachments.
ECE_ATTACHMENT_DETAILS_XExtension table for ECE_ATTACHMENT_DETAILS.
ECE_ATTACHMENT_HEADERSContains the temporary header data for extracting attachments.
ECE_ATTACHMENT_HEADERS_XExtension table for ECE_ATTACHMENT_HEADERS.
ECE_COLUMN_RULESContains the column rule assignments.
ECE_ERRORContains the Oracle EDI Gateway processing error messages used by Development for debugging purposes.
ECE_EXTERNAL_LEVELSContains the information about the external levels for a given transaction and map.
ECE_EXTERNAL_LEVELS_UPG 
ECE_INTERFACE_COLS_UPGContains the interface file definitions for each EDI transaction.
ECE_INTERFACE_COLUMNSContains the interface file definitions for each EDI transaction.
ECE_INTERFACE_TABLESContains the information regarding the interface and extension tables used to support each EDI transaction.
ECE_INTERFACE_TBLS_UPGContains the information regarding the interface and extension tables used to support each EDI transaction.
ECE_LEVEL_MATRICESIntersection table for ECE_INTERFACE_TABLE and ECE_EXTERNAL_LEVELS.
ECE_LEVEL_MATRICES_UPG 
ECE_MAPPINGSContains the information about maps for a given transaction.
ECE_MAPPINGS_UPGUpgrade table for ECE_MAPPINGS
ECE_MVSTO_DETAILSContains the detail level information for the outbound Movement Statistics transaction.
ECE_MVSTO_DETAILS_XExtension table for ECE_MVSTO_DETAILS.
ECE_MVSTO_HEADERSContains the movement statistics header data to support the outbound Movement Statistics transaction.
ECE_MVSTO_HEADERS_XExtension table for ECE_MVSTO_HEADERS.
ECE_MVSTO_LOCATIONSContains the location information for outbound Movement Statistics transaction.
ECE_MVSTO_LOCATIONS_XExtension table for ECE_MVSTO_LOCATIONS.
ECE_OUTPUTContains the contents of the interface file to be created by the e-Commerce Gateway extract program.
ECE_PO_DISTRIBUTIONSContains temporary project data and PO distributions to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_DISTRIBUTIONS_XExtension table for ECE_PO_DISTRIBUTIONS.
ECE_PO_INTERFACE_HEADERSContains the purchase order header data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_HEADERS_XExtension table for ECE_PO_INTERFACE_HEADERS.
ECE_PO_INTERFACE_LINESContains the purchase order line data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_LINES_XExtension table for ECE_PO_INTERFACE_LINES.
ECE_PO_INTERFACE_SHIPMENTSContains the purchase order shipment data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_SHIPMENTS_XExtension table for ECE_PO_INTERFACE_SHIPMENTS.
ECE_PO_PROJECT_INFOContains temporary project data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_PROJECT_INFO_XExtension table for ECE_PO_PROJECT_INFO.
ECE_PROC_MAPPINGS_UPGUpgrade table for ECE_PROCEDURE_MAPPINGS
ECE_PROCEDURE_MAPPINGSContains the information for calling procedures.
ECE_PROCESS_RULESContains the process rule assignements.
ECE_PROCESS_RULES_UPGUpgrade table for ECE_PROCESS_RULES
ECE_RULE_LISTContains the column list rule information.
ECE_RULE_LIST_DETAILSContains the column rule list detail information.
ECE_RULE_NULL_DEFAULTContains the column rule null default information.
ECE_RULE_NULL_DEPContains the column rule null dependency information.
ECE_RULE_NULL_DEP_DETAILSChild table to ECE_RULE_NULL_DEP.
ECE_RULE_SIMPLE_LOOKUPContains the column rule simple lookup information.
ECE_RULE_VALUESETContains the column rule valueset information.
ECE_RULE_VIOLATIONSContains the information about rule violations.
ECE_SPSO_HEADERSContains the supplier schedule header data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
ECE_SPSO_HEADERS_XExtension table for ECE_SPSO_HEADERS.
ECE_SPSO_ITEM_DETContains the supplier schedule item detail data to support outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
ECE_SPSO_ITEM_DET_XExtension table for ECE_SPSO_ITEM_DET.
ECE_SPSO_ITEMSContains the supplier schedule line data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
ECE_SPSO_ITEMS_XExtension table for ECE_SPSO_ITEMS.
ECE_SPSO_SHIP_DETECE_SPSO_SHIP_DET
ECE_SPSO_SHIP_DET_XECE_SPSO_SHIP_DET
ECE_STAGEInbound staging table.
ECE_TP_DETAILSContains the information for the trading partner processing rules.
ECE_TP_GROUPContains the information for a trading partner group representing a collection of trading partner definitions.
ECE_TP_HEADERSContains the information for trading partner address entity.
ECE_TRAN_PARAMETERSGeneric inbound/outbound execution engine seed data for the parameters corresponding to a transaction.
ECE_TRAN_STAGE_DATAContains the seed data for the dynamic execution of the inbound/outbound transactions.
ECE_TRAN_STAGE_DATA_UPG 
ECE_XREF_CATEGORIESContains the code conversion categories information.  Rows contain category code, description, and up to five processing flags.
ECE_XREF_DATAContains the information for code conversions which identify external values for a given Oracle internal value and vice versa.

1 comment:

  1. Writing with style and getting good compliments on the article is quite hard, to be honest.But you've done it so calmly and with so cool feeling and you've nailed the job. This article is possessed with style and I am giving good compliment. Best! bybit referral code

    ReplyDelete

How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>

 How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>  Sometime these xml data tags automatically chang...