Tuesday, 27 May 2008

Running ftp commands from a script

Most of the times the things we do from an FTP server will be the same.
  • Login to the ftp server.
  • Navigate to some directory.
  • Change the file type to binary/ascii.
  • Get the file and close the connection.

We can automate the task by doing the following

open ftpserver
username
password
cd /temp
get somefile
bye

Now from the command prompt give ftp-s:Your_file_name and you are done :)

Friday, 23 May 2008

Multi-Org mandatory for Oracle Applications R12

Multi-Org is mandatory for Oracle Applications R12. For a HRMS customer wishing to move to R12, multi-org needs to be enabled even if they are not using Financial modules.

The following query can be run to determine if Multi-Org is enabled already.

select multi_org_flag
from fnd_product_groups;

Oracle has provided a patch 5965493 which creates a dummy Operating unit named
'Non Usable Operating Unit for Multi-Org Conversion'
Once the dummy operating unit is created we can run adadmin and choose the correct options to convert to Multi-Org.