Latest Entries »

This content is password protected. To view it please enter your password below:


Call PeopleSoft XML Publisher Reports Using PeopleCode

Local CUSTOM_APPPKG &objReportData;
Local File &XMLFile;
Local string &XMLFilename;
Local PSXP_RPTDEFNMANAGER:ReportDefn &report;

&XMLFilename = “/tmp/InputFileName.xml”;

&XMLFile = GetFile(&XMLFilename, “W”, %FilePath_Absolute);

&objReportData = CreateObject(“CUSTOM_APPPKG”);

/*This will assign input parameters, for example StartDate and End Date*/
&objReportData.DS_WK_START_DT = &WK_START_DT;
&objReportData.DS_WK_END_DT = &WK_END_DT;

/*This will form the XML File*/


&report = create PSXP_RPTDEFNMANAGER:ReportDefn(“ReportID”);
&report.ProcessReport(“TemplateName”, “ENG”, %Date, “PDF”);


Some times its very irritating to work on Full size Remote Desktop Windows, i tried below solution and it worked in changing the screen size instantly.

To open Remote Desktop Connection, click Start, point to Programs or All Programs, point to Accessories, point to Communications, and then click Remote Desktop Connection.

When you click Connect, the information you have entered in Options becomes the default setting for all Remote Desktop connections and is saved in a file called Default.rdp

  • To change the screen size for connections
  • In the Remote Desktop Connection window, click Options.
  • On the Display tab, under Remote desktop size, drag the slider to choose the size of your remote desktop. Drag the slider all the way to the right for full screen.
  • Click Connect.


Sankalpam for “Sandhya Vandanam” in USA

The Sankalpa which every Hindu makes while initiating any religious  practice, invariably refers to the exact locale where the rite is performed  with reference to the Hindu Cosmology.
( e.g.) In India, the locale part of the Sankalpa would be as follows :
Jambudveepe — In the isle of the rose apple
Bharata Varshe — In the region called Bharata Varsha
Bharatah Khande — In the continent of Bharata etc.

Those doing the rites in the U.S.A, adopt the same as follows:-

Krounchadveepe – Ramanaka Varshe — In the region called Ramanaka Varsha
Aindra Khande– In the continent called Aindra
Rocky –mickelny Parvatayor Madhye : Between the mountains of Rockey and
Mickelny Misissipi —  Missouri Ityadhi Aneka Shodasa Jeeva Nadeenam sameepa
stite –the place that is surrounded by such perenniel rivers like
Mississipi , Missouri and 16 other rivers

It may be noticed that any rituals which a Hindu performs on auspicious as  well as inauspicious occasions always start with a fixation of the precise  time, the star, the day, the Thithi, the fortnight, the month, the season,  the half year , and the year on the micro side as also the quarter of the yuga, the name of the yuga , the name of the cycle, the Manvantara, and
the Kalpa on the Macro side. In fact, orthodox Hindus do this reckoning daily in their ‘Nitya karma Anushtana’ the daily routine Puja ( honouring)  of their Ishtadevata. In this way the formula for describing the exact time  in the eternal cycle has been passed on from generation to generation. This  is what we call the “Sankalpa’ before commencing any rituals. This is also true of fixation of the exact location where the ritual is performed.
Now, let us have a look at this Sankalpa: It goes on like this:
Dviteeya parardhe In the second half of Brahma’s life
Svetavaraha Kalpe In the Kalpa of Sveta Varaha
Vaivaswatha Manvantare In the reign of Vaivaswatha Manu
Ashta Vimsati me within the 28th cycle
Kali Yuge In the Kali yuga
Prathame Pade In the first quarter thereof

Then, the Sankalpa refers to the geographical position of the place where the ritual is performed. Resuming the reference to time, the Sankalpa proceeds further as follows:-
Asmin Varthamane Vyavaharike :In the current period now proceeding
Prabavadi Shashti Samvatsaranam Madye :Among the cycle of 60 years starting
from Prabhava
……… Nama Samvatsare: in the year named……….
Dakshinayane or Uttarayane:in the Soutern/ Northern movement of the Sun
………..Ritou: in the season named…….
Mase: in the month of………..
…………Pakshe: in the bright / dark fortnight thereof
…………Punya Thithou:in this holy Thithi numbered……..
………….Vasara uktayam: on the day called………
…………..Nakshatra uktayam: when the star called………holds sway
Then, the Sankalpa proceeds to say that the ritual called…………  performed for the pleasure of the Lord.

