set profile options from pl sql

Procedure to set the profile options form backend. PL SQL

create or replace procedure my_proc(profile_name varchar2,profile_value varchar2)
as
stat BOOLEAN;
begin
result:= fnd_profile.SAVE (profile_name, profile_value, 'USER',0);
--IF result THEN
--DBMS_OUTPUT.put_line ('result= TRUE - profile updated');
--ELSE
--DBMS_OUTPUT.put_line ('result= FALSE - profile NOT updated');
--END IF;
COMMIT;
end;



You can use below method also.


begin
APPS.FND_PROFILE.PUT('profile_name', profile_value);
end; 

Regards
Kaushal Bhati
kosal01bhati@gmail.com

Configurator Extension to get Profile Options

First create a profile option through Application Developer

DOWNLOAD Profile option

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct yourLdtfilename.ldt PROFILE PROFILE_NAME="your_profile_name" APPLICATION_SHORT_NAME="application_short_name"


UPLOAD Profile option

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct yourLdtfilename.ldt

Use Below code to get the profile option value.

        String appsProfile = null;
        CZWebAppsContext ctx = (CZWebAppsContext)pRuntimeNode.getConfiguration().getContext();
        Profiles profiles = new Profiles(ctx);
        appsProfile = profiles.getSiteLevelProfile(profileName);
        if (appsProfile == null) {
          appsProfile = profiles.getProfile(profileName);
        }
        return appsProfile;




Email:kosal01bhati@gmail.com

TSO Configurator Extensions

CX that will Assign Line Type to the Quote According to the Properties that exists in the Configurator Structure.

Java class "AssignItemLineTypeCX" is used to assign Line Type to the Quote according to the Properties.

it is in the package oracle.apps.cz.cx.tso

Java class "CZIBAttributeCX" is used to create the IB Attributes of the BOM Item.

it is in the package oracle.apps.cz.cx.tso

Call Concurrent Program with Configurator Extension

First you need to intialize Apps parameter.

             CallableStatement cspro =
             connection.prepareCall("{call FND_GLOBAL.APPS_INITIALIZE(?,?,?)}");
             cspro.setString(1, "0");
             cspro.setString(2, "20420");
             cspro.setString(3, "1");
             cspro.executeUpdate();
             cspro.close();

After that Use ConcurrentRequest class to submit request from the you java class.

             ConcurrentRequest cr = new ConcurrentRequest(connection);
             int requestId = cr.submitRequest("Application Name",
"Prog short Name", "Prog Description", null, false, parameter in vector);
             System.out.println(requestId);

check the status of the concurrent program.


SELECT * FROM FND_CONCURRENT_REQUESTS WHERE   REQUEST_ID=your request id.



mail me for any further info.

Commands for Bouncing Apache after Change in Java file or Jserv.properties

first you have to stop the apache server.

$COMMON_TOP/admin/scripts/"your instance name"/adapcctl.sh stop

then you have to start the apache server.

$COMMON_TOP/admin/scripts/"your instance name"/adapcctl.sh start

your changes will be reflected now.

Configurator: Logic Rules

1. Relate model nodes on Side A to other model nodes on Side B using a logic relation

2. Logic rules determine logic state of model nodes

Logic Rules can impact both ways. Side 1 can impact the logic state of Side 2, and Side 2 can impact the logic state of Side 1.

Either side of the rule can contain one or more Features, Options, and more

 Available Logic Rules

Requires

Implies

Negates

Excludes

Defaults  

  

Requires

Imapct both ways. if you set either side to true or false, the other side is set to the same state.

Additionally, the selection of one item requires selection of another item.

 

Implies

 Sets up a one-way relationship. the selection of one item selects another item, but not the reverse.

 

  

Negates

Sets up a relationship that impacts both ways. If you set either side to True or False, the other

side is set to the opposite state. The selection of an item prohibits selection of another item.

 

  

Excludes

Sets up a one-way relationship.the selection of one item prohibits another item, but not the

reverse.

Defaults 

Sets a specified Feature or Option to true as a result of another

selection. A specified Feature or Option is set to true only if it is available.

Defaults rules are useful if you want to drive initial values at the beginning of a configuration

session from customer requirements selections

For Testing Above Rules,do not forget to Generate the Logic and Refreshing UI.

CZ Tables and Description

CZ Table Name	Descripton
cz_config_ext_attributes	Store the Attributes which needs to be passed on to IB
cz_config_hdrs	Stores the Header Information for a Configuration.
cz_config_items	Stores the each and every detail of the configuration. All the inv items, text features etc are stored in this table. It’s a Runtime table .
cz_config_messages	Store the messages associated with a configuration.
cz_db_logs	Stores the errors occurred with doing a configuration.
cz_db_setting	Not to touch. Setup Table. Generally manipulation by CZ DBA.
cz_item_types	Design time table, give the information about different types of Nodes.
cz_model_publications	Stores the publications created for a configuration model.
cz_ps_nodes	Design time table, stores the node information, node linkages of a Model hierarchy.
http://www.indylogix.com