Set Profile Option Value from back end

on Monday, June 22, 2009

The PROFILE_OPTION_NAME can be found by the SQL statement,

SELECT profile_option_name

FROM fnd_profile_options_tl

WHERE user_profile_option_name LIKE 'MO%'


It returns more than one row but i can make out that "ORG_ID" is the PROFILE_OPTION_NAME for MO: Operating Unit.

Inorder to know the Org_ID of the Org whose value is to be set in MO: Operating Unit the following SQL statement is used.

SELECT organization_id, NAME

FROM hr_all_organization_units;


From the above query the default Operating Unit is found and the below code below is used to set the profile option value using fnd_profile.save


DECLARE

stat BOOLEAN;


BEGIN

DBMS_OUTPUT.DISABLE;

DBMS_OUTPUT.ENABLE (100000);

stat := fnd_profile.SAVE ('ORG_ID', 286, 'SITE');


IF stat THEN

DBMS_OUTPUT.put_line ('Stat = TRUE - profile updated');

ELSE

DBMS_OUTPUT.put_line ('Stat = FALSE - profile NOT updated');

END IF;


COMMIT;


END;

Oracle Application Framework

on Monday, June 1, 2009

Oracle Application Framework is the development platform for HTML-based applications. It consist of a java-based application tier framework and associated services. It designed to facilitate the rapid deployment of HTML-based applications.

Oracle Application Framework uses below components:

ž AOL JAVA or AOL/J

It provides the OAF with underlying security and applicaiton Java Services.Also OAF with its connection to the DB and with application-specific functionality for e.g attachments and flexfields.

ž BC4J

JDeveloper incluedes BC4J. Java Business components are created by BC4J for representing business logic.It seperates the business logic from UI by mapping the relational tables to java objects.

ž Java Controller

It processes the programmatic UI definition.


ž Metadata UI Definition

Apache Jserv module provides the Java servlet engine uses metadata dictionary to to construct the Framework UI.

ž HTML Generator UIX

UIX , the HTML Generator


HTML-based applicaiton uses the following path with OAF on application Tiers. The steps are discussed below.


a) User click a function on browser (HTML hyperlink access).

b) URL request to the web listener sent by browser.

c) User access validated by AOL/J.

d) Page definition is loaded from the metadata dicitionary on the DB tier into the application Tier (i,e. Metadata UI definition)

e) BC4J objects that contain the application logic and access the database are instantiated.

f) Java controller programatically manipulates the page definition as necessary, based on dynamic UI rules.

g) HTML UI Generatior (UIX)interprets the page definition. It creates the related HTML based on UI standards, and send the page to the browser.