VB Macro to split single column into multiple row delimited by Alt + Enter

Sub tst()    
    Dim X As Variant
    Dim iIndex As Integer


    iIndex = 1
    For i = 1 To WorksheetFunction.CountA(Worksheets("Sheet2").Range("B:B")) + 1
        If Range("B" & i).Value = "" Then Exit For
        X = Split(Range("B" & i).Value, Chr(10))
        Range("D" & iIndex).Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X)
        'For j = iIndex To iIndex + UBound(X)        
            '    Range("C" & j).Value = Range("A" & i).Value       
        ' Next
        iIndex = iIndex + UBound(X) + 1
    Next
End Sub

VB Macro to split data in single cell into multiple rows.  Assumptions 1: Data in the row is split by "Alt + Enter", Assumption 2: Data to be split is available in column B

IsPrimaryMVG field is not exported in Query / Query Page

Rather we can expose the field "SSA Primary Field" that will help to find which is the "Primary" record in MVG

EAI Object Manager Parameters for Tracing SQL and Log

EAI Siebel Adapter Performance

EAI Query Specification
EAI Siebel Adapter
EAI UI Data Services Events
Web Service Inbound
SQL Error
SQL Parse and Execute
SQL Slow Query
Workflow Performance

How to use OPATCH to install QF?

How to Install QF from 8.1.1.1 using oPatch [ID 845450.1]

Basic Rules:

1. To apply Patch on Mobile Web Client/Tools, change directory to webclient\OPatch & Tools\OPatch folder
2. Run the command "OPatch apply




"

Visibility

HOWTO use session management web services to log in as SADMIN and create data under a different user ? [ID 747584.1]

Visibility Search Spec of Siebel

My Quotes - [Sales Team Rep Id] = PositionId() AND [IsPCQuoteType] = 'N'


My Team's Quotes - [Sales Rep Reports To] = PositionId() AND [IsPCQuoteType] = 'N'


All Quotes  - [Organization Id] = OrganizationId() AND [IsPCQuoteType] = 'N'


All Quotes Across Organization - No Search Spec

How to increase the EAI object manager log

To produce the EAI Object Manager detailed log, Please log in to server manager command line and issue the command:




Eg: srvrmgr> change evtloglvl %=5 for comp EAIObjMgr_ENU
Eg: srvrmgr> change param enableserviceargtracing=true for comp EAIObjMgr_ENU



After you get the logs, reset the object manager log to the usual level:

Eg: srvrmgr> change evtloglvl %=1 for comp EAIObjMgr_ENU
Eg: srvrmgr> change param enableserviceargtracing=false for comp EAIObjMgr_ENU



Some logs should be generated on LOG directory.
- Logs with dmp extension.
- EAI Component log.