Skip to content

Author Archives Dimitri Gielis

E-Business Suite and APEX integration using APIs (1)

I didn’t expect to many technical issues using E-Business Suite (EBS) APIs in APEX as it’s basically a call to PL/SQL packages.Next to that the EBS APIs seems to be well documented. I first didn’t realise, but for a long time I was using the Oracle Int…

Posted 05 February 2012 § Uncategorized ‡ Comments Off °

E-Business Suite and APEX integration using Views

Integrating APEX and EBS by using views is one of the easiest solutions (at first sight!).This is the first scenario, where I have an APEX application and I want to integrate with data sitting in EBS.Pre-requisites:APEX is installed in the same databas…

Posted 03 February 2012 § Uncategorized ‡ Comments Off °

E-Business Suite and APEX integration (overview)

For me there are two main use cases to integrate Oracle E-Business Suite (EBS) with Oracle Application Express (APEX):In my APEX application I want to include/integrate data that exist in EBSe.g. I want to include my employees that are in EBS HRThe EBS…

Posted 02 February 2012 § Uncategorized ‡ Comments Off °

E-Business Suite and APEX installation

Before doing the integration of Oracle Application Express (APEX) with E-Business Suite (EBs) you need to have both environments installed. The Oracle white paper talks about the installation of APEX, but not about installing E-Business Suite.The white…

Posted 25 January 2012 § Uncategorized ‡ Comments Off °

APEX and E-Business Suite integration

For a couple of years now companies like for example Popay integrate APEX with E-Business Suite.The learning curve of APEX is not that high, so people with a (technical) E-Business Suite background should be up and running in no time.In April…

Posted 18 January 2012 § Uncategorized ‡ Comments Off °

SQL: Start day and End day of week

I just got an interesting question: how do you know for a date, in which week (Monday – Sunday) it falls.I created a little test script to get 31 days of data:(date_c is the same as date_d, but in a more readable output. c stands for char, d for date)s…

Posted 08 September 2010 § Uncategorized ‡ Comments Off °