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.