Category: Uncategorized


DateTime Conversion in Oracle.

To convert datetime to a formatted date time character in Oracle, we use TO_CHAR(Column,Format) function.

TO_CHAR (datetime) converts a datetime or interval value of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH LOCAL TIME ZONE datatype to a value of VARCHAR2 datatype in the format specified by the date format fmt. If you omit fmt, then date is converted to a VARCHAR2 value as follows:

  • DATE values are converted to values in the default date format.
  • TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE values are converted to values in the default timestamp format.
  • TIMESTAMP WITH TIME ZONE values are converted to values in the default timestamp with time zone format.

SELECT  TO_CHAR(A.AUDIT_STAMP, ‘DD-MON-YYYY HH24:MI:SS’) FROM PSAUDIT A

Advertisements

PSAUDIT – SQL Issue

Problem Statement: While doing Field Level Audit in People Soft, we might come across below issue

“INSERT INTO PSAUDIT RESULTS IN SQL ERROR FOR VALUES LONGER THAN 65
CHARACTERS”

This issue does not exists in version 8.53 and above.

Solution:

Do impact analysis to find if PSAUDIT is been used across any modules.

Use App Designer to check the database for the use of PSAUDIT anywhere in metadata objects (Find Definition References) and SQL or peoplecode (Find In).
If PSAUDIT is not in the results, i.e. not being used at all, then the table can be dropped from the database (You will see a warning when running DDDAUDIT in the future on this though).

Vice versa, if you want to keep PSAUDIT and drop PSAUDITEXT, do the same above but search for PSAUDITEXT.

Starting in 8.52, PeopleTools internal code checks whether the tables exist before attempting to write to them, so there are no issues if one of them is
deleted.

Either way data exists in both records.
For reference, here is the actual data field definition difference between the two fields:

PSAUDITEXT
PTOLDVALUE VARCHAR2(254) NOT NULL Old Value
PTNEWVALUE VARCHAR2(254) NOT NULL New Value
PSAUDIT
OLDVALUE VARCHAR2(65) NOT NULL Old Value
NEWVALUE VARCHAR2(65) NOT NULL New Value

Working with Background Colors in PeopleSoft

If you are on Grid and want to change Background color or Cell or Row, you can use below code.

&ROW = &RS.GetRow(&A);

&ROW.Style = “PSGRIDCOLUMNHDR”;
&RS(&A).RECORDNAME.FIELDNAME.Style = “PSGRIDCOLUMNHDR”;

For identifying the Style Value, you might want to try below logic.

When adding fields to pages, we select a “style” for each new field. The style maps to a CSS class that is contained within a PeopleSoft stylesheet object. In most cases, we simply take the default value for the style and that gives us a consistent appearance on our pages. But sometimes we want to modify the visual appearance of a field.

To select a style, simply choose it from the dropdown list in the field properties. (There is a style for the field and one for the label.) Simple enough. But what do all the choices mean? Do you know what “PAFRAMELEVEL3WBO” is? Also, the style as it appears in App Designer is often just an approximation of what will appear in the browser. Do we need to use a trial-and-error approach to see what each style is?

Instead of that method, try displaying samples of all of the styles in the browser. 90% of them are duplicates or very specialized styles that are rarely used. But among the rest you might find good choices for your page design.

It’s pretty easy to do. Write some SQL that generates HTML:

   SELECT
   '
' || STYLECLASSNAME || '
' FROM PSSTYLECLASS WHERE STYLESHEETNAME = 'PTSTYLEDEF'

Insert an HTML Area on your page. Run the SQL and copy the results into the HTML Area (as a “constant” value instead of a field value). There is a limit to how much text you can put there, so you may need to restrict your selection in the WHERE clause of the SQL (in this example, I just picked one stylesheet). Save the page and navigate to it, and you should see something like this:

Pick the appropriate style and apply it to your field, then just delete the HTML Area and you should be all set. One thing to be aware of, though, is that most of the styles with backgrounds do not fill in more than the area taken by the text. You can see how this works by testing it. For the styles that do fill in larger areas, do a View Source in the browser and look for “width:100%”.

Using “If Loop” in XML Publisher reporting

Usually conditional loops are used in any programming language.

Below is an example to control a message on RTF template based XML Publisher report using IF Loop.

Author is trying to display a message if there are no rows to be displayed on report.

Example:

<?xdoxslt:ifelse(number(@rownumber)!=0,’’,’There are no data’)?>

Enjoy for the day!

People Code to Update or Insert values to a record

People Code to Update or Insert values to a record

&Rec = CreateRecord(Record.ABC_JOB);

&Rec.EMPLID.Value = “1”; /*Assign values to all Key fields*/
&result = &Rec.SelectByKey();
&Rec.STATUS.Value = “Active”;
If &result Then
&Rec.update();
Else
&Rec.Insert();
End-if;

PeopleCode With Yes No Message Box On Page

There might be a requirement where we need to perform some action based on return value of Message Box.

For example: Save the component after user confirms by clicking Yes.

We can use below PeopleCode in Field Change Event.
&Answer = MessageBox(4, “”, 0, 0, “Please confirm if you want to Save”);
If &Answer = 6 Then
DoSave();
Else
End-If;

&Answer = 6 for response of “Yes”

&Answer = 7 for response of “No”

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

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…………..is  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.