For non-immigrants, getting Driving license is very important. It can be carried as ID proof instead of passport.

Since i came to India, this blog will mostly address Indian Non Immigrants:

First part:

To get a Driving license in US, you should carry your 6-Point Verification documents.

I carried my H1B visa, I 94 document which gave me 4 points, SSN for 1 Points and ATM Debit card with Photo or bank statement 1 point.

Once we present our documents to DMV helpdesk counter, they will give us the token after verifying the validity and authenticity.

After they call our token number we need to pay around $10 as application fees at the counter and customer service personnel will take photo for further submission.

Second part:

We can take online exam at the DMV center on same day or some other day. There will be 50 questions in total and 40 is the passing mark.One of the trick is to skip questions for which you dont know the answer. Normally candidates who go through New Jersey Motor Driving Manual will have enough information at hand to clear the written test.

Third Part:

Once we clear the Test, we can schedule for Road Test with a Gap of 20 days or 3 months, that depends on our Driving experience level and the proof which we submit to verify the same. I have produced my indian driver’s license and they issues me the License without Road Test. Atlease my 10 yrs of driving helped me in getting a license without Road Test.

Fourth Part:

After you get the license, it is advised to to take Driving classes from some local driving schools. I took 2 classes of 2 hours each. 1 on city limits and 1 on highways.

Now i feel pretty comfortable in driving the vehicles.


PeopleSoft Tip: About state record

Zero , One or many state records may be associated with a program.

The state record:

Is used to hold runtime variables for the Application Engine run.
Is Maintained by the developer and is invisible to the user.
Is used to hold all SQL Select results.
Can be a derived/work record or a SQL table.

So, for the statrecord. State records are like working storage for your Application Engine program, and they have the following uses that being of program variables. They initialize values passed between programs, steps and actions. You see the results of SQL Select values that are used to insert and update, used for counters and calculations, programmable switches or flags are used in application engine restarts. And state records are associate with an Application Engine program in its properties on the state records tab.

Ten things to avoid being a leader

Do you want to become a better leader? Here are the few  mistakes you most want to notice, prevent, and avoid.

