Mahesh-Oracle Technical

Commands to Bounce OA Core for any change in OAF Components(CO and other java files) cd $ADMIN_SCRIPTS_HOME  sh adoacorectl.sh stop  sh adapcctl.sh stop  sh adapcctl.sh start  sh adoacorectl.sh start

API Script to Update Customer Organization DECLARE l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE; l_profile_id NUMBER; x_return_status VARCHAR2(10) := NULL; x_msg_count NUMBER := NULL; x_msg_data LONG; l_party_obj_version NUMBER ;   vMsgDummy                 VARCHAR2 (5000); vErrMsg                   LONG;  ln_resp_id NUMBER; ln_resp_appl_id NUMBER; lc_exists VARCHAR2(100); BEGIN     begin select responsibility_id, application_id    into ln_resp_id, ln_resp_appl_id    from fnd_responsibility_vl   where responsibility_name = 'Application Developer'; exception when others then ln_resp_id := null; ln_resp_appl_id := null; end; fnd_global.apps_initialize(fnd_global.user_id,ln_resp_id,ln_resp_appl_id)...

Migration of Data Definition and RTF Template Use below command to upload Data Definition and Template of concurrent program through shell script Data Definition: java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \ -DB_USERNAME apps \ -DB_PASSWORD $apps_pw \ -JDBC_CONNECTION $v_host:$v_port:$v_sid \ -LOB_TYPE DATA_TEMPLATE \ -APPS_SHORT_NAME "XXFIN" \ -LOB_CODE "XXFIN_FA_ADDITIONS_EXTRACT" \ -LANGUAGE en \ -XDO_FILE_TYPE XML \ -FILE_CONTENT_TYPE 'text/html' \ -FILE_NAME "$XXFIN_TOP/install/xxfin_FA_Additions_Extract.xml" \ -CUSTOM_MODE FORCE Template: java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \ -DB_USERNAME apps \ -DB_PASSWORD $apps_pw \ -JDBC_CONNECTION $v_host:$v_port:$v_sid \ -LOB_TYPE TEMPLATE_SOURCE \ -APPS_SHORT_NAME "XXFIN" \ -LOB_CODE "XXFIN_FA_ADDITIONS_EXTRACT" \ -LANGUAGE en \ -XDO_FILE_TYPE RTF \ -FILE_CONTENT_TYPE 'application/rtf' \ -FILE_NA...