Friday, 25 June 2010

dbc file recreation for Oracle APPS R12

Introduction:
In this post, we would see how can we create the "dbc" file, if it is missing for some reason.

Cookbook:

The "dbc" file location in Oracle APPS R12 is $FND_SECURE. If for some reason it is missing or invalid, then it can be recreated.

Following is the command which can be used to recreate the "dbc" file.

java oracle.apps.fnd.security.AdminAppServer apps/apps ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=VIS SECURE_PATH=$FND_TOP/secure GUEST_USER_PWD=guest/oracle APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=appsdemo.test.com DB_PORT=1531

The only thing needs to be taken care is replace the values with respect to the environment, like the values for $FNDNAM, hostname, port number etc.

No comments: