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

create first Configurator Extension in Oracle Configurator

hi below is the code to create your first configurator extension in Oracle Configurator.


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import oracle.apps.cz.cio.*;
import oracle.apps.cz.common.*;
import oracle.apps.fnd.common.Context;


public class CIOtest
{
    public static void main(String args[])
    {
       
        try
        {
        System.out.println("inside the class");
        java.sql.Connection conn = null;
        System.out.println("inside the class 1 ");
        Class.forName("oracle.jdbc.driver.OracleDriver");
        System.out.println("inside the class 2 ");
        // Context cfg_context = new CZWebAppsContext("10.13.20.56","8001","dev");
        // Context cfg_context = new CZWebAppsContext("10.13.20.56","8005","test");
        Context cfg_context = new CZWebAppsContext("test");
        System.out.println("inside the class 3 ");
        CIO cioobject = new CIO();
    System.out.println("inside the class 4 ");
        }
        catch (Exception e)
        {
            System.out.println("inside the exception");
            System.out.println(e);
        }
        //conn = DriverManager.getConnection("jdbc:oracle:thin:@10.13.20.55:1526:TST1", "apps", "apps");

    }

};

http://www.indylogix.com

CZ_tables

OBJECT_NAME


CZ_ADDRESSES
CZ_ADDRESS_USES
CZ_ARCHIVES
CZ_ARCHIVE_REFS
CZ_ATP_REQUESTS
CZ_COMBO_FEATURES
CZ_CONFIG_ATTRIBUTES
CZ_CONFIG_EXT_ATTRIBUTES
CZ_CONFIG_HDRS
CZ_CONFIG_INPUTS
CZ_CONFIG_ITEMS
CZ_CONFIG_MESSAGES
CZ_CONFIG_USAGES
CZ_CONTACTS
CZ_CUSTOMERS
CZ_CUSTOMER_END_USERS
CZ_DB_LOGS
CZ_DB_SETTINGS
CZ_DB_SIZES
CZ_DES_CHART_CELLS
CZ_DES_CHART_COLUMNS
CZ_DES_CHART_FEATURES
CZ_DEVL_PRJ_USER_GROUPS
CZ_DEVL_PROJECTS
CZ_DRILL_DOWN_ITEMS
CZ_EFFECTIVITY_SETS
CZ_END_USERS
CZ_END_USER_GROUPS
CZ_EXPRESSIONS
CZ_EXPRESSION_NODES
CZ_EXP_TMP_LINES
CZ_EXT_APPLICATIONS
CZ_FILTER_SETS
CZ_FUNC_COMP_REFS
CZ_FUNC_COMP_SPECS
CZ_GRID_CELLS
CZ_GRID_COLS
CZ_GRID_DEFS
CZ_IMP_ADDRESS
CZ_IMP_ADDRESS_USE
CZ_IMP_CONTACT
CZ_IMP_CUSTOMER
CZ_IMP_CUSTOMER_END_USER
CZ_IMP_DEVL_PROJECT
CZ_IMP_END_USER
CZ_IMP_END_USER_GROUP
CZ_IMP_INTL_TEXT
CZ_IMP_ITEM_MASTER
CZ_IMP_ITEM_PARENT
CZ_IMP_ITEM_PROPERTY_VALUE
CZ_IMP_ITEM_TYPE
CZ_IMP_ITEM_TYPE_PROPERTY
CZ_IMP_LOCALIZED_TEXTS
CZ_IMP_MODEL_REF_EXPLS
CZ_IMP_PRICE
CZ_IMP_PRICE_GROUP
CZ_IMP_PROPERTY
CZ_IMP_PS_NODES
CZ_IMP_RULES
CZ_IMP_USER_GROUP
CZ_INTL_TEXTS
CZ_ITEM_MASTERS
CZ_ITEM_PARENTS
CZ_ITEM_PROPERTY_VALUES
CZ_ITEM_TYPES
CZ_ITEM_TYPE_PROPERTIES
CZ_JRAD_CHUNKS
CZ_LCE_CLOBS
CZ_LCE_HEADERS
CZ_LCE_LINES
CZ_LCE_LOAD_SPECS
CZ_LCE_OPERANDS
CZ_LCE_TEXTS
CZ_LOCALES
CZ_LOCALIZED_TEXTS
CZ_LOCK_HISTORY
CZ_LOOKUP_VALUES
CZ_LOOKUP_VALUES_TL
CZ_MODEL_PUBLICATIONS
CZ_MODEL_PUBLICATIONS_BKUP
CZ_MODEL_REF_EXPLS
CZ_MODEL_USAGES
CZ_OPPORTUNITY_HDRS
CZ_OPP_HDR_CONTACTS
CZ_PB_CLIENT_APPS
CZ_PB_LANGUAGES
CZ_PB_MODEL_EXPORTS
CZ_PB_TEMP_IDS
CZ_POPULATORS
CZ_POPULATOR_MAPS
CZ_PRICES
CZ_PRICE_GROUPS
CZ_PRICING_STRUCTURES
CZ_PROPERTIES
CZ_PROPOSAL_HDRS
CZ_PROP_QUOTE_HDRS
CZ_PSNODE_PROPCOMPAT_GENS
CZ_PS_NODES
CZ_PS_PROP_VALS
CZ_PUBLICATION_USAGES
CZ_QUOTE_HDRS
CZ_QUOTE_MAIN_ITEMS
CZ_QUOTE_ORDERS
CZ_QUOTE_SPARES
CZ_QUOTE_SPECIAL_ITEMS
CZ_REL_TYPES
CZ_RP_ENTRIES
CZ_RULES
CZ_RULE_FOLDERS
CZ_SERVERS
CZ_SIGNATURES
CZ_SIGNATURE_ARGUMENTS
CZ_SPARES_SPECIALS
CZ_SUB_CON_SETS
CZ_TERMINATE_MSGS
CZ_TYPE_RELATIONSHIPS
CZ_UI_ACTIONS
CZ_UI_CONT_TYPE_TEMPLS
CZ_UI_DEFS
CZ_UI_IMAGES
CZ_UI_NODES
CZ_UI_NODE_PROPS
CZ_UI_PAGES
CZ_UI_PAGE_ELEMENTS
CZ_UI_PAGE_REFS
CZ_UI_PAGE_SETS
CZ_UI_PROPERTIES
CZ_UI_REFS
CZ_UI_REF_TEMPLATES
CZ_UI_TEMPLATES
CZ_UI_TEMPLATE_ELEMENTS
CZ_UI_XMLS
CZ_USER_GROUPS
CZ_XFR_FIELDS
CZ_XFR_FIELD_REQUIRES
CZ_XFR_PRICE_LISTS
CZ_XFR_PROJECT_BILLS
CZ_XFR_RUN_INFOS
CZ_XFR_RUN_RESULTS
CZ_XFR_STATUS_CODES
CZ_XFR_TABLES

Enable CZ log in Server for Configurator Developement

to enable the log of CZ log on the server you have to modify the Jserv.properties on the server as below

 #CONFIGURATOR DEBUG

 wrapper.bin.parameters=-DAFLOG_ENABLED=Yes
wrapper.bin.parameters=-DAFLOG_LEVEL=Statement
wrapper.bin.parameters=-DAFLOG_MODULE=cz%
wrapper.bin.parameters=-DAFLOG_FILENAME=server path to log file CZ_apps.log

 restart the Apache after the changes in Jserv.properties.


in R12,it will be

OC4J Java System Properties

To enable logging for OC4J, add the following to the oc4j.properties file corresponding to your OC4J Container. This is the "oacore" container (typically located in $ORACLE_CONFIG_HOME/j2ee/oacore/config/):

AFLOG_ENABLED=TRUE 
AFLOG_LEVEL=STATEMENT 
AFLOG_MODULE=% 
AFLOG_FILENAME=/path/to/apps.log