EC — e-Commerce Gateway
83 documented tables · 51 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
ECE_TP_GROUP |
Contains the information for a trading partner group representing a collection of trading partner definitions. | hub-leaning |
ECE_TP_HEADERS |
Contains the information for trading partner address entity. | hub-leaning |
ECE_XREF_CATEGORIES |
Contains the code conversion categories information. Rows contain category code, description, and up to five | hub-leaning |
ECE_RULE_NULL_DEP |
Contains the column rule null dependency information. | hub-leaning |
ECE_RULE_LIST |
Contains the column list rule information. | hub-leaning |
ECE_ADVO_HEADERS |
Contains the status data for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) an | hub-leaning |
ECE_INTERFACE_TABLES |
Contains the information regarding the interface and extension tables used to support each EDI transaction. | hub-leaning |
ECE_AP_CHECKS_INTERFACE |
Contains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction. | standalone |
ECE_ADVO_DETAILS |
Contains the status detail for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) a | satellite-leaning |
ECE_MAPPINGS_UPG |
Upgrade table for ECE_MAPPINGS | standalone |
ECE_AP_CHECKS_INTERFACE_X |
Extension table for ECE_AP_CHECKS_INTERFACE. | standalone |
ECE_ADVO_HEADERS_INTERFACE |
Contains the header data to support the outbound Application Advice (824/APERAK) transaction. | standalone |
ECE_SPSO_ITEM_DET_X |
Extension table for ECE_SPSO_ITEM_DET. | standalone |
ECE_SPSO_SHIP_DET |
ECE_SPSO_SHIP_DET | standalone |
ECE_RULE_NULL_DEP_DETAILS |
Child table to ECE_RULE_NULL_DEP. | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
EC_APPLICATION_ADVICE_PUB |
PUB | 2 | 1 packages |