How to put total for Advance table column in OA Framework

go to advance table -> column-> column properties.

Set the property as below

make sure the item type should be selected as Number only other wise it wont work.

 

By doing these two above steps, you can see the total value calculated automatically. No need to write a code for the same.

 

Let me know if you have any questions. I will answer you.

 

OAF Error : unable to launch the java virtual machine located at path msvcr71.dll

Replication Of Issue: 

 

Go to path JDEV_Home ->jdev ->bin and try to open any 64 bit Jdeveloper

Reason: 

 

 

While Installing Jdeveloper, It install JDK (e.g. jdk160_24) inside Oracle1 -> Middleware and JDeveloper referes to this path as JavaHome. But if the Jdeveloper needs Higher version of JDK than the installed one (e.g JDev 11.1.1.6.0 needs jdk160_27 or above) then this error occurs.

 

 

Resolution:

 

1. Install JDK version compatible for the installed version

2. Go to JDEV_HOME\jdev\bin\jdev.conf and changed the set javahome as
 "SetJavaHome C:\Program Files\Java\<The New JDK Installed>

 

OAF: The program can't start because MSVCR71.dll is missing from your computer.

In one of my project, in one machine we were not able to open the Jdeveloper  (Version 10.1.3.5 - Patch 19170592 ) which we downloaded from the Metalink Note. This post is to help those who face this issue and don't know what to do to fix this.

OA Framework - How to Find the Correct Version of JDeveloper for OA Extensions to Use with E-Business Suite 11i or Release 12.x (Doc ID 416708.1)

After downloading p19170592_R12_GENERIC.zip, unzipped the contents into C:/oracle/Jdev10.1.3.5. After that when we tried to open the Jdeveloper using C:/oracle/Jdev10.1.3.5/jdevbin/jdev/bin/jdevW.exe, we were getting the below error.

"The program can't start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this problem."

Fix:  You just need to copy the msvcr71.dll file from C:/oracle/Jdev10.1.3.5/jdevbin/jdk/bin to C:/oracle/Jdev10.1.3.5/jdevbin/jdev/bin.

After copying the file, Jdeveloper opened successfully.

How To Setup OA Framework in oracle applications 12.2.4

Task 1: Download and Extract the JDeveloper OA Extension zip file

1. Download Patch 19170592: 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.2.4
2. Extract the archive to c:\jdeveloper_1224
3. Make sure c:\jdeveloper_1224 has the following subdirectories:
jdev
jdevbin
jdevdoc
jdevhome

Task 2: Configure the JDEV_USER_HOME Environment Variable

On a Windows 7 Desktop, right click Computer icon > Properties > Advanced system settings > Environment Variables button > New button
Variable name = JDEV_USER_HOME
Variable value = c:\jdeveloper_1224\jdevhome\jdev

 

Task 3: Obtain the Database Connection file

Create the c:\jdeveloper_1224\dbc_files\secure directory
Ftp the dbc file located at $FND_SECURE to c:\jdeveloper_1224\dbc_files\secure directory

Task 4: Create a Desktop Short to JDeveloper

Right click on Windows desktop > New > Shortcut > Browse > c:\jdeveloper_1224\jdevbin\jdev\bin\jdevW.exe > Next > Finish

 

 

Task 5: Assign Toolbox Responsibilities to an Applications User

Assign the following responsibilities to a user:
- OA Framework ToolBox Tutorial
- OA Framework ToolBox Tutorial Labs

Task 6: Launch JDeveloper and Configure the Database Connection and the User

From JDeveloper main menu > File > Open and select c:\jdeveloper_1224\jdevhome\jdev\myprojects\toolbox.jws
Expand toolbox from the Applications Navigator tab

 

Select LabSolutions > right click > Project Properties > Oracle Applications > Runtime Connection
Set DBC File Name = c:\jdeveloper_1224\dbc_files\secure\<SID>.dbc
Set Username and Password to the user you assigned the 2 responsibilities

Select Tutorial > right click > Project Properties > Oracle Applications > Runtime Connection
Set DBC File Name = c:\jdeveloper_1224\dbc_files\secure\<SID>.dbc
Set Username and Password to the user you assigned the 2 responsibilities

Click Connections tab and expand Database

Right click Database > New Database Connection to open Connection Wizard > Next

Enter values for the following:
Connection Name
Username = apps
Password = <password>
Host Name
JDBC Port
Service Name
Click Next button > Test Connection > Make sure the Status indicates Success! > Next > Finish
Remove the existing fwk12dev > Right click > Delete

Click Applications Navigator tab
Right click LabSolutions > Project Properties > Business Components
Make sure Connection is set to the Connection Name you defined earlier > OK
Right click Tutorial > Project Properties > Business Components
Make sure Connection is set to the Connection Name you defined earlier > OK

Task 7: Test Your Setup

Right click LabSolutions > Rebuild > Make sure you get Compilation complete: 0 errors
Right click Tutorial > Rebuild > Make sure you get Compilation complete: 0 errors

Right click LabSolutions > Run
This should open this page in the browser: http://mkmoreno-au.au.oracle.com:8988/OA_HTML/test_fwklabsolutions.jsp
Right click Tutorial > Run
This should open this page in the browser: http://mkmoreno-au.au.oracle.com:8988/OA_HTML/test_fwktutorial.jsp