Script to find Template and associated JSP file

SELECT 

ida.access_name,
ida.file_name,
DECODE(ida.site_id, 1, 'All', s.msite_name) site_name,
ida.default_msite,
ida.language_code,
ida.default_language
FROM IBE_DSP_ATTACHMENTS_V ida, ibe_msites_tl s
WHERE m.site_id = s.msite_id and file_name = ‘ibeSeededPage.jsp’; 

Once identify the target JSP page use above SQL to find the associated program access name.

Create a custom version of seeded JSP (i.e. xxskpibeSeededPage.jsp)

Login to iStore Administrator Responsibility >> Advanced >> Template Manager 

Search the program access name with the out of above SQL 

Update >> Add new file >> provide custom file name for all countries and US language. 

Now place the custom file at OA_HTML file path and compile JSP (Click here for compilation and migrations)

iStore Customization and Migration

Istore codes are mainly JSP changes. Below is the steps need to follow to customize and migrate the iStore changes.

 

Find the file from $OA_HTML

cp $OA_HTML/ ibeCScdDirectEntry.jsp /home/Sandeep

rename the file with “xx”  (xxibeCScdDirectEntry.jsp)

 

Copy the file to $OA_HTML

cp /home/sandeep/xxibeCScdDirectEntry.jsp $OA_HTML/

 

Navigate to FND_TOP and compile the JSP in that environment

cd $FND_TOP/patch/115/bin/

perl ojspCompile.pl --compile -s xxibeCScdDirectEntry.jsp

 

Bounce Apache

$ADMIN_SCRIPTS_HOME/adoacorectl.sh stopall

$ADMIN_SCRIPTS_HOME/adoacorectl.sh startall

               

 

 
 

How to define and call java methods in JSP Pages ( iSTORE)

Customizing JSP pages are similar to OAF changes.

 

If customizing the JSP page, writing validations and logic in Java and refering the method in JSP page, is easier option.

 

How to define and call a Java code in JSP page -

 

Create a java file and place at server ( $JAVA_TOP/xxxxx/oracle/apps/<product>/<catagory>)

Ex – created java file names xxxxxItem.class and placed at location $JAVA_TOP/xxxx/oracle/apps/ibe/catalog

 

 

Similar to import a java class in OAF, each jsp have this section at top. This is the referenced java files.

Included the custom file reference.

 

Invoke defined method inside the code –

 

 

We can extend the logic in java file for any new validations and place the new version at referred location.

Bounce the apache and changes will reflect.