Ten things to avoid being a leader:

  • Make decisions and then ask people for their input as if their feedback mattered. You can fool some of the people. but your best employees soon get the nature of your game and drop out. Along the same lines, create hierarchical permission steps and other roadblocks that teach people quickly that their ideas are subject to veto and wonder why no one has any suggestions for improvement. Enabling people to make decisions about their work is the heart of employee empowerment and the soul of employee engagement. Don’t throttle them.


  • Not treating all employees equally. You don’t necessarily have to treat every employee the same, but they must feel as if they receive equal treatment. The perception that you have pet employees or that you play favorites is dangerous for organization. This goes hand-in-hand with why befriending reporting employees is a bad idea. Employees who are not in your inner circle will always believe that you favor the employees who are – whether you do or not. This perception destroys teamwork and undermines productivity and success.


  • Throw employees under the bus. Rather than taking responsibility for what goes wrong in the areas that you manage, blame particular employees when asked or confronted by executive leadership. When you know the responsibility is ultimately yours if you are the boss, why not act with dignity and protect your employees? When you blame employees, you look like an idiot and your employees will disrespect and hate you. Trust me. They will find out and they will never trust you again. They’ll always be waiting for the other shoe to fall. Worst? They’ll tell all of their employee friends about what you did. Your other staff members will then distrust you, too. Your senior leaders will not respect you either. They will question whether you are capable of doing the job and leading the team. When you throw your employees under the bus, you jeopardize your career – not theirs. And, it won’t remove one iota of the blame from your shoulders.


  • Trying to be friends with employees who report to you. You can develop warm and supportive relationships with employees who report to you. But, you will have difficulty separating the reporting relationship in a friendship. Friends gossip, go out together, and complain about work and the boss. There is no room for their leader in these kinds of relationships.


  • Fail to communicate effectively and withhold important information. The best communication is transparent communication. Sure, some information is company confidential. You may have been asked to keep certain information under wraps for awhile, but aside from these rare occasions, share what you know. Being a member of the in-crowd is a goal for most employees and the in-crowd has information – all of the information needed to make good decisions. Ask for feedback, too. Ask people for their opinions, ideas, and continuous improvement suggestions, and if you fail to implement their suggestions, let them know why, or empower them to implement their ideas themselves.


  • Fail to get to know employees as people: Developing a relationship with reporting employees is a key factor in managing. You don’t want to be your employees’ divorce counselor or therapist, but you do want to know what’s happening in their lives. When you know where the employee is going on vacation or that his kids play soccer, you are taking a healthy interest in your employees’ lives. Knowing that the dog died, expressing sympathy, or that her daughter won a coveted award at school make you an interested, involved boss. Knowing employees will make you a better leader, a leader who is more responsive to employee needs, moods, and life cycle events.


  • Fail to provide clear direction: Leaders fail to create standards and give people clear expectations so they know what they are supposed to do, and wonder why they fail. If you make every task a priority, people will soon believe that there are no priorities. More importantly, they will never feel as if they have accomplished a complete task or goal. Within your clear expectations, if you are either too rigid or too flexible, your reporting employees will feel rudderless. You need to achieve an appropriate balance that allows you to lead employees and provide direction without dictating and destroying employee empowerment and employee engagement.


  • Fail to trust: When leaders don’t trust people to do their jobs, this lack of trust plays out in a number of injurious ways. Micromanaging is one example. Constant checking up is another. Treat people as if they are untrustworthy – watch them, track them, admonish them for every slight failing – because a few people are untrustworthy. Are you familiar with the old tenet that people live up to your expectations?


  • Fail to listen to and help employees feel that their opinions are valued. Active listening is a critical management skill. You can train leaders in listening skills but if the leader believes that listening is a way to demonstrate that he or she values people, training is usually unnecessary. Listening is providing recognition and demonstrating your values in action. When employees feel heard out and listened to, they feel important and respected. You will have much more information when you daily open the flood gates.


  • Fail to react to problems and issues that will soon fester if ignored. Leaders have a habit of hoping that an uncomfortable issue, employee conflict or disagreement will just go away on its own if they don’t provoke it or try to resolve it. Trust me. It won’t. Issues, especially among people, just get worse unless something in the mix changes. Proactive intervention from the leader to coach and mentor, or to make sure employees have the skills necessary to resolve the issue, is imperative. Drama and hysteria do interrupt productivity, motivation, and employee engagement.


NOTE: Tracing activated for 1 Application Engine or all Application Engines

On the PIA, you can activate tracing for a particular Application Engine.

When activating tracing on the Client or on the Process Scheduler, any Application Engine run will generate a trace file.

Suggested Process Scheduler Trace Setting:



A.1.Sign in the PIA.

A.2.Navigate to the ‘Processes’ component and select the Application Engine process that you would like to get a trace on.

A.3.Go to the ‘Override Options’ tab. Set the ‘Parameter List’ option to ‘Append’ and add the tracing flags as explained below.

You can turn on tracing for the Application Engine itself, for SQL statements or the PeopleCode run by the Application Engine

Application Engine tracing:
Add the sum of all the options you want to use at the end of the parameter list and precede the number by ‘–TRACE + a space’. For example:

-TRACE 391

Here is the list of options and associated numbers for each option:

1 Initiates the Application Engine Step trace
2 Initiates the Application Engine SQL trace
4 Trace dedicated Temp Table Allocation to AET file
128 Initiates the Statement Timings trace to file, which is similar to the COBOL timings trace to file
256 Initiates the PeopleCode Detail to the file for the Timings trace
1024 Initiates the Statement Timings trace, but, instead of writing to the trace file, this trace stores the results in the following tables: PS_BAT_TIMINGS_LOG and PS_BAT_TIMINGS_DTL
2048 Adding this value requests a database optimizer trace file
4096 Requests a database optimizer to be inserted in the Explain Plan Table of the current database
8192 This value sets a trace for Integration Broker transform programs

To turn traces on, sum all the options you want to use and enter the results at the end of the parameter list and precede the number by ‘–TRACE + a space’ as shown above. For example, you should use ‘391’ (1+2+4+128+256) to trace what is shown in bold above.

SQL tracing:
Add the sum of all the options you want to use at the end of the parameter list and precede the number by ‘–TOOLSTRACESQL + a space’. For example:


Here is the list of options and associated numbers for each option:

