Deploy OAF Page in EBS R12

1. First of all copy your compiled project files from from your local machine to $JAVA_TOP directory on ebs server. In my case, local machine (running windows) path is <Base_Path>\Jdev\jdevhome\jdev\myprojects\myclasses and ebs server path is D:\oracle\VIS\apps\apps_st\comn\java\classes. 
2. Now open windows shell on you local machine and move to directory <Base_Path>\Jdev\jdevbin\oaext\bin where import script exist and run  following command import <Base_Path>\Jdev\jdevhome\jdev\myprojects\myclasses\<pkg_name>\oracle\apps\fnd\<proj_name>\webui\youpagePG.xml -rootdir <Base_Path>\Jdev\jdevhome\jdev\myprojects\myclasses -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<ebs server name/ip>)(PORT=1521))(CONNECT_DATA=(SID=VIS)))"

Oracle EBS R12 Useful Queries

Get chart of accounts description

SELECT code_combination_id, chart_of_accounts_id, account_type,
segment1 seg1,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,1,gcc.segment1) seg1_desc,
segment2 seg2,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,2,gcc.segment2) seg2_desc,
segment3 seg3,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,3,gcc.segment3) seg3_desc,
segment4 seg4,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,4,gcc.segment4) seg4_desc,
segment5 seg5,
    gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,5,gcc.segment5) seg5_desc          
  FROM gl_code_combinations gcc
  WHERE code_combination_id=<id>;

Report Builder's rdf Report File Integration With Oracle EBS R12

One you have developed report in Report Builder, save it as .rdf file.
Following are the steps to integrate with ebs

Note. I will be integrating report in order management responsibility for demonstration purposes.

1. First of all we need to know in which application folder is to put the rdf file. Go to System Administrator > Application > Register, Enter application name and you will get Basepath in the form of <Application_folder>_TOP.
2.  Place the rdf file in appropriate application folder at <system drive>\oracle\VIS\apps\apps_st\appl\<application folder>\12.0.0\reports\US. In my case system drive is D:\ and <Application_folder> is folder find in step 1..
3. Define executable. Go to System Administrator > Concurrent > Program > Executable and enter the following information prompted in form , Executable = executable name , short name which will be used when defining concurrent program,   Application = Order Management (ebs will look for rdf file corresponding to order management folder), Execution Method = Oracle Reprots, Execution File Name = file name placed in <application folder> in step 2. Save the form
4. Define Concurrent Programs. Go to System Administrator > Concurrent > Program > Define and enter the following information prompted in the form, Program = Name of current program which will be used when creating report, Short name, Application = Order Management, In executable field area Name = shortname given in step 3, In Output Format = PDF Style = A4. If there are parameters then click on Parameters Button and add parameters. Save the form.
5. Assign to Request group. As we are creating concurrent program for order management responsibility, we need to check which request group is assigned to this responsibility. Once you have find request group, go to System Administrator > Security > Responsibility > Request and enter the Request group and add our concurrent program we created in step 4.
6. Now go to Order Management responsibility and select view > request > submit new request.

SQL Cheat Sheet

SELECT column1, Initcap(column1),to_char(column2,'9.999.99'), column2 * 12 "alias", column3+ 30, add_months(column3,6),to_char(column3, "DD-Month-yyyy HH24:MI:ss"), add_months(to_date('06-january-1988', 'dd-Month-yyyy'),6)  BdayFROM table_name;

Here we fetch
column1, make first letter of column1 capital,
to_char converts to number and formats column2,
column2, multiply it with 12 and give it a name alias, 
column3, adds 30 days
adds_months add 6 months in column3, 
to_char converts date into string and formats it.
to_date converts a string to date and then add_months add 6 months in new column Bday,
from table_name .

Here
column1 is varchar,
column2 is number,
column3 is date,

  

Enable spidev on beaglebone black

In kernel/arch/arm/mach-omap2/board-am335xevm.c

Change .modalias value to spidev in spi_board_info structure for spi0 or api1.

In kernel/arch/arm/configs/am335x_evm_android_defconfig

Comment out CONFIG_SPI_SPIDEV =y

Compile kernel and filesystem

How to create linux kernel patch

‘diff ‘ command is the easiest way to create unix kernel patch.Follow below given steps to create patch

1.Before using the ‘diff ‘ command, run

make clean

and

make mrproper

commands in source directories of both experimental and original kernel to remove executable and object files.if you don’t run this command you will end up with a messy patch.

2.Now use ‘diff’ command as follow

diff  ['options'] [ 'from-file']  [ 'to-file']  > ['patch-file-destination']

for example

diff   -rcNP   /usr/src/linux-3.1.4-org   /usr/src/linux-3.1.4   >   /tmp/patch.diff

a patch file will be generated at /tmp .

enjoy!!