Sunday, March 9, 2008

How To Find Out What Time A Timecard Was Submitted Using Wfstatus.sql

I was recently posed a question: To identify when a timecard was submited?
Easy: Use WFSTATUS.sql
Pass parameters the Internal Type of the Timecard and the Timecard Number (It is also the Expenditure_ID as well as the Item Key)
Reference: Metalink Note: 185820.1

Macroscope

I find Macroscope pretty useful tool in providing complete picture of the documentation - Easy to use, many quick links to navigate both horizontally and vertically within the product, it is a pleasant experience. Based on PMP Methodolgy. At a very high level, Macroscope documents are created based on Owner's view, User's view and Developer's View. To go to Macroscope home page Click here
I saw a pdf which provides more information on this,
Click here to read more about it.

It is interesting to note that Macroscope is considered as a as a Market leader by Gartner as shown in the picture below:


More on this latter.

How to display images in a seperate lines?


Pix 1:




I was trying to get two images displayed on a separate lines - although these are adjacent to each other; however to my exasperation, the images were displayed on the same lines. Have tried various tricks, including
. It is not consistent. For example these photos had to manually separated using text like this. Whereas, I was able to separate the technorati and LinkedIn icons. I will try to look at some examples later.
On a side note, these are the pictures of a bird that appeared outside our home, after I placed a toy bird - looks exactly like the one in the photo.

Pix 2:



Friday, March 7, 2008

Using Unix Find Command

Find:
find . -name "wfstatus.sql" -print
the above command will search all directories starting from current directory for any file containing wfstatus.sql.
Problem: find displays an error message for any directory I do not have permissions.
So how do I suppress these messages?
The following command will do the trick:

find . - name "wfstatus.sql " -print 2> /dev/null
will suppress cannot read dir or Permission denied messages and print only if it finds the file.
Output of this command:
/oracle/prodappl/fnd/11.5.0/sql/wfstatus.sql

explanation:
/dev/null is a virtual file in Unix; data written to is deleted.
I use the cheatsheet from Stanford.edu (to go to stanford clickhere )

In order to do a case-insensitive search, instead of "name", use "iname":
find . -iname "WFSTAtus.sql" -print 2>/dev/null

if you want the search to be restricted only to files, then use "-type f"
find . -type f -iname "WFSTAtus.sql"   -print 2>/dev/null
I have posted a list of commands that I use frequently in Linux. List of Commands I use frequently in Linux