thesiebelscholar.blogspot.com
The Siebel Scholar: December 2012
http://thesiebelscholar.blogspot.com/2012_12_01_archive.html
Wednesday, December 12, 2012. Miscellaneous SQL Repository Research. I frequently use SQL to track down potential issues in the repository. Here are a couple of statements that help solve common problems:. Fields Inactivated in the BC but Active in the Integration Object. Select io.name int obj, ic.name int comp, icf.NAME int field from siebel.S INT FIELD icf, siebel.S INT COMP ic, siebel.S INT OBJ io, siebel.s repository r, siebel.s buscomp bc, siebel.s field f. And cTBL ID = t.row id and t.NAME...And r...
thesiebelscholar.blogspot.com
The Siebel Scholar: July 2010
http://thesiebelscholar.blogspot.com/2010_07_01_archive.html
Friday, July 23, 2010. My Barcode Promised Land. The effort of trial and error, traversing dead ends. Barring all that, I still needed a couple of basic things:. Hook to trigger additional functional logic. Do lookups on Serial Numbers. Additionally, it would be nice to:. Minimize the number of clicks. Do lookups on the child record of a BC. Parse the input so that I could do different stuff based on the type of data. I can just do my own query once in the Active object and then trigger my post events.
thesiebelscholar.blogspot.com
The Siebel Scholar: September 2011
http://thesiebelscholar.blogspot.com/2011_09_01_archive.html
Tuesday, September 13, 2011. Here is a general methodology for identifying and fixing performance issues. For the OM component having the issue, change the Server Configuration event logging level to 4 for these events:. SQL Parse and Execute. Object Manager SQL Log. Execute the operation that performs the slow query. Open the corresponding OM log and find the SQL statement representing the slow query. Finding the statement can be done in a couple of ways, but I use the following:. If indexes are not an ...
thesiebelscholar.blogspot.com
The Siebel Scholar: March 2011
http://thesiebelscholar.blogspot.com/2011_03_01_archive.html
Tuesday, March 29, 2011. Column Preferences. Is it just me or does the Tools client not save preferences the way the Siebel client does. Rearranging columns usually works, but changing widths do not seem to save. PDQs The idea of Bookmarks is nice but I hate the fact that drilling down or using them loses the context of my exporer pane when I go back. PDQs on every object like within the Siebel Client (and the ability to set default PDQs for each view) would do wonders. I have mainly limited this list to...
thesiebelscholar.blogspot.com
The Siebel Scholar: May 2010
http://thesiebelscholar.blogspot.com/2010_05_01_archive.html
Friday, May 28, 2010. I have been working with my eScript logging framework. Buffer the output. It strikes me that I will do the exact same thing Siebel does with its own log files. Ever notice that the SQL Spool file or server log files are not always completely up to date with what you are executing in the GUI? Var giLogBuffer = Frame.GetSysPref("Log Buffer");. Var giLogLines = 0;. Var giLogCache = " ;. Step : function ( text, Lvl ) {. GiLogLines = giLogBuffer) {. Clibfputs(giLogCache, fp);. I would pr...
thesiebelscholar.blogspot.com
The Siebel Scholar: January 2012
http://thesiebelscholar.blogspot.com/2012_01_01_archive.html
Tuesday, January 3, 2012. My BI Quick Reference. I know there are a bunch of cheat sheets out there, but I frequently don't find everything I am looking for in one place so figured I would just start building my own. Namespace:psfn=http:/ www.oracle.com/XSL/Transform/java/com.siebel.xmlpublisher.reports.XSLFunctions? Psfn:totext(OrderDate,"MM/dd/yyyy","MM/dd/yyyy hh:mm:ss")? Basic Loop where QuoteItem is the Integration Component/XML Group. Loop that groups by the column LineType and sorts by the grouping.
thesiebelscholar.blogspot.com
The Siebel Scholar: November 2010
http://thesiebelscholar.blogspot.com/2010_11_01_archive.html
Monday, November 15, 2010. A Basic Interface - Integration Object User Props. This is the most common Integration Component Field User Property you will see and it basically tells the EAI Siebel Adapter to validate the picklist in the interface. This property is generally created by the wizard so I bring it up only because validating the picklist here will allow for several different ways to interpret a picklist field value described by some of the user properties below. Subscribe to: Posts (Atom).
thesiebelscholar.blogspot.com
The Siebel Scholar: June 2010
http://thesiebelscholar.blogspot.com/2010_06_01_archive.html
Tuesday, June 29, 2010. EScript Framework - Logging Variables. Here is another entry into the logging framework previously discussed. The idea behind this function is to Log multiple variable values to separate lines of our log file using a single line of script. This keeps our script pristine and makes the log file well organized and easy to read. The script to call the function is as follows:. LogstepVars("Record Found", bFound, " Account Id", sId);. The results will be written to the log file as:.
thesiebelscholar.blogspot.com
The Siebel Scholar: August 2010
http://thesiebelscholar.blogspot.com/2010_08_01_archive.html
Tuesday, August 17, 2010. Common (or not) eScript Syntax Errors. I would love to post a comprehensive list of gotchas, but then that would make them not gotchas if you know what I mean as I would know them all. So instead, I will mention what sidelined me for several hours last night and hope to spur some discussion about what other people have come across. If I think of others over time, I will try to update this post. Space after the function name. Subscribe to: Posts (Atom). Subscribe in a reader.
thesiebelscholar.blogspot.com
The Siebel Scholar: October 2010
http://thesiebelscholar.blogspot.com/2010_10_01_archive.html
Friday, October 29, 2010. A Basic Interface - Web Service Workflow. Just about every interface consists of two basic components: the integration object. S) and the workflow or business service. I will demonstrate a workflow approach which will give you more opportunity to customize down the road. There is one Output Argument. We no longer care about the input message at this point because it will have been applied so we just overwrite it with the return, which in this case will be the status key. The out...
