Oracle Apps Create ctl, dat, and concurrent program and run.
1.Giving to md40 document this document need client required table column’s and data type is there.
2.Create a cs v (XL) file to all client needed column in heading and fill the data. Mainly I mentioned data header and data footer and middle data body we create.
3.All the XL file data copy to text document without column’s and replace the space to ‘|’ mark in text document.
4.This text document save to DAT file.
5.After that we create a staging table and also create control file. Then table will execute sql plus prompt.
6.And we have to copy the control file, DAT file to winscp.
7.Then finally we create a concurrent program in apps and run the concurrent program.
8.Finally we create a package and run that package.
No comments:
Post a Comment