Thursday 29 October 2015

EDI Gateway Terminology

TerminologyDescription
ACH Business enterprise through which banking transactions are routed.
AIAG Automotive Industry Action Group. An organization that designs and maintains EDI transaction sets for the automotive industry. Also the name of the X12 subset used by the automotive industry
ANSI American national Standards Institute. An organization that maintains standards on many different topics.
ANSI ASC X12 ANSI Accredited Standards Committee X12. The ANSI subcommittee appointed to develop standards for EDI in North America.
ASN Advance Shipment Notice. The EDI document transmitted from a supplier to its customer to describe a pending shipment.
Business Process Re-engineering The modification of computer applications and related procedures in order to streamline processing.
Communications Software Software to electronically link two computers for the exchange of information.
Compliance Checking Comparison of EDI data being sent or received with the applicable EDI standard. Normally part of the EDI translation process.
Data Mapping Provides significant enhancement and transformation of data from multiple sources to multiple target formats. For example, converting a purchase order file in a proprietary format to a set of EDI purchase order transactions.
DEX/UCS Direct Exchange UCS. EDI transaction sets used by the direct store delivery segment of the grocery industry.
DISA Data Interchange Standards Association. The organization responsible for performing the administrative duties of the ANSI X12 subcommittee.
Download The transfer of data from a large computer to a smaller computer used for front-end or back-end processing.
DSD Direct Store Delivery
EAGLE An EDI standard developed and used by the hardware and houseware industry. Part of X12.
EC Electronic Commerce. The conducting of business through electronic means such as EDI, E-mail, fax and file transfer.
ECR Efficient Consumer Response. Technologies, procedures and practices used in the grocery industry to eliminate supply chain waste and inefficiencies.
EDI Electronic Data Interchange. The computer-to-computer transfer of business transactions using standard, industry-accepted message formats.
EDI Document An EDI transaction set.
EDI Translator See translation software.
EDI VAN See Value Added Network.
EDIA Electronic Data Interchange Association. The organization that wrote the original UCS and WINS standards. It currently acts as Secretariat for the EDI standards for the Ocean, Rail, Motor and Air industries.
EDICA Electronic Data Interchange Council of Australia. The Australian EDI administrative organization.
EDICC Electronic Data Interchange Council of Canada. The Canadian EDI administrative organization.
EDIFACT EDI for Administration, Commerce and Transport. Also known as UN/EDIFACT. The international EDI standard developed through the United Nations and administered in the U.S. by DISA.
EDX Electrical Industry Data Exchange. The organization which develops EDI data requirements for the electrical industry and represents the industry regarding maintenance of the X12 standard.
E-form Electronic Form. Usually refers to a computerized version of a paper form.
EFT Electronic Funds Transfer. Computerized systems for processing transactions between financial institutions. The electronic transfer of funds through the banking system.
EIDX Electronics Industry Data Exchange. The organization which develops EDI data requirements for the electronics industry and represents the industry regarding maintenance of the X12 standard.
Encryption A procedure for scrambling data to make it indecipherable to an outside observer. The receiver of the encrypted data must use a decryption procedure to unscramble the data.
File A collection of related records which serves as a basic unit of storage in a computer system.
Financial EDI EDI activity that supports financial activities such as billing, paying, and reconciliation.
Functional Acknowledgment An EDI transaction set sent to acknowledge the receipt of a prior transaction set.
GAS*FLOW The mission of the Natural Gas Electronic Data Interchange (EDI) Pilot was to bring together a group of companies performing different roles in the transportation of natural gas to test and validate the use of the GAS*FLOW EDI Implementation Guide.
HCFA Health Care Finance Administration. Government agency responsible for implementing laws relative to Medicare and Medicaid transaction and information reporting.
Hub Larger organizations that encourage their paper-based business partners to begin using EDI. Wal-Mart and General Mills are examples of hubs.
Implementation Guide A publication that documents the EDI messages used by a particular industry or company.
Integrated EDI An approach to EDI implementation requiring no human involvement in the computer-to-computer exchange of data.
Interconnect The transmission of EDI data from one VAN to another. Enables trading partners to use different VANs.
ISO International Standards organization. An organization that works with the UN to maintain the standards for all applications of technology and mechanics for furthering global industry.
Just-In-Time Also JIT. A business approach that assures the receipt of a product at a manufacturing site just in time to be used in the manufacturing process.
Kit An EDI software solution that has been pre-configured according to the EDI specification of a hub organization in order to simplify EDI implementation.
LAN Local Area Network. A network of computers that enables access to the same computer software and files from all locations.
Mailbox A file storage area where data is placed until it can be retrieved by the intended receiver.
NEX/UCS Network Exchange UCS. Refers to EDI transaction sets used in the direct store delivery segment of the grocery industry.
Odette An EDI standard used by the European automotive industry.
PIDX Petroleum Industry Data Exchange. The organization which develops EDI data requirements for the petroleum industry and represent the industry regarding maintenance of the X12 standard.
Point of Sale Also POS. A computer application that enables the seller to collect product identification information at the time of sale.
Point to Point Refers to a type of communication where messages are sent directly from one trading partner to another without the use of a VAN.
Proprietary Data Format A format that does not comply with X12 or EDIFACT standards. Usually a data format specific to a company or application.
Proprietary Standards Industry specific or company specific data formats that does not comply with X12 or EDIFACT standards.
Protocol A set of conventions between communication devices that validates the format and content of messages to be exchanged, and controls the communication session.
Quick Response Also QR. Refers to technologies, procedures and practices used in the retail industry to eliminate supply chain waste and inefficiencies.
Re-engineering The modification of computer applications and related procedures in order to streamline processing.
Stand-alone EDI An approach to EDI implementation where the EDI software is not linked to computer applications.
Standard Something established for use as a rule. Within EDI, the agreed-to format for exchanging business transactions.
TDCC Transportation Data Coordinating Committee. The organization within the U.S. originally responsible for developing EDI and furthering its growth.
Tradacoms Message standards for data interchange between major UK retailers and suppliers.
Trading Partner A customer, supplier or other partner with whom business is conducted using EDI.
Transaction Set The EDI equivalent of a complete business documents such as an invoice, a purchase order, or a remittance advice.
Translation Software A program used to convert data to and from EDI formats.
UCC Uniform Code Council. The organization that administers the UPC symbols and other retail bar code and retail standards.
UCS Uniform Communication Standard. An EDI standard designed for and used by trading partners within the grocery industry.
UPC Universal Product Code. A code that uniquely identifies a product. Used extensively in the retail and grocery industries.
VAN Value-added Network.
VICS Voluntary Inter-industry Communication Standard. A committee active in EDI on behalf of the retail industry. Also the name of standards (now part of X12) that were developed by that group.
WINS Warehouse Information Network Standard. A standard developed to support warehouse applications. Now part of X12.
X12 Standards A public EDI implementations widely used in North America. The standard incorporates many industry-related standards such as VICS, WINS, AIAG, PIDX, EIDX and UCS.
Year 2000 A set of issues pertaining to the format of dates when 19 cannot be assumed to be the first two digits of the year.

