Updating the Context File

It’s been a little while since I’ve posted… one of the things that I’ve been playing with lately is the E-Business Suite R12.2.10 VISION Appliance. For those that don’t know, you can download an actual Oracle VirtualBox VM image from E-Delivery with EBS R12.2.10 VISION, a 19c Database, and a configured operating system… See MOS 2717713.1 for the details.

Anyway, I was looking at this image and found a bit of code that they’re using to make changes to values in the context file. I’ve put it together in a simple script here:

#!/bin/bash
export CTXFILE=${1}
export DTTM=`date +%Y%m%d-%H%M`

cp ${CTXFILE} ${CTXFILE}.${DTTM}

update_ctx() 
{

echo -e "\nSetting ${TOKEN} to ${VALUE}\n"

${COMMON_TOP}/util/jdk32/jre/bin/java \
-classpath ${COMMON_TOP}/java/classes:${EBS_ORACLE_HOME}/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar  \
oracle.apps.ad.context.UpdateContext ${CTXFILE} ${TOKEN} ${VALUE}

}

export TOKEN=s_dbSid
export VALUE=EBSPROD
update_ctx

#
#  Show before/after
#
diff ${CTXFILE}.${DTTM} ${CTXFILE}

The first argument is the context file you want to edit.

The second argument is the token you want to update (“s_dbSid”, for example)

The third is the value you want to assign that token (“TEST”, for example).

Leave a Reply

Your email address will not be published. Required fields are marked *