Re: Update basepath in fnd_application table to consolidate custom tops

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Update-basepath-in-fnd-application-table-to-consolidate-custom-tops-tp853p862.html

Custom tops (the environment variables) are set from the CONTEXT_FILE.

For example, if you have an custom top named XXEFA, you will have the following in your apps context file;

<XXEFA_TOP oa_var="s_xxefatop" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/install/fs2/EBSapps/appl/xxefa/12.0.0</XXEFA_TOP>


So when you set the run filesystem using EBSapps.env run , EBSapps.env script calls,
<context_name>_hostname.env file (not the Custom env !)
for example: /u01/install/fs2/EBSapps/appl/CLONE_demoorcl.env, which in turns parses the context file and set these custom environment variables using the following ;

if test -f $CONTEXT_FILE; then
  allprods=`grep 'oa_type="PROD_TOP"' $CONTEXT_FILE |
     sed 's/^.*<\([A-Z_a-z0-9]*\).*oa_var[^>]*>[ ]*\([^<]*\)<.*$/\1=\2; export \1;/g'`


So , please revise your custom tops accordingly.