This appendix covers the following topics:
TBI provides predefined maps and the corresponding DTDs for the XML Gateway. All the maps and DTDs are automatically loaded into the XML Gateway repository during the installation process and attached to the transactions in the XML Gateway.
The map files are located at $XNB_TOP/patch/115/xml/US. $XNB_TOP is the top level folder for the TBI related files.
The DTD files for TBI and OAGIS are located in $XNB_TOP/xml/oag72.
The following table lists the maps in XML Gateway.
Supported Flow | Map Internal Name |
---|---|
TCA Account Publish (Add and Update) | XNB_TCA_ACCOUNT_OAG72_OUT.xgm |
OM Sales Order Publish | XNB_OM_SALESORDER_OAG72_OUT.xgm |
Inventory Item Publish | XNB_INV_ITEM_OAG72_OUT.xgm |
XNB Confirm BOD | XNB_CLN_CBOD_OAG72_IN.xgm |
OM Group Sales Order Publish | XNB_OM_GRPSALESORDER_OAG72_OUT.xgm |
Additional Information: The names of message maps are based on the internal names of the map and have an .xgm extension. For example, the file name for TCA Account Publish Map is XNB_TCA_ACCOUNT_OAG72_OUT.xgm.
Map Internal Name | DTD | Root Element |
---|---|---|
XNB_TCA_ACCTUPDATE_OAG72_OUT.xgm | xnb_update_account_001.dtd | CUSTOMER_ACCOUNT_001 |
XNB_OM_SALESORDER_OAG72_OUT | xnb_add_salesorder_001.dtd | SALES_ORDER_001 |
XNB_INV_ITEM_OAG72_OUT | xnb_update_item_001.dtd | ITEM_SYNC_001 |
XNB_CLN_CBOD_OAG72_IN | xnb_002_confirm_bod_004.dtd | CONFIRM_BOD_004 |
XNB_OM_GRPSALESORDER_OAG72_OUT.xgm | xnb_add_grpsalesorder_001.dtd | GRPSALES_ORDER_001 |
TBI provides the following OAG conforming DTDs:
oagis_domains.dtd
oagis_entity_extensions.dtd
oagis_extensions.dtd
oagis_fields.dtd
oagis_resources.dtd
oagis_segments.dtd
The OAG Integration Specification DTDs are available in $XNB_TOP/xml/oag72. This folder also contains the XNB-specific DTDs when they are loaded into the XML Gateway repository.
Maps can be reloaded manually into the repository using the XML Gateway Map loader. Run the following command, from the APPL_TOP to load the Map.
$ java oracle.apps.ecx.loader.LoadMap <uname> <passwd> <host:port:sid> <map_name.xgm>
To delete maps from the repository, run the following command:
$ java oracle.apps.ecx.loader.DeleteMap <uname> <passwd> <host:port:sid> <map_internal_name>
Every time a patch is applied and the existing DTDs are updated or new DTDs are introduced, the DTDs are automatically loaded to the repository so there is no need to load them manually. For more information on loading DTDs and maps, refer Oracle XML Gateway User's Guide. The OAG conformant DTDs need not be loaded into the repository.
Before loading the TBI Specific DTDs, ensure that the OAGIS DTDs are present in the same directory.
To load the DTDs while debugging, open the '$XNB_TOP/xml/oag72' directory under APPL_TOP and run the following command:
$ java oracle.apps.ecx.loader.LoadDTDToClob <uname> <passwd> <host:port:sid><dtd_name.dtd> <root_element> <runtime_location>
To delete the DTD associated with a map, run the following command:
$ java oracle.apps.ecx.loader.DeleteDTDFromClob <uname> <passwd> host:port:sid <dtd_name.dtd> <root_element> <runtime_location>
The script values are:
uname, passwd, host, port, sid: Database connection parameters.
dtd_name.dtd : TBI specific DTDs.
root_element: root element of the DTD.
runtime_location: Set to xnb/oag72