We are using STAT 5.7.4 for our Oracle R12 migrations. Currently we are migrating DB grants manually and want to leverage STAT for this purpose. For all other objects like tables, procedures, packages etc. we are using STAT. But not sure how to migrate grants.
When you define the Custom File Object, Check "For DB" and you will need to create a shell script that get used in "Define Generate Command" tab. The script needs to be in a PATH that is available on all of your EBS Agent hosts. The TARGET_OBJECT_NAME parameter is the SQL script that contains the grant commands.
Grant_Statement.sh -f %%TARGET_OBJECT_NAME%% -p %%TARGET_SYSTEM_PASSWORD%%
Below is how I created custom file object type.
I placed the xxea_grant_stmt.sh file in our custom top and below is the code in it. When migrating I am getting 'OA Generation Error'. What could be the issue?
echo "The shell script execution starts "
exit | sqlplus system/$2 @$1 >/tmp/$1.log
echo "Completed execution"