系统弹性域创建（System elastic domain creation）.docVIP

系统弹性域创建（System elastic domain creation） (1) key elastic domains I. application of registry key flexible domains: 1, build COMBINATIONS table, in order to simple only two segments Create table FND_KEYFLEX_T ( CODE_COMBINATION_ID NUMBER (15) not null, CHART_OF_ACCOUNTS_ID NUMBER (15) not null, SEGMENT1 VARCHAR2 (25), SEGMENT2 VARCHAR2 (25), ENABLED_FLAG VARCHAR2 (1), SUMMARY_FLAG VARCHAR2 (1), START_DATE_ACTIVE DATE, END_DATE_ACTIVE DATE, LAST_UPDATED_BY NUMBER, LAST_UPDATE_DATE DATE, CREATED_BY NUMBER, CREATION_DATE DATE ) / Create, unique, index, FND_KEYFLEX_T_U1, on, FND_KEYFLEX_T (CODE_COMBINATION_ID) / Grant, select, insert, update, delete, on, FND_KEYFLEX_T, to, PUBLIC / Create, public, synonym, FND_KEYFLEX_T, for, FND_KEYFLEX_T / Create sequence FND_KEYFLEX_T_S MinValue 1 Maxvalue 2000000000 Start with 1 Increment by 1 Cache 20 Order / Grant, select, on, FND_KEYFLEX_T_S, to, public / And The key elastic domain COMBINATIONS table must include these sections: (1) unique ID column (2) KEY segment, SEGMENT1, SEGMENT2, and SEGMENTn (3) ENABLED_FLAG and SUMMARY_FLAG columns (4) START_DATE_ACTIVE and END_DATE_ACTIVE columns (5) some WHO columns (6) structure ID column (7) a sequence called table name _S And 2. use the AD_DD package registry to associate the application name EBS of SQLGL Begin Ad_dd.register_table (SQLGL,FND_KEYFLEX_T,T, 10,10,40); Commit; End; 3. wrap each column with the AD_DD package registry Begin Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,CODE_COMBINATION_ID, 1,NUMBER, 15,N,N); Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,CHART_OF_ACCOUNTS_ID, 2,NUMBER, 15,N,N); Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,SEGMENT1, 3,VARCHAR2, 25,N,N); Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,SEGMENT2, 4,VARCHAR2, 25,N,N); Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,ENABLED_FLAG, 5,VARCHAR2, 1,N,N); Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,SUMMARY_FLAG, 6,VARCHAR2, 1,N,N); Ad_dd.register_column (SQLGL,FND_KEYFLEX_T,START_DATE_ACTIVE, 7,DATE, 7,N,N); Ad_dd.register