Create or update correspondence templates.
If the preconfigured Oracle XML Publisher templates available in Oracle Advanced Collections do not suit your business process, you can create new templates. It is recommended that you review and test the preconfigured templates before creating new ones.
Who can create XML Publisher templates?A functional business user, with knowledge of how correspondence should be worded, creates the text for a template and saves it as a rich text format file (RTF) or as a portable document file (PDF). A DBA with knowledge of the database schema as well as SQL programming creates and registers the queries for the templates.
How do I create a new XML template?Using your XML Publisher Administration responsibility, create a new template and template ID code. See: Oracle XML Publisher Administration and Developer's Guide.
The new template and its ID code are stored in the XDO_TEMPLATES_B table.
How can I create or update a query for an existing template?Use the following steps to create or update a query for an existing template:
Using Collections Administrator responsibility, click Manage Templates Query.
Click Create Query
Search the appropriate template for which you want to enter the query for and enter the query in the Query Editor box.
To update an existing query, search for the template for which the query needs to be updated.
Click Update against the query listed for the template.
The STATEMENT column in the IEX_XML_QUERIES table provides up to 4000 characters. This can be extended to 20000 characters by using the ADDITIONAL_QUERY column and leaving the STATEMENT column blank.