Happy new year

to you all, may 2010 bring you all you wish for

Retrieve the lookup codes information within oracle ebs

If you work with oracle ebs you all know how ‘userfriendly’ the lookup codes in EBS are working. Well i have made a query where i retrieve all settings of all lookup codes or just filter them down to one category. Perhaps this may be usefull for others. i know it is for me
read more..

How to setup, register, use a shell script in a concurrent program

Find in this article a  step by step process of registering shell script as a host program or concurrent program in Oracle Applications.

Create a shell script ( for example  myscript) and move it to the appropriate BIN directory
in Oracle Application.
The parameters in the shell scripts should start with $5 , $6 Onwards.
Rename the shell script to
read more..

Retrieve customers with more than 1 bankaccount with the same startdate.

Today they asked me to get all customers who have more than 1 bankaccount with the same startdate. Below the query.
Â
Â
CREATE TABLE xxvrm_duplicatebanks AS
SELECT /*rule */ hca.account_name,hca.account_number,COUNT (*) aantal, abb.bank_account_name, abb.bank_account_num,aba.start_date, aba.end_date
    FROM apps.ap_bank_account_uses_all aba, apps.ap_bank_accounts_all abb, apps.hz_cust_accounts hca
   WHERE 1 = 1
   AND aba.external_bank_account_id = abb.bank_account_id
   AND aba.customer_id = hca.cust_account_id
  HAVING COUNT (*) >
read more..

Create your perfect virtualised PHP development environment

Personally i am more a .NET/ASP.NET kind of guy, but more and more clients (Public sector) require open source skills and software. So i am studying this. it is not that complicated, just another language for the samen development process. First of all i wanted to have a developement  environment which i can play, test
read more..

SQL or PL Sql behaviour

hi, for a few days i am (as non pl/sql programmer) strugling with a performance issue. I have to execute a datafix. So i wrote the update statement which works fine. It processes about 130.000 records in just about 2 seconds. Now our DBA guys want to have the update statements in procedure format with
read more..