R12 : Where you can find context file?

R12: Where you can find XML file ?

Hi Friends ,

This is post for which removes mess between context file in R12 and 11i. Generally any apps dba worked on 11i will go blindly to the directory to $APPL_TOP/admin to get xml or context file. Many times people working on R12 make big problem while working.

Experienced dba’s most of the time do the modification manually in context file. In case of 11i upgrade to R12 instances dba’s make mistake by considering the old context file instead of new. As in R12 context file lies at $INST_TOP/appl/admin directory. One of my colleague did same mistake as he made changes in the context file in $APPL_TOP/admin but actually it was present at $INST_TOP/appl/admin after R12 upgrade. So avoid such mistake, as recommended by Oracle always use OAM to do the modifications in the Context file.

11i appa dba’s who are working on R12 always remember the location of context file. So to avoid the confusions always use “vi $CONTEXT_FILE” and modifications after “cp $CONTEXT_FILE $CONTEXT_FILE_BKP_DATE “.

You can find all information’s about context files in the 11i in this table “FND_OAM_CONTEXT_FILES “.

Please see the view of this table.

Wait for my next article on R12.