ITPub博客

微博上看到的，转载记录下IBM把服务这块做的确实是好

Index是不存储NULL值的，所以如果你有NULL的条件在SQL中，那么相关的索引是用不到的。CREATE TABLE PTIAN1 AS (SELECT * FROM DBA_OBJECTS); CREATE INDEX PTIAN_INDEX ON PTIAN1(DATA_OBJECT_ID); EXEC DBMS_STATS.GATHER_TABLE_STATS(\'APPS\',\'PTIAN1\', CASCADE=>TRUE );SELECT * FROM PTIAN1 WHERE DATA_OBJECT_ID = 11;SELECT * FROM PTIAN1 WHERE DATA_OBJECT_ID IS NULL;解决方法创建Function-Based Index CREATE INDEX PTIAN_FUNC_INDEX ON PTIAN1 (NVL(DATA_OBJECT_ID,-1)); E

Basic Data Flow in ReceivingPO Receipt for Inventory destinationPO Receipt for lot controlled itemsPO Receipt for serial controlled itemsInterorg Transfer Receipt – In transit Shipment Interorg Transfer Receipt – In transit Shipment for lot controlled itemsInterorg Transfer Receipt – In transit Shipment for serial controlled itemsInternal Sales Order – In transit Shipment Abbr.RCV模块表的缩写对照表RHI - Rcv_Headers_InterfaceRTI – Rcv_Transactions_InterfaceRTP – Receiving

一个表中有三个字段，XX,YY,ZZ，如果要建立给这三个字段建组合索引(Composite Index)，组合索引中字段的顺序应该遵循怎样一个原则。一般的原则：越离散的字段越靠前。哪个列可以降低索引的扫描成本就放在前面。比如：下位三个字段的离散情况XX:2YY:1000ZZ:50000那么建立索引的顺序应该为：ZZ,YY,XXCREATE INDEX t_idx ON t (zz,yy,xx);但是如果where条件中，三个字段的条件都是通过"="

对于EBS可以查询：SELECT TERRITORY_CODE,TERRITORY_SHORT_NAME,DESCRIPTION FROM FND_TERRITORIES_VL;语言缩写(abbr)和对应的语言Language NameLanguage AbbreviationDefault SortAMERICANusbinaryARABICarARABICASSAMESEasbinaryAZERBAIJANIazAZERBAIJANIBANGLAbnbinaryBRAZILIAN PORTUGUESEptbWEST_EUROPEANBULGARIANbgBULGARIANCANADIAN FRENCHfrcCANADIAN FRENCHCATALANcaCATALANCROATIANhrCROATIANCYRILLIC KAZAKHckkGENERIC_MCYRILLIC SERBIANcsrGENERIC_MCYRILLIC UZBEKcuzGENERIC_MCZECHcsCZECHDANISHdkDANIS

如何查看某个数据库对象（TABLE, INDEX ....）所占得物理存储空间SELECT SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,EXTENTS,BLOCKS,BYTES/1024/1024/1024  GB FROM DBA_SEGMENTS WHERE SEGMENT_NAME = Upper(\'MTL_MATERIAL_TRANSACTIONS\'); Oracle逻辑结构全景结构图 Oracle 逻辑结构的相关数据字典：SELECT * FROM DBA_TABLESPACES -- 记录各个表空间的详细信息 SELECT * FROM DBA_TABLESPACE_USAGE_METRICS -- 记录各个表空间的使用状况 SELECT * FRO

CREATE OR REPLACE procedure cc_shipping as l_return_status VARCHAR2(2000); l_msg_count NUMBER; --l_msg_data VARCHAR2(1000); pp_init_msg_list VARCHAR2(10) := FND_api.G_FALSE; pp_return_values VARCHAR2(10) := FND_api.G_FALSE; pp_action_commit VARCHAR2(10) := FND_api.G_FALSE; xx_return_status VARCHAR2(1); xx_msg_count NUMBER; xx_msg_data VARCHAR2(2000); trip_id number; trip_name varchar2(2000); l_msg_index_out number; l_msg_data varchar2(2000); x_msg_summary varchar2(2000); x_msg_details varchar

MTL_TRANSACTIONS_INTERFACE和MTL_MATERIAL_TRANSACTIONS_TEMP有三个类似的字段：TRANSACTION_HEADER_ID & TRANSACTION_BATCH_ID & TRANSACTION_BATCH_SEQ以下为eTRM里关于这三个字段的解释：TRANSACTION_HEADER_ID:Transaction group identifier and Workers, only user-specified values will be ignored.TRANSACTION_BATCH_ID:Batch id for transactionTRANSACTION_BATCH_SEQ:Batch sequence for transaction从字面上看，三个字段意思似乎是一样的，但其实三个字段有

The header/appl/oracle/admin/EI1T/udump/ei1t_ora_14246.trc Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production JServer Release 9.2.0.3.0 - Production ORACLE_HOME = /appl/oracle/product/9.2.0 System name: SunOS Node name: sdsunn01 Release: 5.9 Version: Generic_112233-08 Machine: sun4u Instance name: EI1T Redo thread mounted by this instance: 1 Oracle process number: 17 Unix process pid: 14246, image: oracle@sdsunn01?(TNS V1-V3) *** 2003-10-13 16:13:59.

这么多浏览器，还是Firefox用的最顺手，记录下当前的Add-on列表,以备后用,mozilla上我也创建了一个Add-on Collection:PTIAN Firefox CollectionAdd-on ListAdblock PlusAdd to Search BarBetter BugBoss Key and ButtonsCtrl-TabDelicious BookmarksDelicious ExtensionDownload StatusbarDownloadHelperDownThemAll!Easy DragToGo+Evernote Web ClipperExtension List DumperFEBEFind In NumbersFireFTPFlagfoxFoxClocksGoogle Tasks PanelGoogle Translator for Firefoxgoogle-no-tracking-urlGre

高人在民间，无意间发现了一牛人用Oracle Form写的九宫格游戏(Sudoku Game)，有兴趣的童鞋可以挂在自己EBS系统里，做账做累了玩玩:)详见原帖：SUDOKU.fmb -- An Oracle Forms Sudoku game programForm源码下载：Click here to download sudoku.fmb 304 KB

DBMS_UTILITY.GET_TIME常用于计算某段代码间的时间消耗，DBMS_UTILITY.GET_TIME返回值本身并不是指当前的时间，而是一个the number of 100ths of seconds that have elapsed from an arbitrary time.Usage NotesYou should not use GET_TIME to establish the current time, but only to calculate the elapsed time between two events. Without GET_TIME, Oracle functions can only record and provide elapsed time in second intervals, which is a very coarse granularity in today\'s world

之前写过EBS下的PL/SQL Profiling 调试的文章，PL/SQL Profiling用于调试EBS下PL/SQL（如:Procedure,Function）的性能情况。今天抛开EBS这个特定的产品,写一下如何使用DBMS_PROFILER这个Package，如何获取PL/SQL中各段代码的执行时间。DBMS_PROFILER的官方介绍：http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_profil.htmDBMS_PROFILER Installation一般情况下DBMS_PROFILER的Package和Table都已经安装，如果你的数据库里没有D

Dual UOM是随着Process Manufacturing（流程制造）的加入，在Oracle EBS R12中新加的特性。对于Dual UOM的物料，查库存时，Workbench不仅会显示主计量单位(Primary UOM)，同时也会显示次计量单位（Secondary UOM）。Dual UOM适用于特定的行业，比如化工，食品...，具体的例子，以牛肉为例，在欧美常常以磅(Pounds)作为牛肉主计量单位，但中国更习惯使用公斤来作为主计量单位。对于这样的物料就有

From SQL Query1. Create a Record Group(RG)2. Create RG SQL Query asSelect 1,2,3,4,5 from dual;Make sure you set the datatype accordingly w.r.t your col in the dynamic query to be used in the below package.Here 1,2,3,4,5 represents the number of columns for your query3. Create an LOV an attach this RG to it4. Add the below logic to the trigger, Click on the field to which LOV is attached. it will show up.DECLARE result Number; rec_id RecordGroup; rwcnt NUMBER; p_lovname VARCHAR2(40);

Min-max planning is a method of determining  when and how much to order based on userdefined minimum and maximum inventory levels.Reorder Qty=  (Max quantity) - [(onhand qty)+(qty on order)] = 1000 - [50 + 0]When to Order?Typically, you should order when: On-hand quantity + supply ? demand < minimum Min-Max Planing:How Much to Order?Order Quantity = (Max quantity) - [(onhand qty)+(qty on order)]Restock：Enter Yes or No to indicate whet

Development Tools页签 > Visual Basic Editor (Alt+F11)，然后VB Editor界面下，Tools>VBAProject Properties设置后需保存并重新打开才能生效

1.定义一个测试Procedure,这个Procedure用于给临时表插入一条记录create sequence pt_debug_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加，不循环 CACHE 10; --1. Create temp table. create table pt_debug_tab (seq INTEGER,text Varchar2(300),datetag Varchar2(30)); --2. Create procedure. create or replace procedure pt_debug(inStr Varchar2) as PRAGMA AUTONOMOUS_TRANSACTION; BEGIN INSERT INT

Message简单的弹出一个消息MsgBox ("Common Msg")  显示某个单元格的信息MsgBox "Cell A1 is " & Range("A1").Value  加入换行MsgBox "Line 1 Content" & vbNewLine & "Line 2 Content"  单元格赋值Range("A1").Value = "code placed here"orWorksheets(1).Range("A1").Value = \'value\'Sheet的数量Worksheets.Count增加SheetWorksheets.Add行的选择Worksheets(1).Rows(2).Select列

1.简单的弹出一个消息MsgBox ("Common Msg")2.显示某个单元格的信息MsgBox "Cell A1 is " & Range("A1").Value3.加入换行MsgBox "Line 1 Content" & vbNewLine & "Line 2 Content"