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
| Tip |
|---|
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
| Code Block | ||||
|---|---|---|---|---|
| ||||
java oracle.apps.ecx.loader.DownloadMap $FDEBS_DB_USER "$FDEBS_DB_PASSWORD" "$AD_APPS_JDBC_URL" cXML_OrderRequest |
Sample Deploy Commands
| Code Block | ||||
|---|---|---|---|---|
| ||||
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; |
...