Wednesday, April 2, 2014

XML Publisher tables in oracle apps

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

1 comment: