Decompile all the class files in a directory using JAD

Download JAD from
http://www.varaneckas.com/jad

place the jad file in C:\ drive
Add environment variable c:\ to %path%
go to the directory where class files exists using command prompt
run the below commands as required.

jad -o -d -r . -s java **/*.class (Recursive Decompilation of all files within a directory)
jad -o -d . -s java X.class (to decompile a single class)
jad -o -d . -s java *.class

Jdev Patches for Oracle EBS version

12.0.0 Patch 5856648 10g Jdev with OA Extension

12.0.1 (patch 5907545) Patch 5856648 10g Jdev with OA Extension

12.0.2 (patch 5484000 or 5917344) Patch 6491398 10g Jdev with OA Extension ARU for R12 RUP2 (replaces 619741

12.0.3 (patch 6141000 or 6077669) Patch 6509325 10g Jdev with OA Extension ARU for R12 RUP3

12.0.4 (patch 6435000 or 6272680) Pat

Personalizing Create Opportunity Page

Go to Sales User --> Opportunity --> Create Opportunity
Click on About this page
Copy Page location like :

/oracle/apps/asn/opportunity/webui/OpptyDetPG Go to Functional Administrator Personalization Enter Doc Path and search To do the peronalization at site level, Remove Organization and Responsibility Values

OPTIMIZER_GOAL is obsolete

SQL> alter session set optimizer_goal=rule;
alter session set optimizer_goal=3rule
                                *
ERROR at line 1:
ORA-01986: OPTIMIZER_GOAL is obsolete

However, you can still use the optimizer_mode at the session level:

SQL>  alter session set optimizer_mode=rule;

Session altered.

To Get the request to which the conc program is attached.

select e.* from fnd_concurrent_programs_tl a,
fnd_concurrent_programs b ,
fnd_request_group_units c,
fnd_responsibility d,
fnd_responsibility_tl e
where a.user_CONCURRENT_PROGRAM_NAME =  :P_CONC_PROGRAM_NAME
and a.CONCURRENT_PROGRAM_ID= b.CONCURRENT_PROGRAM_ID
and b.CONCURRENT_PROGRAM_ID = c.REQUEST_UNIT_ID
and c.request_group_id = d.request_group_id
and c.application_id = d.application_id
and d.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
and e.LANGUAGE = 'US'
and a.LANGUAGE = 'US'

get_precission error

while compiling a report if you get get_precision error, then attach the library inv.pll which is available under $AU_TOP/plsql.

Physical Layer & Business Layer joins in OBIEE

In general different tables are joined with foreign key. Drag the FK link from Dimension table to Fact table.
it should be 1 to N join.

In Business layer use complex joins.

Always drag the link from Dimension to Fact