Menu

Thursday, November 5, 2009

Unlock Server Locked Business Component Locally (in Tools Local) using dbisqlc

You would have come across scenarios where you want to try a configuration on the business component,and unfortunately its locked on the Server. Here is the query to unlock the business component using dbislqc.

the following SQL query unlocks the 'Service Request' business component that is locked on the Server.

update siebel.S_BUSCOMP set OBJ_LOCKED_FLG='N' where NAME='Service Request';

commit;



You are considering using the ATTRIB_02 column on the S_SRV_REQ_X table and you want to determine which, if any, business component field is already using this column. What would you do?


A.Use Search Repository, select Column as the Type and enter ATTRIB_02 as the value.
B.Use the Flat tab, select the Field type, and search the Column property for ATTRIB_02 and the Join
property for S_SRV_REQ_X
C. Use the Flat tab, select the Column type, and search the Name property for ATTRIB_02.
D. Use the Types tab, search for Service* business components, inspect each of their Single Value Fields.
E. Use the Types tab, select the Service Request business component, then Single Value Field, and search the Column property for ATTRIB_02.


Highlight here for Answer: B