OAF Personalization Profile Options

To Enable the Personalization Option in OAF we need to set the below profiles.

Navigation: System Adminstrator --> Profile --> System

User Preferences in Oracle E-Business Suite

How to get the values from user the Preferences

Current Session Language

SELECT FND_PROFILE.VALUE_SPECIFIC (NAME => 'ICX_LANGUAGE', USER_ID=>9999)    FROM DUAL;

Output :  AMERICAN

Territory

 SELECT FND_PROFILE.VALUE_SPECIFIC (NAME =>'ICX_TERRITORY', USER_ID=>9999)

 FROM DUAL;

Output : AMERICA

Date Format

SELECT FND_PROFILE.VALUE_SPECIFIC (NAME =>'ICX_DATE_FORMAT_MASK', USER_ID=>9999)

  FROM DUAL;

Output : DD-MON-RRRR

Number Format

SELECT FND_PROFILE.VALUE_SPECIFIC ('ICX_NUMERIC_CHARACTERS', 9999)

  FROM DUAL;

Output : .,

Getting Started with OAF!!

Download the Patch and Extract to the system.

Place the .dbc file to the appropriate folder.

Get the dbc file from the above path and place in below local path

Place the Jdeveloper.exe on the Desktop from p9879989_R12_GENERIC\jdevbin and click on the Jdeveloper.exe

Set the Database connection

Choose the Database folder from the Connections. Create a new Connection and provide the details to connect and Test the Connection!!

Set the Default Project Properties to automate at run time.

Create a New Workspace

Set the OA Workspace Path

Create a new Project

Create a new Application Module

Create a new Page



Set the Properties of a page

Run the Program. Right click on the page and click on run.

Output of sample page

BC4J Structure.