Search This Blog

Friday, July 29, 2022

How to export File Type and File Template to a .ins in IFS Applications?

To export the created File Type and File Template fully there is an existing File Template named ExtFileInsCreate (NOTE: This uses the procedure called External_File_Utility_API.File_Type_Create_Export). We could use this file template to create a .txt/.ins file that contains the full .ins script to create the File Type, File Template, etc. fully.

Steps to Create .ins










Other Utility File Templates

DescribeInput
File template used when creating an example file describing how to input data for a specific file template.

ExtFileExpImp
File template used when creating an export or import of a file type and all related data. It's also possible to export all related data to a file template without the data related to the file type.

ExtFileInsCreate
File template used when creating insert instructions for a file type and all related data. It's also possible to create insert instructions for related data to a file template without the data related to the file type.

RemoveTrans
File template used when ordering a job that removes transactions in the External File Transactions storage.

ExtFileFunctionList
File template used to create a list of valid column functions

Useful Links:

> External Files Interface

No comments:

Post a Comment

Read file content from an Oracle Directory in PL/SQL/ in IFS

Read single file DECLARE file_handle_ UTL_FILE.FILE_TYPE; directory_name_ CONSTANT all_directories.directory_name%TYPE := '...

Popular Posts