Oracle JDeveloper on Mac OSX

Make sure you have the latest version of Java 1.6 from Apple.

JDeveloper has trouble to locate the Java JDK.
To solve this problem run the following shell script in the terminal.

sudo mkdir /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6

sudo mkdir /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin

sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/bin/java /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin/java

sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/bin/javac /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin/javac
sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/bin/javap /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin/javap

sudo ln -s /System/Library/Java/Support/Deploy.bundle/Contents/Home/bin/javaws /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin/javaws

sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/bin/jar /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin/jar

sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/bin/xjc /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/bin/xjc

sudo mkdir /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/lib

sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Classes/classes.jar /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/lib/tools.jar

sudo mkdir /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/jre

sudo mkdir /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/jre/bin

sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/bin/java /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/jre/bin/java

sudo mkdir /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/jre/lib


sudo ln -s /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Classes/classes.jar /System/Library/Java/Javavirtualmachines/1.6.0.jdk/Contents/Home/jdk6/jre/lib/rt.jar

www.jolie-it.nl

Oracle Fusion Apps(2): View Scheduled Processes

I was searching for functionality similar to concurrent requests in Oracle EBS.
At first I couldn't find it, because I did not have the right roles assigned. I assigned myself quite some roles and then I got the option to view my concurrent requests, or scheduled processes as they are called in Oracle Fusion Apps.

This is the path to follow: Navigator => Tools => Scheduled Processes
(click on image to enlarge)

And this is your list of scheduled processes, with hyperlinks to the logfile and outputfile.
(click on image to enlarge)

www.jolie-it.nl

Oracle HRMS Age Calculation. Is this OK ?

Query HRMS organization hierarchies

Query below returns all primary organization hierarchy versions with validity period (date from - date to) of each hierarchy version.
Adapt to your needs as necessary.

select level, hcy.*

from

(

select vsn.org_structure_version_id

,      vsn.date_from

,      nvl(vsn.date_to, hr_general.end_of_time)  date_to

,      ele.organization_id_parent

,      ele.organization_id_child

from   per_organization_structures  ose

,      per_org_structure_versions   vsn

,      per_org_structure_elements   ele

where  ose.primary_structure_flag    = 'Y'

and    ose.organization_structure_id = vsn.organization_structure_id

and    ele.org_structure_version_id  = vsn.org_structure_version_id

) hcy

connect by prior hcy.organization_id_child = hcy.organization_id_parent

       and prior hcy.org_structure_version_id = hcy.org_structure_version_id

start with hcy.organization_id_parent = :p_organization_id 

Data model PA Budgets

Query concurrent requests

Just for sharing ...

select p.concurrent_program_name

,      p.description

,      r.request_id

,      to_char(r.actual_start_date,'dd-mm-yyyy hh24:mi:ss')      actual_start_date

,      to_char(r.actual_completion_date,'dd-mm-yyyy hh24:mi:ss') actual_completion_date

from   fnd_concurrent_programs_vl p

,      fnd_concurrent_requests r

where  r.concurrent_program_id = p.concurrent_program_id

order by r.actual_start_date desc

Webdesign

Jolie IT levert een nieuwe dienst: webdesign.
Wij zijn gespecialiseerd in ontwerp en bouw van responsive websites. De website past zich automatisch aan aan het apparaat waarmee de website wordt bekeken. 
Nieuwsgierig ? U vindt alle informatie op Blokwebdesign.

Oracle Fusion Apps (1): First look

Just had a first look at Fusion Apps.
I would like to post my first observations.

1. It's pretty overwhelming.
2. No more forms, only HTML screens.
3. As a techie I quickly connected to the database.
4. Instead of user apps connect with user fusion.
5. Tables are all in the fusion-schema.
    This is different from EBS where the tables reside in separate
    productschema's.
6. Luckily I still recognised a lot of tables from EBS
7. Tablespaces are fusion_ts_tx_data and fusion_ts_tx_idx instead of their
    apps-equivalents.