1 Trace SQL statements
2 Trace SQL statement variables
4 Trace SQL connect, disconnect, commit and rollback
8 Show fetched rows (indicates that it occurred, not data)
16 Show all other API calls except ssb
32 Set Select Buffers (identifies the attributes of columns to be selected).
64 Show database API specific calls
128 Show COBOL statement timings
256 Show Sybase bind information
512 Show Sybase fetch information
4096 Show manager information
8192 Show Mapcore information

To turn traces on, sum all the options you want to use and enter the results at the end of the parameter list and precede the number by ‘–TOOLSTRACESQL + a space’ as shown above. For example, you should use ‘135’ (1+2+4+128) to trace what is shown in bold above.

PeopleCode tracing:
Add the sum of all the options you want to use at the end of the parameter list and precede the number by ‘–TOOLSTRACEPC + a space’. For example:




Here is the list of options and associated numbers for each option:

1 Trace instructions
2 List the program
4 Show assignments to variables
8 Show fetched values
16 Show stack
64 Trace start of programs
128 Trace external function calls
256 Trace internal function calls
512 Show parameter values
1024 Show function return values
2048 Trace each statement in program

To turn traces on, sum all the options you want to use and enter the results at the end of the parameter list and precede the number by ‘–TOOLSTRACEPC + a space’ as shown above. For example, you should use ‘2012’ (4+8+16+64+128+256+512+1024) to trace what is shown in bold above.

A.4.Go ahead and run the Application Engine process that you would like to get a trace on.

A.5.Get the trace file.

In the Process Requests page, click on the Details hyperlink for your Process Instance.

In the Process Detail page, click on the View Log/Trace hyperlink.

A.6.DO NOT FORGET TO TURN TRACING OFF by setting the ‘Parameter List’ option to ‘None’ in the ‘Processes’ component – ‘Override Options’ tab in step A.3.

Topics to Avoid in Workplace Conversations

Ten Topics to Avoid in Workplace Conversations – Some Things Are Better Left Unsaid – Tell Me Less 

  1. Detailed health problems
  2. Details of sex life
  3. Problems with spouse/partner
  4. Personal Finances [either positive or negative]
  5. Personal religious views
  6. Hot Political topics that evoke passion
  7. Personal lives of other coworkers
  8. Gossip about the boss
  9. Jokes that disparage other ethnic,racial, or religious groups
  10. Lavish purchases.

The bottom line:

  • In an age in which exhaustive information on just about any topic is just a few key strokes away, it’s sometimes easy to forget how much information is too much.
  • Offices without walls, flatter orgs and technology can make it challenge to maintain barriers at work.
  • Self disclosure has its place and can strengthen relationships, but it’s important to balance openness with privacy.
  • Use good judgment about how much to share with others and how much to tolerate hearing when you’re on the receiving end.
  • What you don’t say can tell a lot about you.

Railway Enquiries – By SMS

Travelling in trains was never easy like this.  Now onwards, Get your all travel details instantly simply by sending an SMS to 5664433.

Railway Enquiries as PNR Status, Seats Availability, List of Trains between two stations, Fare Enquiry and many more, are now available through SMS on all mobile operators (as mentioned below).

 You can get the required information by sending the SMS from your mobile as in below given SMS format :


S. No.

User Service

Message Text

Message Send To

Response Message


PNR status

PNR  <10 digits PNRNo>

Example: PNR 2247461632


Train No.:12444 Train Name: BUBNESWR RJDHNI Date: 10-1-2014 Class: 3A Reservation Status: Passenger 1:W/L 10 Current Status: RAC


Seats/Ticket Availability


TAV <Train No.> <Source> <Destination> <DDMM> <Class>

Example: TAV 12902 ADI BCT 0504 SL



12902 GUJARAT MAIL AHMEDABAD JN-MUMBAI CENTRAL SL 05- 4-2013 : WL 210/WL 84 06- 4-2013 : WL 232/WL 123



Trains Between Two Stations


TBT <Source> <Destination>






Fare Enquiry

FARE <Train No.> <DOJ as DDMMYY> <Origin Station code> <Destination Station code> <Class> <Quota>


Example: Fare 12452 120114 NDLS CNB 3A G



DOJ: 12/01/2014 Fare: 3A – Rs. 655/-

Mobile Operators supported: Airtel, Vodafone, Aircel, MTS, MTNL, Reliance, Loop and others.

Very soon we will be connected with Tata, Idea and BSNL operators.

Note: SMS charges as Rs. 3/-