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;
/
It is an effort to make my blog a Knowledge repository and Solution Center which provides unique technical and functional solutions for EBS professionals.
ORACLE
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment