Development and Test Environment: Post Regeneration Set-up Scripts

In a development and test environment, I hate logging in to Oracle Applications and having to run concurrent programs (and check concurrent programs) associated with security and the key flexfields after I have regenerated my Noetix Views.   Specifically, I do not like spending a lot of time after a regeneration to perform set-ups to make the environment end user friendly.  

Consequently, I just created some grant scripts (around Noetix packages to APPS) and initial KFF table uploads sql scripts so that end users can test their reports without errors associated with security or KFF tables being empty. 

Here is my approach:

1.        Run a grant script because some of the Noetix packages which are executed by the Noetix concurrent program have not been properly granted (grant execute) to the APPS database user.  If this grant is not performed in the 6.01 Noetix Views (with Oracle Apps 12.1.3), I have noticed the security and KFF concurrent programs failing.

Here is my script which I spool (and spool results) using my NOETIX_SYS database account:

/*

select

'grant execute on ' || object_name ||' to apps; '

from

all_objects

where

owner = 'NOETIX_SYS'

and object_type = 'PACKAGE'

order by 1;

*/

grant execute on NOETIX_APPS_SECURITY_PKG to apps;

grant execute on NOETIX_AP_ERRORS_PKG to apps;

grant execute on NOETIX_AP_INVOICES_PKG to apps;

grant execute on NOETIX_AR_ERRORS_PKG to apps;

grant execute on NOETIX_AR_PKG to apps;

grant execute on NOETIX_BOM_PKG to apps;

grant execute on NOETIX_CSD_PKG to apps;

grant execute on NOETIX_DBMS_WRAPPER_PKG to apps;

grant execute on NOETIX_DELIVERY_PKG to apps;

grant execute on NOETIX_ENV_PKG to apps;

grant execute on NOETIX_GL_SECURITY_PKG to apps;

grant execute on NOETIX_ORDER_LINE_STATUS_PKG to apps;

grant execute on NOETIX_ORDER_STATUS_PKG to apps;

grant execute on NOETIX_PA_PKG to apps;

grant execute on NOETIX_PREFIX_PKG to apps;

grant execute on NOETIX_QA_PKG to apps;

grant execute on NOETIX_QA_RSLT_POP_PKG to apps;

grant execute on NOETIX_SERVICE_PKG to apps;

grant execute on NOETIX_USER_PKG to apps;

grant execute on NOETIX_UTILITY_PKG to apps;

grant execute on NOETIX_WF_PKG to apps;

grant execute on NOETIX_XOP_PKG to apps;

grant execute on NOETIX_XXNAO_PKG to apps;

grant execute on N_DB_OBJECTS_PKG to apps;

grant execute on N_EUL_GEN_EUL50_2_PKG to apps;

grant execute on N_EUL_GEN_EUL50_PKG to apps;

grant execute on N_EUL_GEN_HELPER_PKG to apps;

grant execute on N_EUL_GEN_ITEM_CLASS_PKG to apps;

grant execute on N_GENERATORS_PKG to apps;

grant execute on N_GEN_COLUMN_SOURCE_PKG to apps;

grant execute on N_GEN_PKG_VALIDATION to apps;

grant execute on N_GSEG_INTEGRATION_PKG to apps;

grant execute on N_GSEG_METADATA_PKG to apps;

grant execute on N_GSEG_PKG to apps;

grant execute on N_GSEG_UTILITY_PKG to apps;

grant execute on N_KFF_ACCALIAS_PKG to apps;

grant execute on N_KFF_CTLG_GRP_PKG to apps;

grant execute on N_KFF_GL_ACCT_PKG to apps;

grant execute on N_KFF_ITEM_LOC_PKG to apps;

grant execute on N_KFF_MTL_CAT_PKG to apps;

grant execute on N_KFF_SYS_ITEM_PKG to apps;

grant execute on N_SEC_MANAGER_API_PKG to apps;

grant execute on N_SEC_MANAGER_DM_PKG to apps;

grant execute on N_SEC_MANAGER_GUI_PKG to apps;

grant execute on N_SEC_MANAGER_MDSEC_PKG to apps;

grant execute on N_VIEW_PARAMETERS_API_PKG to apps;

2.       Here is my scripts to load the KFF tables:

/*

 SELECT

'execute '|| OBJECT_NAME||'.Init_Upld();'

FROM

user_objects

WHERE 1=1

 AND OBJECT_NAME LIKE 'N_KFF_%_PKG'

 AND OBJECT_TYPE= 'PACKAGE'

 ;

 */

execute N_KFF_ACCALIAS_PKG.Init_Upld();

execute N_KFF_CTLG_GRP_PKG.Init_Upld();

execute N_KFF_GL_ACCT_PKG.Init_Upld();

execute N_KFF_ITEM_LOC_PKG.Init_Upld();

execute N_KFF_MTL_CAT_PKG.Init_Upld();

execute N_KFF_SYS_ITEM_PKG.Init_Upld();

I find that this saves me some time.