To determine the Run or Patch file system in current Oracle EBS environments, DBAs can grep for the file_edition_type variable within the CONTEXT_FILE, source the EBSapps.env script, or query the fnd_oam_context_files database table from the backend to extract the active XML parameters.
Oracle Apps R12.2 has two filesytem to enable online patching. We can determine Which File System is the Run or Patch File System by either looking at the file_edition_type in the Context file or by doing the backend query using sqlplus.
Using context file on the filesystem or Sourcing the env
if you know the location of context file,Look for the file_edition_type in the CONTEXT_FILE
grep file_edition_type <context file>
You can source the environment file
. <BASE_DIRECTORY>/EBSapps.env run
Using backend query
To determine the RUN file system:
SELECT EXTRACTVALUE(XMLType(text),'//oa_context_file_loc')
appl_top, status
FROM fnd_oam_context_files
WHERE name NOT IN ('TEMPLATE','METADATA','config.txt')
AND CTX_TYPE='A'
AND (status IS NULL OR UPPER(status) IN ('S','F'))
AND EXTRACTVALUE(XMLType(text),'//file_edition_type') = 'run';
To determine the PATCH files system:
SELECT EXTRACTVALUE(XMLType(text),'//oa_context_file_loc')
appl_top, status
FROM fnd_oam_context_files
WHERE name NOT IN ('TEMPLATE','METADATA','config.txt')
AND CTX_TYPE='A'
AND (status IS NULL OR UPPER(status) IN ('S','F'))
AND EXTRACTVALUE(XMLType(text),'//file_edition_type') = 'patch';
This query has to be run with apps user.
I hope this helps you. Please do provide the feedback
Related Articles
How to run Autoconfig on Patch system in R12.2
how to check ebs version
R12.2 Edition determination and setup
this helped me