| Info |
|---|
This option is only available since 4.6.0.3 patch. |
When you perform Populate operation from SCM, files are organized in various types based path, file extension etc. You can customize this behavior by updating project properties in many cases. You can customize this further by using Groovy script .You can create property in SCRIPT property of FD_MATCH_SCRIPT_OVERRIDES_EBS to customize this.
Here is an example of matching files from /install/sql as Concurrent Program SQL and /install/bin as Script with Execution.
| Code Block | ||||
|---|---|---|---|---|
| ||||
set define off;
INSERT INTO FF.DB_PROPERTIES ( DB_PROPERTIES_ID, DB_PROPERTIES_NAME, DB_PROPERTIES_KEY, SEQUENCE_NUMBER, DESCRIPTION, IS_ACTIVE, IS_REQUIRED, IS_ENCRYPTED, DATA_TYPE, VALIDATION_SCRIPT, VALIDATION_MESSAGE, MIN_VALUE, MAX_VALUE, DISPLAY_ROWS, DISPLAY_COLUMNS, LIST_DATA, CREATED_ON, CREATED_BY, UPDATED_ON, UPDATED_BY, VERSION_NUMBER ) VALUES ( 1000000000000010, 'FD_MATCH_SCRIPT_OVERRIDES_EBS', 'SCRIPT', 0, 'Overriding match script', 'Y', 'Y', 'N', 'String', null, null, null, null, 1, 1, null, sysdate, user, sysdate, user, 1 );
INSERT INTO FF.DB_PROPERTIES_DATA ( DB_PROPERTIES_DATA_ID, DB_PROPERTIES_ID, SEQUENCE_NUMBER, DB_PROPERTIES_VALUE, DESCRIPTION, IS_ACTIVE, CREATED_ON, CREATED_BY, UPDATED_ON, UPDATED_BY, VERSION_NUMBER ) VALUES ( 1000000000000010, 1000000000000010, 0, 'dummy', '', 'Y', sysdate, user, sysdate, user, 1 );
BEGIN
update FF.DB_PROPERTIES_DATA set DB_PROPERTIES_VALUE = 'FILE_CONTENT_NEEDED=Boolean.TRUE;
CP_SQL_DIR=''install/sql'';
if (FILE_PATH_PREFIX.contains(CP_SQL_DIR) && FILE_EXTENSION.toUpperCase().equals(''SQL''))
{
return ''CP_SQL'';
}
SCRIPT_DIR=''install/bin'';
if (FILE_PATH_PREFIX.contains(SCRIPT_DIR))
{
return ''SCRIPT_EXECUTION'';
}
return null;' where
DB_PROPERTIES_DATA_ID = (SELECT DB_PROPERTIES_ID FROM FF.DB_PROPERTIES WHERE DB_PROPERTIES_NAME='FD_MATCH_SCRIPT_OVERRIDES_EBS' AND DB_PROPERTIES_KEY='SCRIPT') AND
SEQUENCE_NUMBER = 0;
END;
/
commit; |
...