Monday, June 30, 2014

Oracle XML Gateway Tables : The Backend View

--Setup Transaction Type - Back-end Tables
select * from ecx_transactions;
select * from ecx_transactions_vl;
select * from ecx_transactions_b;

--Setup Trading Partner - Back-end Tables
select * from ecx_tp_headers;
select * from ecx_tp_details;

--Get all the details in one go here
select * from ecx_tp_details_v;


--XML Gateway map tables
select * from ecx_dtds;
select * from ecx_mappings;

--Mapping Tables
select * from ecx_proc_mappings; --Procedure Mappings
select * from ecx_attribute_mappings;
select * from ecx_level_mappings ;


--Run Time Tables
select * from ecx_doclogs;
select * from ecx_error_msgs;
select * from ecx_inbound_logs;
select * from ecx_msg_logs;

Reactions:

0 comments:

Post a Comment