下载文档原格式
一、HOST文件c://windows/system32/drivers/etc/hosts最后加入192.168.0.8 浏览器进入:8000user:yysoft_zhmpassword:yysoft2015二、TNS文件D:\DevSuiteHome_1\NETWORK\ADMIN\tnsnames.orayysoft=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) (CONNECT_DA TA=(SID=vis)))三、建表、同义词、序列-- Create tablecreate table CUX.HYP_VENDORS(VENDOR_ID NUMBER not null,VENDOR_CODE V ARCHAR2(20),VENDOR_NAME V ARCHAR2(50),ADDRESS1 V ARCHAR2(200),VENDOR_TYPE V ARCHAR2(1),CREATION_DA TE DATE,UPDATED_DATE DA TE);create or replace synonym HYP_VENDORSfor CUX.HYP_VENDORS;-- Create sequencecreate sequence hyp_vendors_sminvalue 1maxvalue 99999999start with 100001increment by 1;四、WHEN-NEW-FORM-INSTANCEgo_block(‘block_name’);app_window.set_window_position(‘child_block’,’center’,’parent_block’);五、QUERY-FINDgo_block(‘block_name’);六、PRE-INSERT:block_name.item_name := package_name.function_name(parameter1…);七、WHEN-NEW-RECORD-INSTANCEIf :block_name.item_name <> ‘N’ thenSet_block_property(‘block_name’,DELETE_ALLOWED |DEFAULT_WHERE,PROPERTY_FALSE);End if;八、记录组的建立Select_statement九、LOV的建立选择现有记录组LOV返回值LOV分配的项LOV高：4750，宽：3000十、开关服务器的步骤开机：按开机键登陆root 密码：Founder123进入数据库su –oracle 密码：oracle 输入：sh startDB.sh进入应用服务器su –applmgr 密码：applmgr 输入：sh startAPP.sh 关机：进入应用服务器su –applmgr 密码：applmgr 输入：sh stopAPP.sh 进入数据库su –oracle 密码：oracle 输入：sh stopDB.sh进入根目录su –root 密码：Founder123 输入：shutdown-h now十一、创建数据视图CREATE OR REPLACE VIEW view_name ASSelect_statement;十二、创建触发器CREATE OR REPLACE TRIGGER trigger_nameINSTEAD OF INSERT OR UPDATE OR DELETE ON view_nameFOR EACH ROWDECLAREBEGINIF inserting THENINSERT INTO table_name V ALUES();END IF;IF updating THENUPDA TE table_name set item = vlaue WHERE primary_key = primary_key;END IF;IF deleting THENDELETE FROM table_name WHERE primary_key = primary_key;END IF;END;十三、创建包规范和包体CREATE OR REPLACE package_name ISFUNCTION function_name(parameter_name IN | OUT | IN OUT V ALUE_TYPE, …) RETURN V ALUE_TYPE;PROCEDURE procedure_name(parameter_name IN | OUT | IN OUT V ALUE_TYPE, …);END package_name;CREATE OR REPLACE PACKAGE BODY package_name ISFUNCTION function_name(parameter_name IN | OUT | IN OUT V ALUE_TYPE, …) RETURN V ALUE_TYPE ISBEGINEND;END package_name;十四、五个固定字段的维护LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY数据块级别触发器PRE-INSERT、PRE-UPDATE中加入fnd_standard.set_who;十五、FORM中的对齐规则数字是右对齐字符，文字，日期是左对齐十六、设置数据块属性，才可以做增删改数据块的键模式：可更新数据块设置主键：是项主键：是设置主键初始值：:SEQUENCE.my_sequence.NEXTVAL十七、子类化所有显示项都要子类化TEXT-ITEMLISTCHECKBOXCURRENT_RECORD_INDICATOR十八、主子表在子表中建立主从关系，主数据块要正确，建立后，关系在主数据块上，子表中的外键的属性，从项中复制值：primary_block.primary_key十九、从一个FORM跳转到另一个FORM中在第一个FORM中加入按钮，加入WHEN-BUTTON-PRESSED触发器代码写：fnd_function.execute(FUNCTION_NAME => ‘form_name’,OPEN_FLAG => ‘Y’,SESSION_FLAG => ‘Y’,OTHER_PARAMS => ‘parameter_name = ’ || :block_name.item_name);二十、格式掩码设置999,999,999,999.00 当为零时显示.00999,999,999,990.00 可以显示0.00yyyy-mm-dd 日期格式掩码等二十一、查询PL/SQL数据字典SELECT ao.object_nameoFROM All_Objects aoWHERE ao.object_type LIKE'%SEQUENCE%'AND ao.owner LIKE'%APPS%';SELECT *FROM user_triggers utWHERE ut.trigger_name LIKE'%HYP%';二十二、异常声明：lv_error V ARCHAR2(200);lv_raise EXCEPTION;抛出：RAISE lv_raise; --引发异常异常处理：EXCEPTIONWHEN lv_raise THENFND_MESSAGE.SET_NAME(‘application_name’,’name’);FND_MESSAGE.SET_TOKEN(‘token_name’,lv_error);APP_EXCEPTION.RAISE_EXCEPTION;二十三、注册请求系统管理员→并发→方案→可执行系统管理员→并发→方案→定义系统管理员→安全性→请求二十四、请求为：PL/SQL存储过程PROCEDURE procedure_name（errbuf OUT NOCOPY V ARCHAR2，retcode OUT NOCOPY V ARCHAR2）IS BEGINfnd_file.PUT_LIEN(); --在查看输出中输出fnd_file.LOG(); --在日志中输出END;二十五、FORM中启动请求触发器：WHEN-BUTTON-PRESSEDDECLARElv_number NUMBER;BEGINlv_number := fnd_request.submit_request(application => 'appl_name', program => 'request_short_name',description => '',start_time => '',sub_request => FALSE,argument1 => argument1);END;二十六、PL/SQL游标DECLARECURSOR cursor_type ISselect_statement;cursor_name_rec cursor_type%ROWTYPE;BEGINFOR cursor_name_rec in cursor_type LOOPdbms_output.put_line(output_language);END LOOP;END;二十七、公用代码建立Application Developer→应用产品→代码→公用二十八、公用代码的查询SELECT lval.lookup_code, --制作LOV时，存入数据库的项lval.meaning,lval.description --制作LOV时，显示的项FROM fnd_lookup_types ltype,fnd_lookup_values lvalWHERE ltype.lookup_type = lval.lookup_typeAND lval.lookup_type = 'CUX_DEST_OFFICE'AND nguage = 'ZHS';二十九、子菜单制作先做一个菜单，把这个菜单放置在主菜单下。
