Tuesday, October 24, 2017

XML Publlisher(XMLP) Important Tables in Oracle Apps

XMLP Table Name
Table 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

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)