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;
/
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.
No comments:
Post a Comment