Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
F
Appendix: Publication Tables and Triggers
MFQUEUE Triggers
The following table contains the list of MFQUEUE triggers in Merchandising, as well as the queue tables that are written to if the triggers are not disabled. As noted above, you should disable these triggers prior to converting Merchandising data and re-enable once conversion is complete. If triggers are not disabled, then the queue tables must be cleared prior to lift and shift.
| Merchandising Base Table | Trigger Name | Queue Table |
|---|---|---|
| ADDR | EC_TABLE_ADR_AIUDR | SUPPLIER_MFQUEUE |
| DE_TABLE_ADDR_AIUDR | WH_MFQUEUE | |
| STORE_MFQUEUE PARTNER_MFQUEUE | ||
| ADDR_CFA_EXT | EC_TABLE_ACE_AIUR | SUPPLIER_MFQUEUE WH_MFQUEUE STORE_MFQUEUE PARTNER_MFQUEUE |
| ALLOC_DETAIL | EC_TABLE_ALD_AIUDR | ALLOC_MFQUEUE |
| ALLOC_HEADER | EC_TABLE_ALH_AIUDR | ALLOC_MFQUEUE |
| AREA | EC_TABLE_ARE_AIUDR DE_TABLE_AREA_AIUDR | ORGHIER_MFQUEUE |
| BANNER | EC_TABLE_BAN_AIUDR | BANNER_MFQUEUE |
| BRAND | EC_TABLE_BRAND_AIUDR | BRAND_MFQUEUE |
| CHAIN | EC_TABLE_CHA_AIUDR DE_TABLE_CHA_AIUDR | ORGHIER_MFQUEUE |
| CHANNELS | EC_TABLE_CHN_AIUDR | BANNER_MFQUEUE |
| CLASS | EC_TABLE_CLA_AIUDR DE_TABLE_CLS_AIUDR | MERCHHIER_MFQUEUE |
| CLASS_CFA_EXT | EC_TABLE_CCE_AIUR | MERCHHIER_MFQUEUE |
| CODE_DETAIL | EC_TABLE_CODEDTL_AIUDR | CODES_MFQUEUE |
| CODE_HEAD | EC_TABLE_CODEHD_AIUDR | CODES_MFQUEUE |
| COMPANY_CLOSED | EC_TABLE_CO_CLOSE_AIUDR | COMPANY_CLOSED_MFQUEUE |
| COMPANY_CLOSED_EXCEP | EC_TABLE_CCEXP_AIUDR | COMPANY_CLOSED_EXCEP_MFQUE UE |
| COMPHEAD | DE_TABLE_CO_AIUR | |
| COUNTRY | EC_TABLE_CNT_AIUDR | SEEDOBJ_MFQUEUE |
| DELIVERY_SLOT | EC_TABLE_DLVY_AIUDR | DELIVERY_SLOT_MFQUEUE |
June 3, 2026 Appendix F-1 of F-5
Appendix F MFQUEUE Triggers
| Merchandising Base Table | Trigger Name | Queue Table |
|---|---|---|
| DEPS | EC_TABLE_DEP_AIUDR DE_TABLE_DEPT_AIUDR | MERCHHIER_MFQUEUE |
| DEPS_CFA_EXT | EC_TABLE_DCE_AIUR | MERCHHIER_MFQUEUE |
| DIFF_GROUP_DETAIL | EC_TABLE_DGD_AIUDR DE_TABLE_DGDTL_AIUDR | DIFFGRP_MFQUEUE |
| DIFF_GROUP_HEAD | EC_TABLE_DGH_AIUDR DE_TABLE_DGHEAD_AIUDR | DIFFGRP_MFQUEUE |
| DIFF_IDS | EC_TABLE_DID_AIUDR DE_TABLE_DIFF_AIUDR | DIFFID_MFQUEUE |
| DIFF_TYPE | EC_TABLE_DIFF_TYPE_AIUDR | DIFFTYPE_MFQUEUE |
| DISTRICT | EC_TABLE_DIS_AIUDR DE_TABLE_DIS_AIUDR | ORGHIER_MFQUEUE |
| DIVISION | EC_TABLE_DIV_AIUDR DE_TABLE_DIVI_AIUDR | MERCHHIER_MFQUEUE |
| GROUPS | EC_TABLE_GRO_AIUDR DE_TABLE_GRP_AIUDR | MERCHHIER_MFQUEUE |
| ITEM_IMAGE | EC_TABLE_IIM_AIUDR | ITEM_MFQUEUE |
| ITEM_LOC | EC_TABLE_ITL_AIUDR DE_TABLE_IL_AIUDR | ITEMLOC_MFQUEUE |
| ITEM_LOC_CFA_EXT | EC_TABLE_ILE_AIUR | ITEMLOC_MFQUEUE |
| ITEM_LOC_SOH | EC_TABLE_ILS_AUR | ITEM_LOC_SOH_MFQUEUE |
| ITEM_LOC_TRAITS | EC_TABLE_ILT_AIUDR DE_TABLE_ILT_AIUDR | ITEMLOC_MFQUEUE |
| ITEM_MASTER | EC_TABLE_IEM_AIUDR DE_TABLE_IM_AIUDR | ITEM_MFQUEUE |
| ITEM_MASTER_CFA_EXT | EC_TABLE_IME_AIUR | ITEM_MFQUEUE |
| ITEM_SUPP_COUNTRY | EC_TABLE_ISC_AIUDR | ITEM_MFQUEUE |
| ITEM_SUPP_COUNTRY_CFA_EXT | EC_TABLE_ICE_AIUR | ITEM_MFQUEUE |
| ITEM_SUPP_COUNTRY_DIM | EC_TABLE_ISD_AIUDR | ITEM_MFQUEUE |
| ITEM_SUPP_MANU_COUNTRY | EC_TABLE_ISMC_AIUDR | ITEM_MFQUEUE |
| ITEM_SUPP_UOM | EC_TABLE_ISU_AIUDR | ITEM_MFQUEUE |
| ITEM_SUPPLIER | EC_TABLE_ISP_AIUDR | ITEM_MFQUEUE |
| ITEM_SUPPLIER_CFA_EXT | EC_TABLE_ISE_AIUR | ITEM_MFQUEUE |
| ITEM_TICKET | EC_TABLE_ITK_AIDR | ITEM_MFQUEUE |
| LOCATION_CLOSED | EC_TABLE_LCLS_AIUDR | LOCATION_CLOSED_MFQUEUE |
| ORDCUST | EC_TABLE_ORC_AUR | TSF_MFQUEUE |
| ORDCUST_PUB_TEMP | EC_TABLE_ORP_AIR | |
| ORDHEAD | EC_TABLE_OHE_AIUDR | ORDER_MFQUEUE |
| ORDHEAD_CFA_EXT | EC_TABLE_OCE_AIUR | ORDER_MFQUEUE |
| ORDLOC | EC_TABLE_OLO_AIUDR | ORDER_MFQUEUE |
| ORDLOC_CFA_EXT | EC_TABLE_OLE_AIUR | ORDER_MFQUEUE |
| ORDSKU_CFA_EXT | EC_TABLE_ORE_AIUR | ORDER_MFQUEUE |
June 3, 2026 Appendix F-2 of F-5
Appendix F MFQUEUE Triggers
| Merchandising Base Table | Trigger Name | Queue Table |
|---|---|---|
| OWNERSHIP_PUB_GTT | EC_TABLE_OPT_AIR | |
| PACKITEM_BREAKOUT | EC_TABLE_PKS_AIUDR EC_TABLE_PKS_IUDS | ITEM_MFQUEUE |
| PARTNER | EC_TABLE_PRT_AIUDR | PARTNER_MFQUEUE |
| PARTNER_CFA_EXT | EC_TABLE_PCE_AIUR | PARTNER_MFQUEUE |
| PARTNER_ORG_UNIT | EC_TABLE_POU_AIUDR | SUPPLIER_MFQUEUE |
| PHASES | EC_TABLE_PHS_AIUDR | SEASON_MFQUEUE |
| REGION | EC_TABLE_REG_AIUDR DE_TABLE_REG_AIUDR | ORGHIER_MFQUEUE |
| RELATED_ITEM_DETAIL | EC_TABLE_RID_AIUDR DE_TABLE_RID_AIUDR | ITEM_MFQUEUE |
| RELATED_ITEM_HEAD | EC_TABLE_RIH_AIUDR DE_TABLE_RIH_AIUDR | ITEM_MFQUEUE |
| REPL_ITEM_LOC | EC_TABLE_RIL_AIUDR | ITEMLOC_MFQUEUE |
| RTV_DETAIL | EC_TABLE_RDT_AIUDR | RTVREQ_MFQUEUE |
| RTV_HEAD | EC_TABLE_RHD_AIUDR | RTVREQ_MFQUEUE |
| RTV_HEAD_CFA_EXT | EC_TABLE_RCE_AIUR | RTVREQ_MFQUEUE |
| RUA_RIB_INTERFACE | EC_TABLE_RUA_AIR | RUA_MFQUEUE |
| SEASONS | EC_TABLE_SSN_AIUDR | SEASON_MFQUEUE |
| SHIPMENT_PUB_TEMP | EC_TABLE_SPT_AIR | |
| STORE | EC_TABLE_STR_AIUDR DE_TABLE_STORE_AIUDR | STORE_MFQUEUE |
| STORE_CFA_EXT | EC_TABLE_STE_AIUR | STORE_MFQUEUE |
| STORE_HOURS | EC_TABLE_STHR_AIUR | STORE_MFQUEUE |
| SUBCLASS | EC_TABLE_SCL_AIUDR DE_TABLE_SCLS_AIUDR | MERCHHIER_MFQUEUE |
| SUBCLASS_CFA_EXT | EC_TABLE_SCL_AIUR | MERCHHIER_MFQUEUE |
| SUPS | EC_TABLE_SUP_AIUDR | SUPPLIER_MFQUEUE |
| SUPS_CFA_EXT | EC_TABLE_SCE_AIUR | SUPPLIER_MFQUEUE |
| TSFDETAIL | EC_TABLE_TDT_AIUDR | TSF_MFQUEUE |
| TSFHEAD | EC_TABLE_THD_AIUDR | TSF_MFQUEUE |
| WOOUT_MFQUEUE | ||
| TSFHEAD_CFA_EXT | EC_TABLE_TCE_AIUR | TSF_MFQUEUE |
| UDA | EC_TABLE_UDA_AIUDR | UDA_MFQUEUE |
| UDA_ITEM_DATE | EC_TABLE_UIT_AIUDR | ITEM_MFQUEUE |
| UDA_ITEM_FF | EC_TABLE_UIF_AIUDR | ITEM_MFQUEUE |
| UDA_ITEM_LOV | EC_TABLE_UIL_AIDR | ITEM_MFQUEUE |
| UDA_VALUES | EC_TABLE_UDV_AIUDR | UDA_MFQUEUE |
| VAT_CODE_RATES | DE_TABLE_VCR_AIUDR | |
| VAT_CODES | DE_TABLE_VC_AUDR |
June 3, 2026 Appendix F-3 of F-5
Appendix F Publication Tables
| Merchandising Base Table | Trigger Name | Queue Table |
|---|---|---|
| VAT_ITEM | EC_TABLE_VI_AIUDR | ITEM_MFQUEUE |
| DE_TABLE_VI_AIUDR | ||
| VAT_REGION | DE_TABLE_VR_AIUDR | |
| WH | EC_TABLE_WH_AIUDR | WH_MFQUEUE |
| DE_TABLE_WHOUSE_AIUDR | ||
| WH_ADD | EC_TABLE_WHA_AIUR | WH_MFQUEUE |
| WH_CFA_EXT | EC_TABLE_WCE_AIUR | WH_MFQUEUE |
| WO_DETAIL | EC_TABLE_WDL_AIUDR | WOIN_MFQUEUE |
Publication Tables
Below tables contain publish indicators used for setting up the converted data for future publication to downstream systems for any changes after you start using Merchandising in production. For tables that end in *_PUB_INFO or *DETAILS_PUBLISHED, records must be loaded into these tables for the converted data with a published flag set to Y. In other cases, the entity table itself (for example, ADDR) holds the publication flag. If this was not already set to Y as part of your conversion, this should be updated.
| Functional Area | Publication Table |
|---|---|
| Address | ADDR |
| Allocations | ALLOC_PUB_INFO |
| ALLOC_DETAILS_PUBLISHED | |
| Items | ITEM_PUB_INFO |
| Partners | PARTNER_PUB_INFO |
| Purchase Orders | ORDER_PUB_INFO ORDER_DETAILS_PUBLISHED ORDCUST_PUB_INFO |
| RTVs | RTVREQ_PUB_INFO RTV_DETAIL |
| Shipments | SHIPMENT_PUB_INFO |
| Stores | STORE_PUB_INFO |
| Transfers | TRANSFERS_PUB_INFO TSFDETAIL |
| ORDCUST_PUB_INFO | |
| TSF_PACKING | |
| TSF_WO_DETAIL | |
| TSF_XFORM_DETAIL WOOUT_PUB_INFO | |
| Warehouses | WH_PUB_INFO |
| Purchase Order Work Orders | WO_DETAIL |
June 3, 2026 Appendix F-4 of F-5
Appendix F Publication Tables
Note
Data Conversion for most inventory transactions is not support by the tool. It is expected transactions such as RTVs, transfers and allocations are closed in legacy before cutover. However, if you migrate inventory transaction using custom conversion scripts, you are required to clear the queue tables and load PUB_INFO* tables with the published flag set to Y.
June 3, 2026 Appendix F-5 of F-5
In this guide
- Guide: Merchandising Cloud Services Data Conversion Implementation Guide
- Previous: E Appendix: Conversion APIs
- Next: G Appendix: Tables List
Related chapters
- 3 Custom Validation Rules — Merchandising Cloud Services Customization and Extension Guide · shares
ALLOC_DETAIL,ALLOC_HEADER,CLASS_CFA_EXT,DEPS_CFA_EXT - G Appendix: Tables List — Merchandising Cloud Services Data Conversion Implementation Guide · shares
ADDR_CFA_EXT,CLASS_CFA_EXT,DEPS_CFA_EXT,DIFF_GROUP_DETAIL - 5 ReSTful Web Services — Inbound and Outbound Integration Guide · shares
ADDR_CFA_EXT,ALLOC_DETAIL,ALLOC_HEADER,CLASS_CFA_EXT - 13 Transfers, Allocation, and RTV — Batch Operations Guide · shares
ALLOC_DETAIL,ALLOC_HEADER,ALLOC_MFQUEUE,ORDCUST_PUB_INFO - 6 Scheduled Integration — Inbound and Outbound Integration Guide · shares
CODE_DETAIL,CODE_HEAD,COMPANY_CLOSED,DELIVERY_SLOT - 8 Task Execution Engine — Merchandising Cloud Services Data Conversion Implementation Guide · shares
EC_TABLE_ISU_AIUDR,EC_TABLE_UIF_AIUDR,EC_TABLE_UIL_AIDR,EC_TABLE_VI_AIUDR