Uncompress and download Attachments

Objective:To uncompress the server's .SAF file and store the same in the local machine in local\SiebelRoot\Client\TEMP folder 

Example:In Contact-->Attachment applet one custom button is placed with Method = "EventMethodDownloadfile".Clicking on that button for a particular Contact Attachment record, .SAF file stored in the server will get uncompressed and downloaded in the local \SiebelRoot\Client\TEMP folder. 

Update user key Column for Product Entity, through EIM

Normally, User key updationare not possible through EIM except for few entities, of which Product is one. Here is a useful information to update one of the user key columns for Product (Product NAME for instance) through EIM.

 Solution:  

We can update Product name through EIM_PROD_INT_UK. EIM_PROD_INT_UK will enable us update a Product’s name from “Product 1” to “Product 2”.  

SIA Billing Extern Service /VBC Caching Concepts

The Caching VBC enhances the existing horizontal CSSBCVRec VBC class and works in conjunction with the SIA Billing Extern Service business service. Although the name of this business service implies that it is billing specific, it is a generic service without any industry-specific functionality.  The VBC must be based on the CSSFABCVRec class. 

The VBC uses the following four user properties for its configuration:  

Performance of SQL Queries

To check the performance of the application we get the spool and run the queries against the database to check the time it is taking. This check does not return the correct value of the time taken by query when executed through Siebel application. The reason being  when the query is executed Siebel application sets certain parameters at each session level.  Until you set the parameters in the database before execution of the query, correct performance cannot be evaluated.

Export data using dbisqlc.exe utility

DBISQLC.EXE is the utility used to connect to sample/local database for DML,DDL operations. But how do we export the results of a query to a file?

 Solution:

 By using ‘OUTPUT’ command.

 e.g.

SELECT * FROM SIEBEL.S_CONTACT

To export the data to a file for the above query you have to issue the following query

What is Fusion Applications?

A service-oriented architecture - which Oracle claims gives users the ability to uniquely manage functions across a heterogeneous environment.

A role-based user experience - that links exception-based processing, business intelligence, transactions and collaboration.

Embedded business intelligence - which Oracle says allows users to use BI within enterprise applications.

What does Oracle's release of Fusion Applications mean for its customers?

D&B Announces Availability of D&B360TM for Siebel CRM

D&B (NYSE: DNB), the world’s leading source of commercial information and insight on businesses, announced that D&B360 is now available for Oracle CRM On Demand and Oracle’s Siebel CRM. Now, Oracle customers can benefit from D&B’s data on more than 200 million global businesses and 53 million contacts, with information available where they need it – directly within the applications they use every day.

Recent content