Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Partial project attribute's list data is defined using Static data or Groovy script, but if necessary we can change it for customer implementation.

Step-by-step guide

Prepare SQL script as necessary and execute on FlexDeploy database.

Following example is for EBS projects, AOL object type and TYPE attribute list data. Note FD_OBJECT_TYPE_OVERRIDES_EBS and AOL_TYPE_LISTDATA for DB Properties data. Basically FD_OBJECT_TYPE_OVERRIDES_<Project Type> and <Object Type>_<Attribute Type Code>_LISTDATA.

Other options areĀ DEFAULTSSCRIPT and VALIDATORSCRIPT, which also can be tweaked using same mechanism.

UPDATE FD.OBJECT_ATTRIBUTE_DEF set OVERRIDE_LIST_DATA='Y' 
where object_type_id=(select object_type_id from fd.object_type where project_type='EBS' and object_type_code='AOL') and object_attribute_code='TYPE';
  
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
(
8010,
'FD_OBJECT_TYPE_OVERRIDES_EBS',
'AOL_TYPE_LISTDATA',
0,
'Overriding AOL Types',
'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
(
8010,
8010,
0,
'dummy',
'',
'Y',
sysdate,
user,
sysdate,
user,
1
);

BEGIN
update  FF.DB_PROPERTIES_DATA set DB_PROPERTIES_VALUE = '"ALR_ALERTS,AME_ACTION_USAGES,AME_APPROVAL_GROUP_CONFIG,AME_APPROVAL_GROUPS,AME_ATTRIBUTE_USAGES,AME_ATTRIBUTES,AME_CALLING_APPS,AME_CONDITIONS,AME_RULES,DESC_FLEX,FND_ATTACHMENT_FUNCTIONS,FND_CURRENCY,FND_DOC_SEQUENCE_CATEGORIES,FND_FORM_CUSTOM_RULES,FND_LANGUAGE,FND_LOOKUP_TYPE,FND_NEW_MESSAGES,FND_RESPONSIBILITY,FND_SEQUENCE,FND_TABLE,FND_TERRITORY,FND_USER,FND_VIEW,FORM,FUNCTION,GRANT,JTF_GRID_DATASOURCES,KEY_FLEX,MENU,OTHER,PRINTER,PRINTER_STYLE,PROFILE,PROGRAM,REQ_SET,REQ_SET_LINKS,REQUEST_GROUP,SCHEDULE,VALUE_ROLLUP_GROUP,VALUE_SECURITY_RULE,VALUE_SET,VALUE_SET_VALUE,WF_ROLE,XDO_DS_DEFINITIONS"' where 
DB_PROPERTIES_DATA_ID = 8010 AND 
SEQUENCE_NUMBER = 0;
END;
/
  
commit;
You can also use PROJECT_ID, PROJECT_NAME, FOLDER_PATH variables in Defaults script if you want different behavior for specific Project(s). This is possible only for 4.5 build 10/27/2017 or later.




  • No labels