Thursday 27 December 2012

Oracle Application's URL from back end

option 1

SELECT home_url
   FROM icx_parameters

option 2


Select PROFILE_OPTION_VALUE
From   FND_PROFILE_OPTION_VALUES
WHERE  PROFILE_OPTION_ID =
      (SELECT PROFILE_OPTION_ID
       FROM FND_PROFILE_OPTIONS
       WHERE PROFILE_OPTION_NAME ='APPS_FRAMEWORK_AGENT')
       AND LEVEL_VALUE=0;

API to delete the program


API to delete the program

fnd_program.delete_program('Short Name', 'Application');

API to delete the executable

fnd_program.delete_executable('Short Name', 'Application');


Please commit after you are done.

Wednesday 26 December 2012

Creating Soft Link for Unix file in Oracle Apps

Go to the top where .prog file exists.

cd $AR_TOP/bin

ln -s ../../../../fnd/12.0.0/bin/fndcpesr  XX123

Compile Oracle Report/RDF in UNIX

rwconverter userid=apps/apps_password batch=yes source=file_name stype=rdffile DTYPE=rdfFILE compile_all=yes OVERWRITE=yes logfile=log.txt dest=outfile_name