Below is the step by step process of registering shell script as a host program or concurrent program in Oracle Applications.
1. Create a shell script ( say sample) and move it to the appropriate BIN directory in Oracle Application.
2. The parameters in the shell scripts should start with $5 , $6 Onwards.
3. Rename the shell script to *.prog ( sample.prog).
4. Change Permissions to 755 for the *.prog file.
5. Create Link to the shell Script ( ln -s $FND_TOP/bin/fndcpesr/sample.prog) to create sample file.
6. Now Register this executable in the application as a host executable (Using System Administrator Responsibility).
While registering the shell script as a concurrent program make sure that the first parameter in the concurrent program is passed as the Fifth parameter in the shell scripts because the first four parameters are allocated to userid, request_id, resp_id, resp_appl_id.
Deleting of duplicate records based on latest Timestamp
delete from emp t1
where hiredate != (select max(t2.hiredate)
from emp t2
where t2.eno = t1.eno)
and eno = 1
where hiredate != (select max(t2.hiredate)
from emp t2
where t2.eno = t1.eno)
and eno = 1
Subscribe to:
Posts (Atom)