Email Account Receivables Invoices

Until now Oracle has not come up with a solution in EBS 12.1.3 to email AR Invoices. This, despite of the fact that an ever growing list of customers has asked for this functionality.

Just check bug 6635894 on oracle support.

The goods news is that a smart KIWI (New Zealander) has developed a plugin based on PL/SQL and APEX.

At the moment this plugin has been developed for AR Invoices that have been setup with the Bill Presentment Architecture (BPA) functionality.

The plugin can easily be modified for use with other concurrent programs producing AR Invoices.

Check the Powerpoint presentation for a detailed presentation of the plugin.

For more info you can contact me at info@jolie-it.nl

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