-------
To provide answers to frequently asked questions (FAQs) regarding Oracle XML
Gateway.
SCOPE & APPLICATION
-------------------
The content of this Note applies to users who are using Oracle XML Gateway as part of Oracle Applications or as a standalone product.
CONTENTS
---------
1. What is XML Gateway ?
2. Which software do you need to install XML Gateway ?
3. Where can I get Oracle XML Gateway Documentation ?
4. What is Oracle XML Gateway Message Designer?
5. Which software do you need to install XML Gateway Message Builder ?
6. Which Client Platforms is XML Gateway Message Designer Certified on ?
7. What is OTA ?
8. Does OTA get configured automatically on installation of XML Gateway ?
9. Where does Workflow Bussiness Event System and Oracle workflow feature in
XML Gateway ?
10. What do the various abbreviations used in Oracle XML Gateway mean ?
11. Which Data Source and Data Target does Oracle XML Gateway Message Designer
support ?
12. Which Data types does Oracle XML Gateway support ?
13. What is the command for loading DTDs into the XML Gateway Repository ?
14. What is the command to delete a DTD from an XML Gateway Repository ?
15. What is the command to load Message Map into the XML Gateway Repository ?
16. What is the command to delete Message Map from the XML Gateway Repository ?
17. What happens when LoadMap finds a map with the same name as it is trying to load
in the repository ?
18. Why do I have to keep my DTDs and maps in sync ?
19. What standard is used for DTDs ?
20. What is a queue in XML Gateway ?
21. What are the various queues available within Oracle XML Gateway ?
22. What is a Hub in XML Gateway ?
1. What is XML Gateway?
Oracle XML Gateway is a robust tool that enables the production and consumption
of valid, well-formed XML messages between Oracle e-Business Suite and your
trading partners. The XML Gateway enables application interoperability and
integration supporting enterprise integration requirements driven by
Business-to-Business (B2B) and Application to Application (A2A) integration
requirements. XML Gateway is the core technology used for sending and
receiving OAG compliant XML documents to trading partners in Oracle Exchange.
2. Which software do you need to install XML Gateway ?
- If you are on a Oracle Applications release earlier than 11.5.7, then you need
apply the latest ECX Patchset. At the time of writing this document, this was
Patch 2206836 (ECX Patchset B). Follow Note 152775.1 for instructions on how
to install.
- If you have installed 11.5.7 Rapid Wiz, then XML Gateway is installed already.
3. Where can I get Oracle XML Gateway Documentation ?
Oracle XML Gateway Online Documentation is distributed as Patch 2245414
Oracle XML Gateway User's Guide, Release 11i. Part number A90250-01
4. What is Oracle XML Gateway Message Designer?
Message Designer is a Client side wizard-guided, GUI-oriented, repository-based
tool used to create XML message maps. Map creation consists of defining the data
source and targets, defining hierarchy and data maps between the source and target
data, plus defining actions for data transformation and process control.
5. Which software do you need to install XML Gateway Message Builder ?
At the time of writting this document, this was available as Patch 1782821.
The patch is also shipped in the same CD as Oracle Workflow Embedded release
2.6.1.5.3. Part number A91548-01
6. Which Client Platforms is XML Gateway Message Designer Certified on ?
Windows NT, Windows 98,and Windows 2000
7. What is OTA ?
OTA stands for Oracle Transport Agent.
The Transport Agent interfaces with Oracle Advanced Queuing to
deliver outbound and to receive inbound messages.
The Transport Agent server is a Java based servlet that uses the
Transport Agent Messaging Protocol to delivers and receives XML
messages using SMTP, HTTP, or HTTPS protocols.
8. Does OTA get configured automatically on installation of XML Gateway ?
No. Configuration of OTA is done manually.
Refer to Note 152775.1 or Note 162920.1 depending on your 11i Release
on how to configure OTA.
9. Where does Workflow Bussiness Event System and Oracle workflow feature in
XML Gateway ?
Oracle XML Gateway leverages the Oracle Workflow Business Event
System to publish and subscribe to application business events of
interest to automatically trigger message creation or consumption.
The XML Gateway Execution Engine interfaces with Oracle Workflow
to actively notify the XML Gateway system administrator regarding
system or process errors, or the Trading Partner contact for data errors.
10. What do the various abbreviations used in Oracle XML Gateway mean ?
DTD - Document Type Definition
BOD - Business Object Document
OAG - Open Applicatoions Group
A2A - Application to Application
B2B - Business to Business
11. Which Data Source and Data Target does Oracle XML Gateway Message Designer
support ?
Source RDBMS to Target XML
Source XML to Target RDBMS
Source XML to Target XML
12. Which Data types does Oracle XML Gateway support ?
The data types supported by the XML Gateway Execution Engine are
VARCHAR2, DATE, NUMBER, and CHAR.
13. What is the command for loading DTDs into the XML Gateway Repository ?
java LoadDTDToClob
14. What is the command to delete a DTD from an XML Gateway Repository ?
java DeleteDTDFromClob
15. What is the command to load Message Map into the XML Gateway Repository ?
java LoadMap
e.g. java LoadMap operations welcome apps04.za.oracle.com:80002:VIS
16. What is the command to delete Message Map from the XML Gateway Repository ?
java DeleteMap
e.g. java DeleteMap operations welcome apps04.za.oracle.com:8002:VIS
17. What happens when LoadMap finds a map with the same name as it is trying to load
in the repository ?
Loadmap replaces existing maps with the same name.
18. Why do I have to keep my DTDs and maps in sync ?
The reason for keeping DTDs and maps in sync is maps are created based on a
DTD and a DTD is used to validate a map. The XML message is created or
processed using the map. If a change is made to one and not the other
there is a potential for the map not to work during execution.
19. What standard is used for DTDs ?
Oracle is using the Open Applications Group (OAG) standard.
20. What is a queue in XML Gateway ?
Queues are tables on a database that are managed by Oracle Advanced Queuing.
21. What are the various queues available within Oracle XML Gateway ?
ECX_INBOUND
Inbound Message Queue.Holds all messages that enter the
process through the Transport Agent, or are placed directly on
the queue by an API.
ECX_OUTBOUND Outbound Message Queue.XML Gateway enqueues all outbound
messages that it formatted on this queue.
ECX_IN_OAG_Q Inbound Transaction Queue. Holds inbound messages that
originated from the ECX_INBOUND queue, then enqueued on this queue
by Oracle Workflow
WF_ERROR Workflow Error Queue. For errors detected by XML Gateway
or WF BES.
22. What is a Hub in XML Gateway ?
E-Business may be conducted directly with a business partner,
commonly known as a trading partner, or via a hub, such as Oracle
Exchange, where many buyers and sellers converge to conduct
electronic commerce.
Other related MetaLink documents :
1.Installing Oracle XML Gateway with Oracle Applications 11i (Note 152775.1)
2.Oracle XML Gateway post install steps for Oracle Exchange 6.2.2 (Note 171527.1)
3.Configuring Oracle XML Gateway with Oracle Applications 11.5.6 (Note 162920.1)
4.Oracle XML Gateway, an Overview (An Oracle White Paper)
.
