ITPub博客

ORACLE应用经验JAN-1(January) FEB-2(February) MAR-3(March)APR-4(April) MAY-5(May) JUN-6(June)JUL-7(July) AUG-8(August) SEP-9(September)OCT-10(October) NOV-11(November) DEC-12(December)[@more@]Sunday-1(周日) Monday-2(周一) Tuesday-3(周二) Wednesday-4(周三) Thursday-5(周四) Friday-6(周五) Saturday-7(周六)****************************常用设置********************************---on-log 触发器编写示范(form)Declareflag varchar2(80):=null;cou number:=1;n number;BeginLooplogon(USERNAME,PASSWORD||'@'||CONNEC

oracle erp 11.5.10限定org_id為14與57的,在shiping transaction的delivery頁簽下的waybill與ship method為必須,且只在輸入後才可以撿料與ship confirm.[@more@]方法為改..au/11.5.0/resource/下的custom.pllPROCEDURE EVENT(EVENT_NAME VARCHAR2) is...begin.../* Subject: Making Waybill and Ship Method fields of the Shipping Transactions form required fields for GUAC(14) and GUCA(57) only Author: Henry Tuan Date: August 21, 2006 modify by: longson.long at 2006.09 */ if FND_PROFILE.VALUE('ORG_ID') IN (14,57) and f

問題點： 工單未完工但訂單已做 ship confirm 造成訂單shipped卡住,但訂單closed, 工單無法完工入庫作法1．在後台先把庫存保留及訂單與工單關聯去掉(mtl_reservations)[@more@]2．這時工單與訂單關連消失,進行正常生產入庫3．在後台將訂單line狀態改為非closed(BOOKED), open_flag狀態改為Y4．在訂單line/tool/schedule/reservations details/指定保留數量,存檔 5 . 在訂單shipping/interface/run： Order Management Interface – SRSInventory Interface - SRS

1, 先把excel整理成item,price兩欄,此兩欄要是用'值'的方式保存,且不含小數,如有小數,先變成整數,如要2位小數,則全部*100.=round(price,2)*1002,把excel另存為.dbf檔3,用工具把.dbf導入oracle erp db中的import_price(item varchar2(20),item varchar2(20))臨時table4,用以下plus sql更新db[@more@]declare ifhave number; v_list_line_id number; v_list_header_id number;cursor cur_into(p_list_header_id in number) is select b.inventory_item_id ,round(a.price/100,2) price from (select distinct item,price from import_price)

是年公司的oracle erp升級到11.5.10,由我研究Xml 功能在erp report中的應用[@more@]共同點Output format都是選xmlView output 後看到的都是xml格式1, 用package的方式,挂Concurrent Programs時executable method選PL/SQL Stored Procedure优點: 生成的xml可以在view output或另存後直接用excel工具open,從而可以使用excel工具作進一步的處理,可依需求寫入多個sheet維護性高,可將相同參數的多種需求打包在一起,達到多種’layout’輸出的效果.對item description等比較長的字段,可以完整的展示給user.對開發人員來說,不用花大時間調layout,開