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.

Automatically Maintain OTL Timekeeper Groups

Jolie IT has developed a custom solution for automatically maintaining your Timekeeper Groups in Oracle EBS R12.

This is a generic solution that has been proven to work very well and prevents customers from the tedious job of manually maintaining their Timekeeper Groups in OTL.

How does it work ?

Standard EBS functionality

1. In Oracle HRMS create a Dynamic Assignment Set by the same name as the Timekeeper Group you wish to maintain automatically.

2. Add all dynamic criteria for the Assignment Set on which you want to base your Timekeeper Group. You can use all dynamic criteria that Oracle HRMS provides. This is quite a long list, see list of Assignment Set Criteria. 

The most common criteria used, besides Payroll (mandatory), are Organization and Job. You can specify as many criteria as you like however, as long as they are provided by Oracle HRMS.

Custom extension

3. Run custom concurrent program "Refresh Timekeeper Groups". This concurrent program can be scheduled as frequently as you wish. It refreshes all your Timekeeper Groups for which you defined a Dynamic Assignment Set with the same name. All updates to your Timekeeper Groups are handled by using Oracle API's of course, so no hassle with Oracle support, patches and upgrades.

Very simple, very straightforward !

You can order this solution or get more info by sending an email to info@jolie-it.nl

When ordered you will get:

- software (wrapped)

- installation manual including usage instructions

Price: EUR 2999,- ex. VAT, no consultancy included

www.jolie-it.nl