R12- Contextfile XML File Location
Main changes in R12, Context File is no more in $APPL_TOP/admin directory, the $APPL_TOP/admin contextfile has been moved to $INST_TOP/appl/admin directory.
Apps DBA's usually changes context files manually rather changing by OAM.Oralce Strongly suggest to use OAM to modify the contextfile.
11i Apps DBA's who are moving to R12 have to remember this. Irrespective of 11i or R12, I would suggest to use 'vi $CONTEXT_FILE' after making the copy of the context file by 'cp $CONTEXT_FILE_bkp_date'. Otherwise use OAM!!
To know the context_file paths from FND_OAM_CONTEXT_FILES
SQL> desc fnd_oam_context_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME NOT NULL VARCHAR2(512)
VERSION NOT NULL VARCHAR2(30)
PATH NOT NULL VARCHAR2(1024)
LAST_SYNCHRONIZED NOT NULL DATE
TEXT NOT NULL CLOB
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NOT NULL NUMBER(15)
NODE_NAME NOT NULL VARCHAR2(30)
STATUS VARCHAR2(1)
SERIAL_NUMBER NUMBER
EDIT_COMMENTS VARCHAR2(2000)
CTX_TYPE NOT NULL VARCHAR2(1)
SQL>
Main changes in R12, Context File is no more in $APPL_TOP/admin directory, the $APPL_TOP/admin contextfile has been moved to $INST_TOP/appl/admin directory.
Apps DBA's usually changes context files manually rather changing by OAM.Oralce Strongly suggest to use OAM to modify the contextfile.
11i Apps DBA's who are moving to R12 have to remember this. Irrespective of 11i or R12, I would suggest to use 'vi $CONTEXT_FILE' after making the copy of the context file by 'cp $CONTEXT_FILE_bkp_date'. Otherwise use OAM!!
To know the context_file paths from FND_OAM_CONTEXT_FILES
SQL> desc fnd_oam_context_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME NOT NULL VARCHAR2(512)
VERSION NOT NULL VARCHAR2(30)
PATH NOT NULL VARCHAR2(1024)
LAST_SYNCHRONIZED NOT NULL DATE
TEXT NOT NULL CLOB
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NOT NULL NUMBER(15)
NODE_NAME NOT NULL VARCHAR2(30)
STATUS VARCHAR2(1)
SERIAL_NUMBER NUMBER
EDIT_COMMENTS VARCHAR2(2000)
CTX_TYPE NOT NULL VARCHAR2(1)
SQL>
No comments:
Post a Comment