EBS Object Types - XML Gateway (XGM)

Oracle XML Gateway is a set of services that allows easy integration with the Oracle E-Business Suite to support XML messaging. The XML Gateway consumes events raised by the Oracle E-Business Suite and subscribes to inbound events for processing.

Object Type Identification

Files with extension .xgm are considered regardless of location.
Files with extensions .dtd, .xsl that are in the xgm folder

XML Gateway Root Source Directory on Project Properties tab defaults to xgm, but you can update if you are keeping the XML Gateway files in a different folder.

File Extensions

Name	Description
.xgm	Oracle Message Maps that are to be loaded into the XML Gateway repository
.dtd	Main and reference DTDs for a given Message Map
.xsl	XSLT style sheets used to transform an XML message for rendering

Object Type

Name	Code
XML Gateway (XGM)	XGM

Object Type Attributes

Name	Code	Description	Default Value	Supported Values
Source	SOURCE	Object Source Location Type	SCM (populating from SCM) EBS (manual creation)	SCM \| EBS
Target Location	TARGET_LOCATION	Path to where the file should be deployed to	$<PROD_TOP>/patch/115/xml Default can be changed using XML Gateway Root Destination Directory property.
Map Code	XGM_MAP_CODE	Oracle Message Map Code	`<file name> (**without path/extension)`
Delete Before Load	DELETE_BEFORE_LOAD	Delete Message Map Before Load	`false`	true \| false
Root Element	DTD_ROOT_ELEMENT_NAME	DTD Root Element Name (Required only for .dtd files)
Location	DTD_LOCATION	DTD Subdirectory Name entered in the Specify XML File and Root Element window of the wizard (Required only for .dtd files)
Application Code	XSLT_APPLICATION_CODE	XSLT Style Sheet Subdirectory (Required only for .xsl files)
Version	XSLT_VERSION	XSLT Style Sheet Version (Required only for .xsl files)

Related Project Properties

Name	Code	Description	Default Value
File Permissions	FDEBS_FILE_PERMISSIONS	Target File Permission. Will be set to target file after deployment using chmod. eg: 755

Sample Build Commands

java oracle.apps.ecx.loader.DownloadMap $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" cXML_OrderRequest

Sample Deploy Commands

cp "$SOURCE_FILE" "$XXHR_TOP/patch/115/xml/";
java oracle.apps.ecx.loader.DeleteMap $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" cXML_OrderRequest;
java oracle.apps.ecx.loader.LoadMap $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" "$XXHR_TOP/patch/115/xml/cXML_OrderRequest.xgm";
cat loader.log;
mv loader.log cXML_OrderRequest,log;