Print parametr in XML report without having XML tags

Oracle provides option to print input parameter directly in RTF without generating a XML tag for this. This can be done in below 2 steps,

Define the parameter reference: this can be done in two different ways

<?param@begin:P_PARAM?>

<xsl:param name="P_PARAM" xdofo:ctx="begin"/>

Print the report parameter value:

<?$P_PARAM?>

Example

CP Parameter Name

START_TIME

END_TIME

Invoke parameters on rtf

<?param@begin:START_TIME?>

<?param@begin:END_TIME?>

Create 2 form field (Placeholder) in RTF  with below values

<?$START_TIME?>

<?$END_TIME?>

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

               

 

 
 

: XML-20112: (Fatal Error) Error opening external DTD 'jbo_03_01.dtd'

Error while importing custom VO.

 

Above error occurs while trying importing xml files. Developer will face this while extending VO.

 

OA extension, requires following files at respective folder structure under JAVA_TOP

1        CustomVO   (xxABCVO.xml)

2          Custom VOImpl file (xxABCVOImpl.class)

3          server.xml

4        OAProject.jpx

 

To extend VO, only jpx file needs to be uploaded using jpximporter command

 

Trying to import other 2 xml files (server and custom VO), will throw above error as these were not right file for xml importer.

 

Please ignore the error if jpx importer is successful. Your VO will be extended.

---

   

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.

 
 

Project workbench TAB on Self Service Page

 

Project workbench TAB available on HOME Page

 

 

Menu Name - Project Workbench Tab Structure

 

Exclusion Request -  

To exclude any Tab, create a custom Menu and exclude. Add custom menu on required responsibilities.

 

Inclusion Request -

To include these tab on any responsibility. Include all below menu and functions.

 

Prompt                                 Menu                                    Function

 
 

Warning !!! Due to high volume of data, got out of memory exception - XML Memory Error

 

Issue – Memory  Exception while generating XML publisher report

 

 

Resolution 1 -  Give the below shown option in CP definition –

 

 

 

 

Resolution 2 - Set the scalable option in data template (XML Publisher >> Data Definition >> Data Template. Xml )

<properties>

   <property name="scalable_mode" value="on" />

</properties>