Pages

Thursday, April 7, 2016

R12- Contextfile XML File Location

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>

No comments:

Post a Comment