Page Comparison

Partial Package-based project file attribute's list data is defined using Static data or Groovy script, but if necessary we , you can change it this list for customer your 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.

...

...

Access object type details screen by using Menu option - Customize - File Types.

...

List override can be done for any attribute. Find specific attribute using search controls. Click on No or Yes in List Overridden? column for attribute.

...

Make sure to select Yes for List Overridden? and enter Listdata Override Script. Then click Save.

...

return '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;

'

Now let's talk about how you write such groovy script. You have access to various details about file and project properties as shown below. You can make decision based on available variables and return list data comma separated value that makes sense, or you can return null in which case FlexDeploy will make determination based on default logic as documented in EBS Object Types Reference.

Following variables are available for use in the Groovy script along with Project Properties.

Related articles