Blogs on Oracle DBA / Temenos T24 - Deepak Kumar

 In T24 R8+  you can use the application called EB.DYNAMIC.ATTRIBUTES in that create a record called SYSTEM and you can attach a routine in VERSION.RTN which will be triggered for all VERSION's before displaying so you can just modify the R.VERSION and send it back with the drill down enquiry you want to attach then it will be displayed to the user in Browser

This program will sort numbers based on their values. Usually SORT will sort not based on the value of the numbers PROGRAM TEST.SORT $INCLUDE T24.BP I_COMMON $INCLUDE T24.BP I_EQUATE Y.ARR1 = 1:FM:4:FM:2:FM:8:FM:6:FM:3:FM:13 Y.ARR2 = '1':FM:'4':FM:'2':FM:'8':FM:'6':FM:'3':FM:'13' Y.CNT = DCOUNT(Y.ARR2, FM) FOR I = 1 TO Y.CNT Y.SORT.ITEM = MAXIMUM(Y.ARR2) Y.SORT.ARR := FM:Y.SORT.ITEM LOCATE Y.SORT.ITEM IN Y.ARR2 SETTING Y.ITEM.POS THEN DEL Y.ARR2<Y.ITEM.POS> END NEXT I DEL Y.SORT.ARR<1> CRT Y.SORT.ARR STOP

You can locate from the back of the string using option "DR" in the locate command. Example:  PROGRAM TEST.LOCATE$INCLUDE T24.BP I_COMMON $INCLUDE T24.BP I_EQUATE Y.STRING = 30:VM:30:VM:30:VM:30:VM:30:VM:30 LOCATE 30 IN Y.STRING<1,1> BY "DR" SETTING POS THEN CRT POS END STOP The result will be 6. Usually the answer will be 1 using LOCATE command

Every loan contract in T24 can be covered using a Collateral. The Collateral details are stored in the file COLLATERAL. The Collateral is independent of the Loan. The file which connects a Collateral to a Loan is COLLATERAL.RIGHT. There are two ways a Loan can be attached to the COLLATERAL.RIGHT. Way 1: Creating a new record in the file COLLATERAL.RIGHT and entering the Loan contract ID in the field LIMIT.REFERENCE of the COLLATERAL.RIGHT. This is the process of attaching a Collateral to a loan without limit. Way 2: Creating a new record in the file COLLATERAL.RIGHT and enter the Limit reference of the Loan contract in the field LIMIT.REFERENCE of the file COLLATERAL.RIGHT. In this case the system will identify the LIMIT. When we create a loan contract the system will by default create a record in LIMIT application for the customer as per the limit reference of the Loan contract. This will happen if the parent limit line is created for the customer. In cas...