--请求组:Request Group 字段
SELECT distinct c.REQUEST_GROUP_NAME
--SELECT c.REQUEST_GROUP_NAME
FROM FND_CONCURRENT_PROGRAMS A,
fnd_request_group_units b,
fnd_request_groups c,
fnd_application d,
FND_EXECUTABLES F
where a.APPLICATION_ID=b.UNIT_APPLICATION_ID
and a.CONCURRENT_PROGRAM_ID=b.REQUEST_UNIT_ID
and b.APPLICATION_ID=c.APPLICATION_ID
and b.REQUEST_GROUP_ID=c.REQUEST_GROUP_ID
and a.APPLICATION_ID=d.APPLICATION_ID
--and a.APPLICATION_ID=f.APPLICATION_ID
and a.EXECUTABLE_ID=f.EXECUTABLE_ID
and f.EXECUTION_FILE_NAME like 'SUGA_JOB_MRR_MERGE'
order by 1
/
--查找锁:
select object_name as 对象名称,s.sid,s.serial#,p.spid as 系统进程号
from v$locked_object l , dba_objects o , v$session s , v$process p
where l.object_id=o.object_id
and l.session_id=s.sid
and s.paddr=p.addr;
/
--解锁:
alter system kill session '488,659'--sid,serial#
/
--查找表单的函数名
select fm.MENU_NAME,
fff.FUNCTION_NAME,
fff.USER_FUNCTION_NAME ,
fme.PROMPT
from fnd_menus_vl fm,
fnd_menu_entries_vl fme,
fnd_form_functions_vl fff
where fm.MENU_ID = fme.MENU_ID
and fme.FUNCTION_ID = fff.FUNCTION_ID
--and fme.GRANT_FLAG = 'Y' --Menu Line Grant Flag
and fff.FUNCTION_NAME = 'SUGA_QUICK_UPDECO' --Function Name
order by fff.FUNCTION_NAME;
/
----Set Org_id
begin
dbms_application_info.SET_CLIENT_INFO (88);
end;
/
------识别‘低效执行’的SQL语句----------------------------------
SELECT executions, disk_reads, buffer_gets,
ROUND ((buffer_gets - disk_reads) / buffer_gets, 2) hit_radio,
ROUND (disk_reads / executions, 2) reads_per_run, sql_text
FROM v$sqlarea
WHERE executions > 0
AND buffer_gets > 0
AND (buffer_gets - disk_reads) / buffer_gets < 0.8
ORDER BY 4 DESC;
-------------------------------------------------------------------
/
Table名
mtl_system_items ---基本物料表
mtl_material_transactions---事务处理表
mtl_transaction_types ---事务处理类型
mtl_txn_source_types ---事务处理资源类型
oe_order_headers_all ---销售订单Head
oe_order_lines_all ---销售订单Line
mtl_customer_item_xrefs_v ----Compnay Item and Customer Item Corss References
bom_structures_b ---BOM结构物料
bom_components_b ---BOM部件物料
mtl_customer_items ---客户物料表
hz_customer_party_find_v ---客户信息
rcv_shipment_lines ---接收PO物料LINE
rcv_shipment_headers ---接收PO物料HEAD
po_lines_all pol ---采购Line
po_headers_all poh ---采购Head
wip_discrete_jobs ---工单
Fnd_user ---系统用户表
mtl_onhand_quantities_detail ----仓库物料数量表
/
---------------------------------------简称---------------------------------
Inventory INV 事务处理
Bills of material BOM 物料清单(生产前用的),开工单等动作
Engineering ENG 工程(产品设计)
Supply chain planning / Master Scheduling/MRP MRP 计划装配(计算需求与供应的关系)
Purchasing PO 采购
Order management ONT 订单管理
WIP(WorkinProcess) WIP 工单类(生产加工中用到的)
Receivables AR 收据清单
General Ledger GL 总账
Payables AP
Shipping Execution WSH
Application Object Library Au
------------------------------------------------------------------------------
/
---------------------------------ERP配置设置---------------------------------------
192.168.2.20 erpnew erpnew.suga.com.hk
192.168.2.21 erpnew_discover erpnew_discover.suga.com.hk
192.168.2.11 erpuat erpuat.suga.com.hk
10.10.20.4 erpnodic erpnodic.suga.com.hk
10.10.20.7 erpnodicuat erpnodicuat.suga.com.hk
----------------------------------------------------------------------------------------
/
Personalization
1.备份原/Personalization中文件Function Name 或 Form Name (依据修改的是Function还是Form来备份)
2.在PuTTY中运行如下(选择不同环境)
Suga:
. /prod/PROD/prodora/8.0.6/PROD_erpnew.env
. /prod/PROD/prodappl/PROD_erpnew.env
Nodic:
. /prod/PROD/prodora/8.0.6/PROD_erpnodic.env
. /prod/PROD/prodappl/PROD_erpnodic.env
Both:
export FORMS60_PATH=/prod/PROD/prodappl/au/11.5.0/resource:/prod/PROD/prodappl/au/11.5.0/resource/stub:/prod/PROD/prodappl/au/11.5.0/forms/US
cd /prod/PROD/prodappl/personalization
--Form(修改LDT文件名字Form_Name)
FNDLOAD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct SUGA_PO_VENBUYER.ldt FND_FORM_CUSTOM_RULES form_name=SUGA_PO_VENBUYER
--Function(修改LDT文件名字Function_Name)
FNDLOAD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct INV_INVTOTRX.ldt FND_FORM_CUSTOM_RULES function_name=INV_INVTOTRX
3.检查生成的LDT文件,查看Description是否与书写的相符
4.以邮件形式发给Dick摆放到正式环境
1.Forms编译过程
Suga:
. /prod/PROD/prodora/8.0.6/PROD_erpnew.env
. /prod/PROD/prodappl/PROD_erpnew.env
Nodic:
. /prod/PROD/prodora/8.0.6/PROD_erpnodic.env
. /prod/PROD/prodappl/PROD_erpnodic.env
Both:
export FORMS60_PATH=/prod/PROD/prodappl/au/11.5.0/resource:/prod/PROD/prodappl/au/11.5.0/resource/stub:/prod/PROD/prodappl/au/11.5.0/forms/US
cd /prod/PROD/prodappl/inv/11.5.0/forms/US
f60gen module=SUGA_WIP_TAG.fmb userid=APPS/miscomputer module_type=form batch=no compile_all=special
1.PLL编译过程。
上面同样要执行,以下就执行PLL文件
cd /prod/PROD/prodappl/au/11.5.0/resource/
f60gen module=CWIPDJMDF.pll userid=apps/miscomputer output_file=CWIPDJMDF.plx module_type=library batch=yes compile_all=special
f60gen module=CWIPDJMDF.pll userid=apps/miscomputer output_file=$AU_TOP/resource/CWIPDJMDF.plx module_type=library batch=yes compile_all=special