Clear Text

Friday, December 30, 2016

Back to Siebel

After about 2 years of getting lost in various Oracle clouds, I am finally back to the Siebel game. Right on the latest version, Siebel IP 2016. Open UI. Yup, that’s there. And on a telecom project with tonnes of EAI integration and Order Management. And now I truly see why Siebel cannot be fully replaced. Until a worthy contender and full cloud replacement comes in, these kind of projects can only be implemented in Siebel.

I’ve come to understand that Oracle Cloud is a joke. At least for the time being, it can only be used for medium sized companies who have standard sales and service business processes. The amount of extensibility available is very less. And although one can write their own customization on Oracle PaaS and Java Clouds, that kind of beats the purpose anyway. The whole point of modern cloud is to reduce the amount of code written.

I’m hoping to ride out this last wave of Siebel projects before I too am forced to move to the cloud for good.

For the time being, it’s good to be back. Happy New Year !

Thursday, December 1, 2016

TCC: Date Manipulation

cleartext.blogspot.com

<quer:projection id="idEEO2bDisabledPersonAnswerNo" alias="CorrectedStartDate">
    
    <quer:query projectedClass="Location" alias="Corr_Start_Dt">
        <quer:projections>
            <quer:projection>
                <quer:add>
                    <quer:field ownerQuery="MainQuery" path="Applications,Offers,ActualStartDate"/>cleartext.blogspot.com
                    <quer:divide>
                        <quer:add>
                            <quer:field path="NetworkLocation,TimeZone,Offset"/>
                            <quer:multiply>
                                
                                <quer:add>
                                    <quer:customFunction name="TO_NUMBER">
                                        <quer:customFunction name="SUBSTR">
                                            <quer:customFunction name="TZ_OFFSET">
                                                <quer:customFunction name="TO_CHAR">
                                                    <quer:field ownerQuery="MainQuery" path="Applications,Offers,ActualStartDate"/>
                                                    <quer:string>TZR</quer:string>
                                                </quer:customFunction>
                                            </quer:customFunction>
                                            <quer:integer>1</quer:integer>
                                            <quer:integer>3</quer:integer>
                                        </quer:customFunction>
                                    </quer:customFunction>
                                    <quer:divide>
                                        <quer:customFunction name="TO_NUMBER">cleartext.blogspot.com
                                            <quer:customFunction name="SUBSTR">
                                                <quer:customFunction name="TZ_OFFSET">
                                                    <quer:customFunction name="TO_CHAR">
                                                        <quer:field ownerQuery="MainQuery" path="Applications,Offers,ActualStartDate"/>
                                                        <quer:string>TZR</quer:string>
                                                    </quer:customFunction>
                                                </quer:customFunction>
                                                <quer:integer>5</quer:integer>
                                                <quer:integer>2</quer:integer>
                                            </quer:customFunction>
                                        </quer:customFunction>
                                        <quer:integer>60</quer:integer>cleartext.blogspot.com
                                    </quer:divide>
                                </quer:add>
                                <quer:integer>-1</quer:integer>
                                
                            </quer:multiply>
                        </quer:add>
                        <quer:integer>24</quer:integer>
                    </quer:divide>
                </quer:add>
            </quer:projection>
        </quer:projections>
        <quer:filterings>
            <quer:filtering>
                <quer:equal>
                    <quer:field path="Code"/>cleartext.blogspot.com
                    <quer:field ownerQuery="MainQuery" path="Applications,Requisition,JobInformation,PrimaryLocation,Location.Code"/>
                </quer:equal>
            </quer:filtering>
        </quer:filterings>
    </quer:query>
    
</quer:projection>