How to build a new template

If you do not find the template you need, and there is a API pls. follow these steps to create a new template:

• Open a new excel workbook – press the xls4oracle tool button: dataload – this will create 4 sheets: data, mapping, dataload and system
• Open sqlplus apps/apps
• execute @api CSI_INSTANCE_PUB (as an example)
• Using notepad – open api\CSI_INSTANCE_PUB.UPDATE_ITEM_INSTANCE.txt
• Copy the plsql section into the dataload sheet
• Copy the mapping section into the mapping sheet
• The template is created!!!

For documentation on the API, pls. visit Oracle Integration Repository. Use the sql function in the xls4oracle tool to do the extract. For further in for the xls4oracle tool pls. read the User Manual.

Video: How to create a xls4oracle template

Pls. download this zip file to see a 10 min. video showing how to create a template. The included word document explains the actions on the video.