Wednesday, May 13, 2015

Oracle EBS Notes

Responsibilities
     - Menus
            - Function calls

Function calls are tied to Menus and Menus are tied to Responsibilities

Functions have HTML calls where we define the  ADF pages to navigate from Orcale EBS R12

Example HTML call looks like - GWY.jsp?targetPage=/faces/jspx/test_page.jspx


How to get Responsibility Name give Resp ID?

Query table fnd_responsibility_vl

Friday, May 8, 2015

Create a tag from trunk (SVN; JDeveloper)


  1. Right Click on the Tag Folder in subversion to create a Remove Folder for the Tag
  2. Right Click on the Application (for which you want to create a tag for) and select Branch/Tag
  3. Finally give the folder name as destination and the App name

Tuesday, April 7, 2015

UNIX Commands

 

  • to check and see if anything is already running do the following :  ps -ef | grep weblogic

  • to start weblogic  nohup ./startWebLogic.sh &

  • to read the file : tail -f nohup.out

  • Ctrl+C – halts the current command
  • id - shows all users, groups with id in brackets
  • date - shows date on the server
  • lastb | grep -i *some-text* - shows list of similar patterns. 
  • show last logged in users lastb
last, lastb - shows listing of last logged in users


How to start SVN Repo
  • Step 1: cd /home/WL12c/src/csvn/bin 
  • Step 2: ./csvn start

How to copy some x number of lines in nohup.out to a text file
  •  tail -2000 nohup.out | less > vj.txt & 

Sunday, March 15, 2015

Read HTTP Header requests

Install software / extensions in the browser 

Try LiveHTTPHeader or fiddler software 

Thursday, February 19, 2015

Cool Websites which I came Across

Way to go:

https://agilebench.com/ -  (Agile Development Tool)

http://communifire.com/ - office social network (For collaboration and interaction in the team) 

Friday, January 30, 2015

What is putty, Xming and MobaXterm


  • Putty is a terminal for connecting to a UNIX box
  • Xming is used to get GUI from putty when executing jar files etc
  • Latest tool  MobaXterm is a combination of putty and Xming


Thursday, January 22, 2015

SQL Joins








Reference:
http://www.w3schools.com/sql/sql_join_left.asp
http://stackoverflow.com/questions/6559261/left-outer-join-using-sign-in-oracle-11g