XDO – XMLP Important Base Tables

Oracle_XMLP_Tables_www.OracleAppsDNA
Here are some of the important XMLP tables.

Table Name Description
XDO_CONFIG_PROPERTIES_B Stores the XML Publisher Administration configuration properties that are accessible from the OA Framework interface.
XDO_CONFIG_PROPERTIES_TL Translation table for XDO_CONFIG_PROPERTIES_B.
XDO_CONFIG_VALUES Stores the values assigned to the property in Administration Configuration Data
XDO_CURRENCY_FORMATS Stores the format masks for various currencies. A collection of these formats forms a currency format set.
XDO_CURRENCY_FORMAT_SETS_B Stores the Currency Format Sets
XDO_CURRENCY_FORMAT_SETS_TL Stores the Currency Format Sets
XDO_DS_DEFINITIONS_B Stores data source definition represented by XML Schema Definition (XSD). Each data source has one or more elements, and these information are stored in XDO_DS_ELEMENTS_B
XDO_DS_DEFINITIONS_TL Translation table for XDO_DS_DEFINITIONS_B
XDO_FONT_MAPPINGS Stores the mappings from a base font to a target Truetype or Type 1 font. A collection of these mappings forms a font mapping set
XDO_FONT_MAPPING_SETS_B Stores the header information for a font mapping set, which is a collection of font mappings
XDO_FONT_MAPPING_SETS_TL Translation table for XDO_FONT_MAPPING_SETS_B
XDO_LOBS Stores Template(RTF File), XML File, XML Schema File, locale(langauge and territory) sensitive binary and text files. It is mainly used for storing language layout templates.
XDO_TEMPLATES_B Stores template information. Each template has a corresponding data source definition stored in the XDO_DS_DEFINITIONS_B. Each translation of a certain template, not each template, has a corresponding physical template file. The physical template file information are stored in the XDO_TEMPLATE_FILES.
XDO_TEMPLATES_TL Translatable table for XDO_TEMPLATES_B
XDO_TEMPLATE_FIELDS Stores information of the fields of template file. Each field belongs to one of physical template files
XDO_TRANS_UNITS Stores the header information regarding each segment of translatable text in layout templates
XDO_TRANS_UNIT_PROPS Stores any untranslatable values embedded within a segment of text. These values will be merged back into the text translations
XDO_TRANS_UNIT_VALUES Stores any untranslatable values embedded within a segment of text. These values will be merged back into the text translationsd