ORACLE

ORACLE
Let us share our knowledge to the world of oracle apps. I am trying my best to do so and I request every one to contribute their part. If you have any thing useful related to oracle apps, do send me I will post in my blog on behalf of you. If you like my blog tell the world about it, else tell me i will improve. You can suggest me, what exactly you want on oracle apps. Mail your queries.

Wednesday, December 28, 2011

Standard API to Register Executable Program

This blog is about to regeister Executables through Standard API..
1) Create a excel with following details
executable,
Application,
Executable Short Name,
Description,
execution_method,
execution_file_name,
'NULL' subroutine_name,
'NULL' icon_name,
language_code,
'NULL' execution_file_path
2) load that excel values in a staging tabel and do validation if requried
3)Register your Executables with below said Standard API..
BEGIN
fnd_program.executable
('XXM_XYZ_EMPLOYEE', -- executable
'ABC', -- application
'ABC_XYZ_EMPLOYEE', -- short_name
'Executable for Migrating Employee', -- description
'PL/SQL Stored Procedure', -- execution_method
'abc_xyz_employee_pkg.create_employee', -- execution_file_name
'', -- subroutine_name
'', -- icon_name
'US', -- language_code
'',--execution_file_path
);
END;
/

No comments:

Post a Comment