Oracle e-Commerce Gateway Views

VIEW NAMEDESCRIPTION
ECE_ADVO_DETAILS_VThis view extracts advice detailsfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Details View@rep:category BUSINESS_ENTITY EC_APPLICATION
ECE_ADVO_HEADERS_VThis view extracts advice header informationfor the outbound Application Advice (824/APERAK) transaction.@rep:scope private@rep:product EC@rep:lifecycle active@rep:displayname Application Advice Header View@rep:category BUSINESS_ENTITY EC_A
ECE_ATTACHMENT_V/*#* This view extracts attachment data* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* The attachment view is used for header, line, shipment, distribution, item and master item
ECE_CDMO_ALLOWANCE_CHARGES_VThis view extracts allowance and charges informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.The allowance and charges view is used for both the header and line level data.@rep:scope private@rep:product AR@rep:life
ECE_CDMO_HEADER_1_VThis view extracts additional header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header Attributes View@rep:category 
ECE_CDMO_HEADER_VThis view extracts header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header View@rep:category BUSINESS_ENTITY AR_CRE
ECE_CDMO_LINE_TAX_VThis view extracts line tax informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Line Tax View@rep:category BUSINESS_ENTITY AR
ECE_CDMO_LINE_VThis view extracts line informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Line View@rep:category BUSINESS_ENTITY AR_CREDIT_
ECE_CDMO_TRX_NUMBER_VContains the credit/debit memo number for the customer for outbound Credit/Debit Memo  (812 - CREADV / DEBADV) transaction.
ECE_INO_ALLOWANCE_CHARGES_VThis view extracts allowance and charge informationfor the outbound Invoice (810/INVOIC) transaction.The allowance and charges view is used for both header and line level data.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displ
ECE_INO_HEADER_1_VThis view extracts additional header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header Attributes View@rep:category BUSINESS_ENTITY AR_INVOICE
ECE_INO_HEADER_VThis view extracts header informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Header View@rep:category BUSINESS_ENTITY AR_INVOICE
ECE_INO_LINE_TAX_VThis view extracts line tax informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Line Tax View@rep:category BUSINESS_ENTITY AR_INVOICE
ECE_INO_LINE_VThis view extracts line informationfor the outbound Invoice (810/INVOIC) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Invoice Line View@rep:category BUSINESS_ENTITY AR_INVOICE
ECE_LOOKUP_VALUESView of FND_LOOKUP_VALUES table.
ECE_MTL_MOV_STAT_VContains the movement type information for documents with EDI transactions pending.
ECE_MVSTO_DETAILS_VThis view extracts line informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Line View@rep:category BUSINESS_ENTITY INV_MOVEMENT_
ECE_MVSTO_HEADERS_VThis view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM
ECE_MVSTO_LOCATIONS_VThis view extracts line location informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Line Location View@rep:category BUSINESS_EN
ECE_POCO_HEADERS_VThis view extracts header informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Header View@rep:category BUSINESS_ENTITY PO_PU
ECE_POCO_LINES_VThis view extracts line informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Line View@rep:category BUSINESS_ENTITY PO_PURCHA
ECE_POCO_SHIPMENTS_VThis view extracts shipment informationfor the outbound Purchase Order Change (860/ORDCHG) transaction.@rep:scope private@rep:product PO@rep:lifecycle active@rep:displayname Purchase Order Change Shipment View@rep:category BUSINESS_ENTITY P
ECE_POO_HEADERS_V/*#* This view extracts header information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO * @rep:lifecycle active* @rep:displayname Purchase Order Header View* @rep:category BUSINESS_ENTI
ECE_POO_LINES_V/*#* This view extracts line information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Line View* @rep:category BUSINESS_ENTITY PO_PUR
ECE_POO_SHIPMENTS_V/*#* This view extracts shipment information* for the outbound Purchase Order (850/ORDERS) transaction.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purchase Order Shipment View* @rep:category BUSINESS_ENTIT
ECE_PO_DISTRIBUTIONS_V/*#* This view extracts distribution information* for the outbound Purchase Order (850/ORDERS) and* outbound Purchase Order Change (860/ORDCHG) transactions.* @rep:scope private* @rep:product PO* @rep:lifecycle active* @rep:displayname Purc
ECE_PO_PROJECT_INFO_VContains the project level data for the the Purchase Order (850/ORDERS) and the Purchase Order Changes (860/ORDCHG) transactions.
ECE_PRIMARY_CONTACT_PHONE_V 
ECE_PRIMARY_CUSTOMER_PHONE_V 
ECE_PROFILE_OPTIONSView on FND_PROFILE_OPTIONS_VL and FND_PROFILE_OPTIONS_VALUES tables
ECE_PYO_INVOICE_VThis view extracts invoices selected for payment to supportthe outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice I
ECE_PYO_PAYMENT_VThis view extracts payment informationfor the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.@rep:scope private@rep:product AP@rep:lifecycle active@rep:displayname Payment Order/Remittance Advice Payment View@rep:c
ECE_RCO_ADDRESS 
ECE_RSU_CONTACT 
ECE_RSU_NOCONTACT 
ECE_SPSO_HEADERS_VThis view extracts header informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Planning Schedule Header View@rep:category BUSINESS_ENTITY CHV_PLANNING
ECE_SPSO_ITEMS_VThis view extracts item informationfor the outbound Planning Schedule (830/DELFOR) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Planning Schedule Item View@rep:category BUSINESS_ENTITY CHV_PLANNING_SCH
ECE_SSSO_HEADERS_VThis view extracts header informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Shipping Schedule Header View@rep:category BUSINESS_ENTITY CHV_SHIPPING
ECE_SSSO_ITEMS_VThis view extracts item informationfor the outbound Shipping Schedule (862/DELJIT) transaction.@rep:scope private@rep:product CHV@rep:lifecycle active@rep:displayname Shipping Schedule Item View@rep:category BUSINESS_ENTITY CHV_SHIPPING_SCH
ECE_STAGE_LEVEL1_VECE_STAGE_LEVEL1_V  is used in ECERNCON.fmb to retrieve the
ECE_STAGE_LEVEL2_VECE_STAGE_LEVEL2_V  is used in ECERNCON.fmb to retrieve

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.

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