Siebel

Incorporating Global Data Quality within Siebel Applications

To ensure optimal data quality within Oracle’s Siebel applications, companies need to improve data integrity, remove duplicate data, and maintain peak condition data. The Trillium Software Data Quality Connector for Siebel supports seamless integration of Trillium Software data cleansing and standardization capabilities within the Siebel Enterprise Application 8 suite of products.

To Avoid Duplicate Field Values In A Field Of Business Component

Most of us must have come across the requirement in Siebel to avoid Duplicates in a Business Component for a particular field. Every time when we get such requirement, without thinking on configuration we go for Scripting in Pre_Write Record of Business component. Here is an approach using configuration and it really helps.
 

Drill down from a control in Form Applet

Scenario:
Drill down from the control IDC in Account Entry Applet and navigate to a View Named Account Detail - Contacts View
 
Configuration:
In Tools, navigate to Account business component
 
1.      Create new field
 

Field Name 

IDC

Join

S_ORG_EXT_X

Column  

ATTRIB_09 (take any column for this)

Drill down from a control in Form Applet

Scenario:
Drill down from the control IDC in Account Entry Applet and navigate to a View Named Account Detail - Contacts View
 
Configuration:
In Tools, navigate to Account business component
 
1.      Create new field
 

Field Name 

IDC

Join

S_ORG_EXT_X

Column  

ATTRIB_09 (take any column for this)

EIM Tuning to improve performance

Through EIM process we load bulk amount of data from an external system to Siebel base tables. The performance of these EIM  
 jobs has to be maintained at optimum levels in order to reduce the load on the Siebel application and database servers. The
 following tips will help you in improving the EIM performance. Do a round of validation in development environment before running  
 the EIM jobs on Production systems
 

Disable the button to prevent the double click in Siebel

Requirement:  We have scenario like where we have payment interface which has been triggered by Payment button on Payment applet. Now customer want to make sure this button would be pressed only once till the request is not get processed successfully.

Workaround: This can be achieved by two options. First one is browser script and another is very siebel and also applicable for eService as well

Browser Scripting in Standard Interactivity

I have never been fan of SI applications because of the unpredicatble limitations it offers. But however recently one of my friend cum life saver,Vinay Jain aka Vivacious,asked me a trivia and i was forced to jump into the ocean.

Activate Multiple Workflows with Search String in Siebel

Sometime during Siebel deployment from one environment to another environment or for vanilla functionality like Siebel Order management we need to activate set of workflows one by one. This process might take huge time and could bring human errors like Admin people might forget to activate one or more workflow unknowingly.