oracle apps scripts and commands

SQL Loader command :

sqlldr control=ctrl_file.ctl SKIP=1 log=logfile.log bad=badfile.log discard=discardfile errors=150000 userid=apps/apps@instance

--xx--

FNDLOAD command:

FNDLOAD apps/apps@instance 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct PRG_XX.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XX"

--xx--

Set Multi org in R12:

Begin

       mo_global.set_policy_context('S', 99); --99 is the org id

End;

--xx--

To find Oracle forms fmb version, run the command in unix prompt

adident Header <filename>

--xx--

To find the folder locations of utl_file directory:

select value from v$parameter where name = 'utl_file_dir'

--xx--

To be continued....