Kumar HarshKumar Harsh Staff asked 2 years ago
Title : How can I assess level of customisation? Can you please help?

Question :

How can I assess level of customisation? Can you please help?

1 Answers
Kumar HarshKumar Harsh Staff answered 2 years ago

Dear Suresh,
 
There are complex analysis of repository objects are required like upgrade ancestor and upgrade behaviour though for quick reference we can execute the below sql can get high level estimate of the customizations.
 
Where input date is the implementation project start date. In case current application version is upgraded from previous version then the SQL is required to be executed twice with implementation project start date and upgrade project start date.
 
select ‘Type’, ‘Vanilla’,’Custom’,’Vanilla Modified’,’Total’ FROM S_DUAL union
select ‘S_APPLET’, (select to_char(count(*)) from S_APPLET where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_APPLET where created > :1), (select to_char(count(*)) from S_APPLET where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_APPLET) from s_dual union
 
select ‘S_ASGN_ATTR’, (select to_char(count(*)) from S_ASGN_ATTR where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_ASGN_ATTR where created > :1), (select to_char(count(*)) from S_ASGN_ATTR where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_ASGN_ATTR) from s_dual union
 
select ‘S_ASGN_ITEM_TYPE’, (select to_char(count(*)) from S_ASGN_ITEM_TYPE where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_ASGN_ITEM_TYPE where created > :1), (select to_char(count(*)) from S_ASGN_ITEM_TYPE where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_ASGN_ITEM_TYPE) from s_dual union
 
select ‘S_BITMAP_CAT’, (select to_char(count(*)) from S_BITMAP_CAT where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_BITMAP_CAT where created > :1), (select to_char(count(*)) from S_BITMAP_CAT where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_BITMAP_CAT) from s_dual union
 
select ‘S_BUSOBJ’, (select to_char(count(*)) from S_BUSOBJ where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_BUSOBJ where created > :1), (select to_char(count(*)) from S_BUSOBJ where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_BUSOBJ) from s_dual union
 
select ‘S_SERVICE’, (select to_char(count(*)) from S_SERVICE where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_SERVICE where created > :1), (select to_char(count(*)) from S_SERVICE where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_SERVICE) from s_dual union
 
select ‘S_CLASS’, (select to_char(count(*)) from S_CLASS where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_CLASS where created > :1), (select to_char(count(*)) from S_CLASS where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_CLASS) from s_dual union
 
select ‘S_COMMAND’, (select to_char(count(*)) from S_COMMAND where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_COMMAND where created > :1), (select to_char(count(*)) from S_COMMAND where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_COMMAND) from s_dual union
 
select ‘S_CONTENT_OBJ’, (select to_char(count(*)) from S_CONTENT_OBJ where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_CONTENT_OBJ where created > :1), (select to_char(count(*)) from S_CONTENT_OBJ where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_CONTENT_OBJ) from s_dual union
 
select ‘S_DLL’, (select to_char(count(*)) from S_DLL where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_DLL where created > :1), (select to_char(count(*)) from S_DLL where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_DLL) from s_dual union
 
select ‘S_EXT_SRCH_ENG’, (select to_char(count(*)) from S_EXT_SRCH_ENG where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_EXT_SRCH_ENG where created > :1), (select to_char(count(*)) from S_EXT_SRCH_ENG where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_EXT_SRCH_ENG) from s_dual union
 
select ‘S_FIND’, (select to_char(count(*)) from S_FIND where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_FIND where created > :1), (select to_char(count(*)) from S_FIND where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_FIND) from s_dual union
 
select ‘S_HIERARCHY_BMP’, (select to_char(count(*)) from S_HIERARCHY_BMP where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_HIERARCHY_BMP where created > :1), (select to_char(count(*)) from S_HIERARCHY_BMP where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_HIERARCHY_BMP) from s_dual union
 
select ‘S_HELP_ID’, (select to_char(count(*)) from S_HELP_ID where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_HELP_ID where created > :1), (select to_char(count(*)) from S_HELP_ID where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_HELP_ID) from s_dual union
 
select ‘S_ICON_MAP’, (select to_char(count(*)) from S_ICON_MAP where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_ICON_MAP where created > :1), (select to_char(count(*)) from S_ICON_MAP where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_ICON_MAP) from s_dual union
 
select ‘S_IMPORT_OBJECT’, (select to_char(count(*)) from S_IMPORT_OBJECT where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_IMPORT_OBJECT where created > :1), (select to_char(count(*)) from S_IMPORT_OBJECT where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_IMPORT_OBJECT) from s_dual union
 
select ‘S_INT_OBJ’, (select to_char(count(*)) from S_INT_OBJ where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_INT_OBJ where created > :1), (select to_char(count(*)) from S_INT_OBJ where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_INT_OBJ) from s_dual union
 
select ‘S_LINK’, (select to_char(count(*)) from S_LINK where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_LINK where created > :1), (select to_char(count(*)) from S_LINK where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_LINK) from s_dual union
 
select ‘S_MENU’, (select to_char(count(*)) from S_MENU where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_MENU where created > :1), (select to_char(count(*)) from S_MENU where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_MENU) from s_dual union
 
select ‘S_ERR_MSG_CAT’, (select to_char(count(*)) from S_ERR_MSG_CAT where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_ERR_MSG_CAT where created > :1), (select to_char(count(*)) from S_ERR_MSG_CAT where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_ERR_MSG_CAT) from s_dual union
 
select ‘S_PICKLIST’, (select to_char(count(*)) from S_PICKLIST where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_PICKLIST where created > :1), (select to_char(count(*)) from S_PICKLIST where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_PICKLIST) from s_dual union
 
select ‘S_TABLE’, (select to_char(count(*)) from S_TABLE where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_TABLE where created > :1), (select to_char(count(*)) from S_TABLE where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_TABLE) from s_dual union
 
select ‘S_TOOLBAR’, (select to_char(count(*)) from S_TOOLBAR where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_TOOLBAR where created > :1), (select to_char(count(*)) from S_TOOLBAR where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_TOOLBAR) from s_dual union
 
select ‘S_OBJ_TYPE’, (select to_char(count(*)) from S_OBJ_TYPE where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_OBJ_TYPE where created > :1), (select to_char(count(*)) from S_OBJ_TYPE where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_OBJ_TYPE) from s_dual union
 
 
select ‘S_WEB_PG’, (select to_char(count(*)) from S_WEB_PG where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_WEB_PG where created > :1), (select to_char(count(*)) from S_WEB_PG where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_WEB_PG) from s_dual union
 
select ‘S_WEB_TMPL’, (select to_char(count(*)) from S_WEB_TMPL where created <= :1 and modification_num = 0), (select to_char(count(*)) from S_WEB_TMPL where created > :1), (select to_char(count(*)) from S_WEB_TMPL where created <= :1 and modification_num > 0), (select to_char(count(*)) from S_WEB_TMPL) from s_dual;
 
Let me know in case you have any more queries.

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.