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 7 Next »

Setup Tasks allow for export and import of setup task as a CSV File package (zip file). If supported, scope can be applied to export a subset of the CSV File package data via Export Criteria. Export Criteria can be easily configured via the FlexDeploy during manual file creation. In the case, scope cannot be applied, please see other supported Oracle Saas FSM object types as an alternative solution.

Object Type Identification

  • When populating files from source control management (SCM), FlexDeploy will classify all zip files containing "SetupTasks" (case-insensitive in their path) will get classified as Setup Task. This assumes the other object types do not take precedence.

File Extensions

  • .zip

Object Type Code

SETUP_TASK

Attributes

Name

Code

Description

Default Value

Supported Values

Source

SOURCE

Object Source Location Type

SCM

SCM, CLOUD

Task Code

TASK_CODE

Unique id for Setup Task

FILE_NAME*

Export Criteria 

EXPORT_CRITERIA

Export Criteria used to apply scope to a setup task.

Filter Criteria

FILTER_CRITERIA

After export, filter criteria is used to apply additional filtering to the setup task.

Special Considerations

Export Criteria

Export criteria are details about the Setup Task used to filter the setup data during CSV export. The export criteria are useful when the user only wants to export, and ultimately deploy, a subset of the setup data to target Oracle SaaS environment(s). Due to Oracle API limitations, only a subset of the exportable Setup Tasks support criteria functionality. It is known that some export and import processes can timeout which is likely due setup data being too large (>10MB) and/or taking too much execution time (>5 minutes). In those cases, use the Export Criteria to divide the setup data into more manageable deployment chunks.

Support for those Setups which are missing Export Criteria likely need to go through Oracle support before going through Flexagon support.

 Setup Tasks with Export Criteria Supported

Each entry is Setup Task Code followed by right arrow and then comma separated list of business object codes supported for Export Criteria.

  1. AP_MANAGE_TAX_CODES->ZX_TAX,ZX_TAX_REGIME

  2. ASXS_MANAGE_DUTIES->ORA_ASE_FUNCTIONAL_SECURITY_CUSTOM_ROLES

  3. ASXS_MANAGE_JOB_ROLES->ORA_ASE_FUNCTIONAL_SECURITY_CUSTOM_ROLES

  4. BEN_MANAGE_ELIGIBILITY_PROFILES->BEN_ELIGY_PRFL

  5. CE_MANAGE_BANKS->CE_BANK_INFO

  6. CMP_MANAGE_COMPENSATION_HISTORY->CMP_COMPENSATION_HISTORY

  7. CMP_MANAGE_COMPENSATION_PLANS->CMP_PLAN

  8. CMP_MANAGE_INDIVIDUAL_COMPENSATION_PLANS->CMP_VARIABLE_COMP_PL_DESIGN

  9. CMP_MANAGE_SALARY_BASIS->CMP_SALARY_BASIS

  10. CMS_MANAGE_COMPENSATION_CATEGORIES->CMS_TOT_COMP_STMT_SETUP_DEFINITION

  11. CMS_MANAGE_COMPENSATION_ITEMS->CMS_TOT_COMP_STMT_SETUP_DEFINITION

  12. CMS_MANAGE_STATEMENT_DEFINITIONS->CMS_TOT_COMP_STMT_SETUP_DEFINITION

  13. CST_MANAGE_COST_ANALYSIS_GROUPS->CST_COST_ANALYSIS_GROUP

  14. CST_MANAGE_COST_BOOKS->CST_COST_BOOK

  15. CST_MANAGE_COST_COMPONENT_MAPPINGS->CST_COST_COMPONENT,ORA_COST_COMPONENT_GROUP_DETAIL,ORA_COST_COMPONENT_GROUP_ELEMENT_DETAIL

  16. CST_MANAGE_COST_ELEMENTS->CST_COST_ANALYSIS_GROUP_ELEMENT,CST_COST_ELEMENT

  17. CST_MANAGE_COST_ORGANIZATIONS->CST_COST_ORGANIZATION

  18. CST_MANAGE_COST_ORGANIZATION_RELATIONSHIPS->CST_COST_ORGANIZATION,CST_COST_ORG_BOOK

  19. CST_MANAGE_COST_PROFILES->CST_COST_PROFILE

  20. CST_MANAGE_DEFAULT_COST_PROFILES->CST_DEFAULT_COST_PROFILE

  21. CST_MANAGE_ITEM_COST_PROFILE->CST_ITEM_COST_PROFILE

  22. CST_MANAGE_OVERHEAD_COST_ELEMENT_GROUPS->CST_COST_ELEMENT_GROUP,ORA_COST_ELEMENT_GROUP_DETAIL

  23. CST_MANAGE_OVERHEAD_EXPENSE_POOLS->CST_EXPENSE_POOL

  24. CST_MANAGE_VALUATION_STRUCTURES->CST_VALUATION_STRUCTURE

  25. CST_MANAGE_VALUATION_UNITS->CST_VALUATION_UNIT,ORA_COST_VALUATION_UNIT_DETAIL

  26. DOO_MANAGE_ORCHESTRATION_PROCESS_DEFINITIONS->DOO_ORCHESTRATION_PROCESS

  27. FUN_MANAGE_BUSINESS_UNIT->FUN_BUSINESS_UNIT

  28. GL_ASSIGN_BALANCING_SEGMENT_VALUES_TO_LEGAL_ENTITIES->GL_PRIMARY_LEDGER

  29. GL_MANAGE_PRIMARY_LEDGERS->GL_PRIMARY_LEDGER

  30. GL_MANAGE_REPORTING_CURRENCIES->GL_PRIMARY_LEDGER

  31. GL_MANAGE_SECONDARY_LEDGERS->GL_SECONDARY_LEDGER

  32. HRA_MANAGE_DOCUMENT_TYPES->HRA_DOC_TYPE

  33. HRA_MANAGE_MATRIX_LAYOUTS->HRA_BOX_NAMES

  34. HRA_MANAGE_PERFORMANCE_ROLES->HRA_PARTICIPANT

  35. HRA_MANAGE_PERFORMANCE_TEMPLATES->HRA_TEMPLATE,HRA_TEMPLATE_SECTION

  36. HRA_MANAGE_PROCESS_FLOW_DEFINITIONS->HRA_PROCESS_FLOW

  37. HRA_MANAGE_SECTIONS->HRA_SECTION_DEFN

  38. HRG_MANAGE_GOAL_PLANS->ORA_GOAL_PLAN_DOCUMENT_TYPES,ORA_GOAL_PLAN_MASS_REQUEST,ORA_GOAL_PLAN_MASS_REQUEST_ASSIGNMENT,ORA_GOAL_PLAN_MASS_REQUEST_ELPRO,ORA_GOAL_PLAN_MASS_REQUEST_EXEMPTIONS,ORA_GOAL_PLAN_MASS_REQUEST_HIERARCHY,HRA_GOAL_PLANS

  39. HRR_CONFIGURE_TALENT_REVIEW_DASHBOARD_OPTIONS->HRR_DASHBOARD_TMPLS

  40. HRT_MANAGE_CONTENT_SUBSCRIBERS->ORA_HRT_CONTENT_SOURCES,HRT_SOURCES_B

  41. HRT_MANAGE_EDUCATIONAL_ESTABLISHMENTS->HRT_SCHOOL

  42. HRT_MANAGE_INSTANCE_QUALIFIERS->HRT_QUALIFIERS_SET_B

  43. HRT_MANAGE_PROFILE_CONTENT_ITEMS->HRT_CONTENT_ITEMS_B

  44. HRT_MANAGE_PROFILE_CONTENT_TYPES->HRT_CONTENT_TYPES_B

  45. HRT_MANAGE_PROFILE_RATING_MODELS->HRT_RATING_MODELS_B

  46. HRT_MANAGE_PROFILE_TYPES->HRT_PROFILE_TYPES_B

  47. HRT_MANAGE_QUESTIONNAIRES->HRQ_QUESTIONNAIRE

  48. HRT_MANAGE_QUESTIONNAIRE_TEMPLATES->HRQ_QUESTIONNAIRE_TEMPLATE

  49. HRT_MANAGE_QUESTIONS->HRQ_QUESTION

  50. HRT_MANAGE_TALENT_NOTIFICATIONS->HRT_NOTIF_SETUP

  51. ORA_ANC_MANAGE_ABSENCE_CATEGORIES->ORA_ANC_ABSENCE_CATEGORY

  52. ORA_ANC_MANAGE_ABSENCE_CERTIFICATIONS->ORA_ANC_ABSENCE_CERTIFICATION

  53. ORA_ANC_MANAGE_ABSENCE_PLANS->ORA_ANC_ABSENCE_PLAN

  54. ORA_ANC_MANAGE_ABSENCE_REASONS->ORA_ANC_ABSENCE_REASON

  55. ORA_ANC_MANAGE_ABSENCE_TYPES->ORA_ANC_ABSENCE_TYPE

  56. ORA_ANC_MANAGE_AVAILABILITY_TYPES->ORA_ANC_AVAILABILITY_TYPE

  57. ORA_ANC_MANAGE_LEAVE_AGREEMENTS->ORA_ABSENCE_AGREEMENT

  58. ORA_ASE_ADMIN_SETTINGS_SCOPE->ORA_ASE_ADMINISTRATION_SETTINGS

  59. ORA_ASE_MANAGE_SECURITY_PREFERENCES->ORA_ASE_USER_CATEGORY,ORA_ASE_ADMINISTRATION_SETTINGS

  60. ORA_ASE_SEARCH_JOB_ROLES->ORA_ASE_FUNCTIONAL_SECURITY_CUSTOM_ROLES

  61. ORA_ASE_USER_CATEGORIES_SCOPE->ORA_ASE_USER_CATEGORY

  62. ORA_BEN_EXPORT_ELIGIBILITY_PROFILE->BEN_ELIGY_PRFL

  63. ORA_BEN_IMPORT_ELIGIBILITY_PROFILE->BEN_ELIGY_PRFL

  64. ORA_CML_SET_UP_ROUTES->ORA_CML_ROUTE

  65. ORA_CMP_MANAGE_COMPENSATION_GRADE_LADDER->PER_GRADE_LADDER

  66. ORA_CMP_MANAGE_SALARY_RANGE_DIFFERENTIALS->ORA_CMP_SALARY_RANGE_DIFFERENTIAL

  67. ORA_CMP_MAP_THIRD_PARTY_COMPENSATION_PLANS->ORA_THIRD_PARTY_COMPENSATION_PLAN_MAPPING

  68. ORA_CSE_MANAGE_ASSET_GROUP_RULES->ORA_CSE_ASSET_GROUP_RULE,ORA_CSE_ASSET_GROUP_RULE_ATTRIBUTE,ORA_CSE_ASSET_GROUP_RULE_USAGE

  69. ORA_FOD_SETUP_ASSISTANT->FUN_BUSINESS_UNIT

  70. ORA_GL_MANAGE_CLEARING_ACCOUNTS_RECONCILIATION->ORA_GL_RECONCILIATION_RULE

  71. ORA_HRA_FEEDBACK_TEMPLATES->ORA_HRA_FEEDBACK_TEMPLATE

  72. ORA_HRC_MANAGE_HSDL_BO_ACCESS->ORA_HRC_SDL_BO_ROLE_SECURITY_MAP

  73. ORA_HRC_MANAGE_HSDL_TEMPLATES->ORA_HRC_SDL_TEMPLATE

  74. ORA_HRM_TALENT_POOL_SECURITY_PROFILE->ORA_TALENT_POOLS_SECURITY_PROFILE

  75. ORA_HRT_MANAGE_FEEDBACK_VISIBILITY->ORA_FEEDBACK_VISIBILITY

  76. ORA_HTS_MANAGE_SCHEDULER_PROFILES->ORA_HTS_WF_SCHED_PROFILE

  77. ORA_HTS_MANAGE_SHIFT_PROPERTIES->ORA_HTS_WF_SHIFT_TYPE

  78. ORA_HWM_MANAGE_ATTESTATION_SETS->ORA_HWM_ATTESTATION_SET

  79. ORA_HWM_MANAGE_CUSTOM_TIME_ATTRIBUTES->ORA_HWM_TM_ATRB_FLD

  80. ORA_HWM_MANAGE_GROUPS->ORA_HWM_GRP

  81. ORA_HWM_MANAGE_REPEATING_PERIODS->ORA_HWM_RP_TM_PERIOD

  82. ORA_HWM_MANAGE_RULES->ORA_HWM_RULE

  83. ORA_HWM_MANAGE_RULE_SETS->ORA_HWM_RULE_SET

  84. ORA_HWM_MANAGE_RULE_TEMPLATES->ORA_HWM_RULE_TMPLT

  85. ORA_HWM_MANAGE_TIME_ALLOCATIONS->ORA_HWM_TIME_ALLOCATION

  86. ORA_HWM_MANAGE_TIME_BALANCE_DEFINITIONS->ORA_HWM_TM_BAL_TYPE

  87. ORA_HWM_MANAGE_TIME_BALANCE_DIMENSIONS->ORA_HWM_TM_BAL_DIMENSION

  88. ORA_HWM_MANAGE_TIME_C0NSUMER_SETS->ORA_HWM_TCSMR_CONFIG_SET

  89. ORA_HWM_MANAGE_TIME_CATEGORIES->ORA_HWM_TCAT_CMP

  90. ORA_HWM_MANAGE_TIME_DEVICE_EVENT_MAPPING->ORA_HWM_TCD_EVT_MAP

  91. ORA_HWM_MANAGE_TIME_DEVICE_EVENT_MAPPING_SETS->ORA_HWM_TCD_EVT_MAP_SET

  92. ORA_HWM_MANAGE_TIME_DEVICE_EXPORT_DATA->ORA_HWM_TCD_EXP_DEF

  93. ORA_HWM_MANAGE_TIME_DEVICE_PROCESSING_PROFILES->ORA_HWM_TCD_PROF

  94. ORA_HWM_MANAGE_WORK_DAY_DEFINITIONS->ORA_HWM_WORK_DAY_DEF

  95. ORA_HXT_MANAGE_LAYOUT_SETS->ORA_HXT_TCLAYST

  96. ORA_HXT_MANAGE_TIMECARD_FIELDS->ORA_HXT_TCLAYFLD_DEFN

  97. ORA_HXT_MANAGE_WORKER_CORE_PROCESSING_SETUP_PROFILES->ORA_HXT_TL_CORE_SETUP_PROFILE

  98. ORA_HXT_MANAGE_WORKER_WEB_TIME_ENTRY_SETUP_PROFILES->ORA_HXT_TL_WE_SETUP_PROFILE

  99. ORA_IRC_APPLY_FLOW_CONFIGURATION->ORA_IRC_JA_APPLY_FLOW,ORA_IRC_JA_AF_AVAIL_CXT,ORA_IRC_JA_AF_AVAIL_CXT_REC_TYPE,ORA_IRC_JOB_AF_PAGE,ORA_IRC_JOB_AF_PAGE_BLOCK,ORA_IRC_JOB_AF_SECTION,ORA_IRC_JOB_AF_VERSION

  100. ORA_IRC_CANDIDATE_SELECTION_PROCESS_CONFIGURATION->ORA_IRC_LC_ACTION,ORA_IRC_LC_AVAILABILITY_CXT,ORA_IRC_LC_FUNCTION_EXPR,ORA_IRC_LC_NOTIF,ORA_IRC_LC_PHASE,ORA_IRC_LC,ORA_IRC_LC_ROUTING,ORA_IRC_LC_SECONDARY_FLOW,ORA_IRC_LC_SETTING_ITEMS,ORA_IRC_LC_SETTINGS,ORA_IRC_LC_STATE

  101. ORA_IRC_CATEGORY_PROVISIONING_AND_CONFIGURATION->ORA_PARTNER_SERVICE_ACTIVATION

  102. ORA_IRC_CAT_ENABLE->ORA_PARTNER_SERVICE_PROVISIONING

  103. ORA_IRC_COMPUTED_FIELDS_CONFIGURATION->ORA_IRC_JA_COMPOUND_FIELD_DATA

  104. ORA_IRC_CONFIGURE_CAREER_SITE->ORA_IRC_CX_SITES

  105. ORA_IRC_DOI_MANAGEMENT->ORA_IRC_DOI_SETTING_VALUES,ORA_IRC_DOI_SETTINGS

  106. ORA_IRC_GEO_HRCHY->ORA_GEOGRAPHY_HIERARCHY

  107. ORA_IRC_GEO_HRCHY_STRUCTURE->ORA_GEOGRAPHY_STRUCTURE_HIERARCHY

  108. ORA_IRC_MANAGE_CSP_REASONS->ORA_IRC_CSP_REASON,ORA_IRC_CSP_REASON_GROUP,ORA_IRC_CSP_REASON_USAGE

  109. ORA_IRC_MANAGE_ENTERPRISE_RECRUITING_AND_CANDIDATE_EXPERIENCE_INFORMATION->ORA_IRC_SETTING_VALUE,ORA_IRC_SETTING

  110. ORA_IRC_MANAGE_JOB_REQUISITION_SECURITY_PROFILE->ORA_IRC_REQ_SEC_PROFILES,ORA_IRC_REQ_SEC_PROFILES_TMT

  111. ORA_IRC_MANAGE_ORGANIZATION_DESCRIPTION_LIBRARY->ORA_IRC_ORGANIZATION_DESCRIPTION,ORA_IRC_ORGANIZATION_DESCRIPTION_VERSION,ORA_IRC_ORGANIZATION_DESCRIPTION_VERSION_ATTACHMENT

  112. ORA_IRC_MP_SITE_CONFIGURATION->ORA_IRC_MP_SITE_CONFIG_AVAIL_CXT,ORA_IRC_MP_SITE_CONFIG_AVAIL_CXT_JOB_FAM,ORA_IRC_MP_SITE_CONFIG_AVAIL_CXT_JOB_FUNC,ORA_IRC_MP_SITE_CONFIG_AVAIL_CXT_LOC,ORA_IRC_MP_SITE_CONFIG_AVAIL_CXT_ORG,ORA_IRC_MP_SITE_CONFIG_AVAIL_CXT_REC_TYPE,ORA_IRC_MP_SITE_CONFIG_FILTER,ORA_IRC_MP_SITE_CONFIG_FILTER_TL

  113. ORA_MANAGE_CHECK_IN_TEMPLATES->ORA_HRA_CHECK_IN_TEMPLATE

  114. ORA_MANAGE_COLLECTIVE_AGGREMENTS->ORA_PER_COLLECTIVE_AGREEMENT

  115. ORA_MANAGE_CREDENTIAL_GROUPS->ORA_PSC_CREDENTIAL_GROUP

  116. ORA_MANAGE_HCM_ALERTS->ORA_HCM_ALERTS

  117. ORA_MANAGE_PROFILE_ITEM_CATALOG->ORA_TALENT_CATALOG_CONTENT_ITEM,ORA_TALENT_CATALOG_CONTENT_ITEM_RDESC,ORA_TALENT_PROFILE_ITEM_CATALOG

  118. ORA_MANAGE_WORK_SCHEDULE_EXCEPTION->ORA_PER_HCM_SCHED_ELIG,ORA_PER_HCM_SCHED_EXCPT

  119. ORA_MNT_MANAGE_CONDITION_EVENT_CODES->ORA_CSE_CONDITION_EVENT_CODE

  120. ORA_PAY_MANAGE_BALANCE_GROUPS->ORA_PAY_BALANCE_GROUP

  121. ORA_PAY_MANAGE_BALANCE_GROUP_USAGES->ORA_PAY_BALANCE_GROUP_USAGE

  122. ORA_PAY_MANAGE_RATE_DEFINITIONS->ORA_PAY_RATE_DEFINITION

  123. ORA_PAY_MANAGE_VALUE_BY_CRITERIA->ORA_PAY_VALUE_BY_CRITERIA

  124. ORA_PER_ASSIGN_SECURITY_PROFILES_TO_ROLE->PER_HCM_DATA_ROLE

  125. ORA_PER_MANAGE_ASSIGNMENT_FLEXFIELD_MAPPING->ORA_PER_PERSON_ASSIGNMENT_FLEXFIELD_MAP

  126. ORA_PER_MANAGE_HCM_EXCLUSION_RULES->ORA_PER_HCM_EXCLUSION_RULE

  127. ORA_PER_MANAGE_PERSON_NAME_STYLES->ORA_PER_HR_NAME_STYLE

  128. ORA_PER_MANAGE_ROLE_PROVISIONING_RULES->ORA_PER_ROLE_PROVISIONING_RULE

  129. ORA_PER_MANAGE_TRANSACTION_SECURITY_PROFILE->ORA_HRC_TXN_SECURITY_PROFILE,ORA_HRC_TXN_SECURITY_PROFILE_ENTRY,ORA_HRC_TXN_SECURITY_PROFILE_SUB_CAT

  130. ORA_PER_MANAGE_WORKER_UNIONS->ORA_PER_WORKER_UNION

  131. ORA_PSCR_STSK_PRCS_DEFN_GROUP->ORA_PSC_CE_PRCS_GROUP

  132. ORA_PSC_STSK_ACTIVITIES->ORA_PSC_APP_ACITIVTY

  133. ORA_PSC_STSK_ACTIVITY_GROUPS->ORA_PSC_APP_ACTIVITY_GROUP

  134. ORA_PSC_STSK_ACTIVITY_STATUSES->ORA_PSC_APP_ACTIVITY_STATUS

  135. ORA_PSC_STSK_AGENCY_BUSINESS_CATEGORIES->ORA_PSC_BUSINESS_CATEGORY

  136. ORA_PSC_STSK_AGENCY_FEATURE->ORA_PSC_AGENCY_FEATURE

  137. ORA_PSC_STSK_AGENCY_RECEIVABLE_OPTIONS->ORA_PSC_RECEIVABLE_OPTION

  138. ORA_PSC_STSK_BL_RECORD_TYPE_DISPLAY_GROUPS->ORA_PSC_BL_RECTYPE_DISPLAY_GROUP

  139. ORA_PSC_STSK_BL_TAX_ATTRIBUTE->ORA_PSC_BL_TAX_ATTRB

  140. ORA_PSC_STSK_BL_TAX_CLASSES->ORA_PSC_BL_TAX_CLASS

  141. ORA_PSC_STSK_BUS_RULES_FRAMEWORK->ORA_PSC_EVENT_RULE

  142. ORA_PSC_STSK_CASE_TRANSACTION_STATUSES->ORA_PSC_CE_STATUS

  143. ORA_PSC_STSK_COA->ORA_PSC_COA_CONDITION

  144. ORA_PSC_STSK_COA_CATEGORY->ORA_PSC_COA_CATEGORY

  145. ORA_PSC_STSK_COA_TEMPLATE->ORA_PSC_COA_TEMPLATE

  146. ORA_PSC_STSK_CODE_REFERENCE_GROUPS->ORA_PSC_CODE_REF_GROUP

  147. ORA_PSC_STSK_CODE_REF_CE->ORA_PSC_CODE_REFERENCE

  148. ORA_PSC_STSK_CONT_LIC_OPT->ORA_PSC_CONT_LIC_OPTION

  149. ORA_PSC_STSK_CONT_LIC_SEC->ORA_PSC_CONT_LIC_SECTION

  150. ORA_PSC_STSK_CORRECTIVE_ACTIONS->ORA_PSC_CODE_CORRECT_ACTION

  151. ORA_PSC_STSK_DASHBOARD_CONFIG->ORA_PSC_DASHBOARD_CONFIG

  152. ORA_PSC_STSK_DOC_GROUPS->ORA_PSC_DOCUMENT_GROUP

  153. ORA_PSC_STSK_EXPIRATION_GROUP->ORA_PSC_BL_EXPIRATION_GROUP,ORA_PSC_EXPIRATION_GROUP

  154. ORA_PSC_STSK_FEE_ITEM_RECEIVABLE_OPTIONS->ORA_PSC_FEE_ITEM_MEMO

  155. ORA_PSC_STSK_GIS_MAP_SERVICE->ORA_PSC_GIS_MAP_SERVICE

  156. ORA_PSC_STSK_GRID_PERSONALIZATION->ORA_PSC_GRID_PERSONALIZATION

  157. ORA_PSC_STSK_HEARING_BODY->ORA_PSC_HEARING_BODY

  158. ORA_PSC_STSK_HEARING_DECISION_STATUS->ORA_PSC_HEARING_DECISION

  159. ORA_PSC_STSK_INSPECTION_COUNTS->ORA_PSC_INSPECTION_COUNT

  160. ORA_PSC_STSK_INSTRUCTIONAL_TEXT->ORA_PSC_INSTR_TEXT

  161. ORA_PSC_STSK_INS_TYPE_DEPENDENCY->ORA_PSC_INS_DEPENDENCY

  162. ORA_PSC_STSK_ISSUE_TYPES_CE->ORA_PSC_CE_ISSUE_TYPE

  163. ORA_PSC_STSK_MEETING_TEMPLATES->ORA_PSC_MEETING_TEMPLATE

  164. ORA_PSC_STSK_MOD_EXISTING_PAGES->ORA_PSC_STD_CFGR_LAYOUT

  165. ORA_PSC_STSK_NOTICES->ORA_PSC_CE_NOTICE_TYPE

  166. ORA_PSC_STSK_NOTICE_GROUPS->ORA_PSC_CE_NOTICE_GROUP

  167. ORA_PSC_STSK_PLAN_REVIEWER_DEPT->ORA_PSC_PLAN_REVIEWER_DEPT

  168. ORA_PSC_STSK_RECENT_ACT_CONFIG->ORA_PSC_RECENT_ACT_CONFIG

  169. ORA_PSC_STSK_RECORD_TYPE_RECEIVABLE_OPTIONS->ORA_PSC_RECORD_TYPE_MEMO

  170. ORA_PSC_STSK_REFERRAL_BODIES->ORA_PSC_CE_REFERRAL_BODY

  171. ORA_PSC_STSK_SEARCH_ACCOUNTING_EVENTS->ORA_PSC_ACC_EVENTS

  172. ORA_PSC_STSK_SEARCH_ACCOUNTING_RULES->ORA_PSC_ACC_RULES

  173. ORA_PSC_STSK_SEARCH_ACCOUNTS->ORA_PSC_ACCOUNTS

  174. ORA_PSC_STSK_SEARCH_AGENCIES->ORA_PSC_MANAGE_AGENCIES

  175. ORA_PSC_STSK_SEARCH_AGENCY_JOB_TITLES->ORA_PSC_JOB_TITLES

  176. ORA_PSC_STSK_SEARCH_AGENCY_PAYMENT_OPTION->ORA_PSC_AGENCY_PAY_OPTION

  177. ORA_PSC_STSK_SEARCH_AGENCY_STAFF_GROUPS->ORA_PSC_JOB_GROUP_DEFN

  178. ORA_PSC_STSK_SEARCH_APO_MAPPING->ORA_PSC_APO_MAPPING

  179. ORA_PSC_STSK_SEARCH_APPLICATION_GROUPS->ORA_PSC_APPLICATION_GROUP

  180. ORA_PSC_STSK_SEARCH_ASSIGN_THEME->ORA_PSC_ASSIGN_THEME

  181. ORA_PSC_STSK_SEARCH_AUTO_NUMBERING->ORA_PSC_MANAGE_AUTO_NUMBRING

  182. ORA_PSC_STSK_SEARCH_BILL_TYPES->ORA_PSC_BNP_BILL_TYPE

  183. ORA_PSC_STSK_SEARCH_CASH_DRAWER->ORA_PSC_BNP_CASH_DRAWER

  184. ORA_PSC_STSK_SEARCH_CATEGORIES->ORA_PSC_CATEGORY

  185. ORA_PSC_STSK_SEARCH_CHECKLIST_CATEGORIES->ORA_PSC_CHECKLIST_CATEGORY

  186. ORA_PSC_STSK_SEARCH_CHECKLIST_GROUPS->ORA_PSC_CHECKLIST_GROUP

  187. ORA_PSC_STSK_SEARCH_CITIES->ORA_PSC_MANAGE_CITIES

  188. ORA_PSC_STSK_SEARCH_COMMENTS->ORA_PSC_COMMENT

  189. ORA_PSC_STSK_SEARCH_COMMENT_CATEGORY->ORA_PSC_COMMENT_CATEGORY

  190. ORA_PSC_STSK_SEARCH_COMMUNICATION_EVENTS->ORA_PSC_COMMUNICATION_EVENT

  191. ORA_PSC_STSK_SEARCH_CONDITIONS->ORA_PSC_CONDITION

  192. ORA_PSC_STSK_SEARCH_CONTACT_TYPES->ORA_PSC_MANAGE_CONTACT_TYPES

  193. ORA_PSC_STSK_SEARCH_COUNTIES->ORA_PSC_MANAGE_COUNTIES

  194. ORA_PSC_STSK_SEARCH_COUNTRIES->ORA_PSC_MANAGE_COUNTRIES

  195. ORA_PSC_STSK_SEARCH_CURRENCIES->ORA_PSC_MANAGE_CURRENCIES

  196. ORA_PSC_STSK_SEARCH_DEPARTMENTS->ORA_PSC_DEPARTMENT

  197. ORA_PSC_STSK_SEARCH_DEPARTMENT_PAYMENT_OPTION->ORA_PSC_DEPARTMENT_PAY_OPTION

  198. ORA_PSC_STSK_SEARCH_DISTRICTS->ORA_PSC_MANAGE_DISTRICTS

  199. ORA_PSC_STSK_SEARCH_DISTRICT_TYPES->ORA_PSC_MANAGE_DISTRICTS_TYPES

  200. ORA_PSC_STSK_SEARCH_DIVISIONS->ORA_PSC_DIVISION

  201. ORA_PSC_STSK_SEARCH_DOCUMENT_CATEGORY_AND_SUBCATEGORIES->ORA_PSC_DOC_CAT_SUBCATEGORY

  202. ORA_PSC_STSK_SEARCH_FEE_ITEM->ORA_PSC_FEE_ITEM

  203. ORA_PSC_STSK_SEARCH_FUNCTIONS->ORA_PSC_FUNCTION

  204. ORA_PSC_STSK_SEARCH_FUNDS->ORA_PSC_FUNDS

  205. ORA_PSC_STSK_SEARCH_HOLIDAY_CALENDAR->ORA_PSC_MANAGE_HOLIDAY_CALENDAR

  206. ORA_PSC_STSK_SEARCH_INSPECTION_ASSESSMENTTYPES->ORA_PSC_ASSESSMENT_TYPE

  207. ORA_PSC_STSK_SEARCH_INSPECTION_CALENDARS->ORA_PSC_INS_CALENDAR

  208. ORA_PSC_STSK_SEARCH_INSPECTION_CHECKLISTS->ORA_PSC_INS_CHECKLIST

  209. ORA_PSC_STSK_SEARCH_INSPECTION_GROUPS->ORA_PSC_INS_GROUP

  210. ORA_PSC_STSK_SEARCH_INSPECTION_STATUSES->ORA_PSC_INS_STATUS

  211. ORA_PSC_STSK_SEARCH_INSPECTION_TYPES->ORA_PSC_INS_TYPE

  212. ORA_PSC_STSK_SEARCH_INVOICE_FORMS->ORA_PSC_BNP_INVOICE_FORM

  213. ORA_PSC_STSK_SEARCH_LEDGERS->ORA_PSC_LEDGER

  214. ORA_PSC_STSK_SEARCH_LOOKUPS->ORA_PSC_MANAGE_LOOKUPS

  215. ORA_PSC_STSK_SEARCH_MAP_PROFILE->ORA_PSC_MAP_PROFILE

  216. ORA_PSC_STSK_SEARCH_MONTHLY_ACCOUNTING_CALENDAR->ORA_PSC_ACC_CALENDAR

  217. ORA_PSC_STSK_SEARCH_OPA_METADATA_MODELS->ORA_PSC_OPA_METADATA_MODEL

  218. ORA_PSC_STSK_SEARCH_OWNERSHIP_TYPES->ORA_MANAGER_OWNERSHIP_TYPES

  219. ORA_PSC_STSK_SEARCH_PASSING_RULES->ORA_PSC_PASSING_RULE

  220. ORA_PSC_STSK_SEARCH_PAYMENT_ADAPTER->ORA_PSC_BNP_PAYMENT_ADAPTER

  221. ORA_PSC_STSK_SEARCH_PAYMENT_ADAPTER_ATTRIBUTES->ORA_PSC_BNP_PAYMENT_ADAP_ATTRB

  222. ORA_PSC_STSK_SEARCH_PAYMENT_ADAPTER_METHOD->ORA_PSC_BNP_PAYMENT_ADAP_METHOD

  223. ORA_PSC_STSK_SEARCH_PAYMENT_GATEWAY->ORA_PSC_PAYMENT_GATEWAY

  224. ORA_PSC_STSK_SEARCH_PLAN_REVIEW_DECISIONS->ORA_PSC_PLAN_REVIEW_DECISION

  225. ORA_PSC_STSK_SEARCH_PLAN_REVIEW_STATUSES->ORA_PSC_PLAN_REVIEW_STATUS

  226. ORA_PSC_STSK_SEARCH_PROGRAMS->ORA_PSC_PROGRAM

  227. ORA_PSC_STSK_SEARCH_PROJECT_TYPES->ORA_PSC_MANAGE_PROJECT_TYPES

  228. ORA_PSC_STSK_SEARCH_PROPERTY_CONDITIONS->ORA_PSC_MANAGE_PROPERTY_CONDITIONS

  229. ORA_PSC_STSK_SEARCH_PROPERTY_TYPES->ORA_PSC_MANAGE_PROPERTY_TYPES

  230. ORA_PSC_STSK_SEARCH_PUBLIC_USER_EXP->ORA_PSC_PUBLIC_USER_EXP

  231. ORA_PSC_STSK_SEARCH_PUBLIC_USER_SETUP->ORA_PSC_PUBLIC_USER_SETUP

  232. ORA_PSC_STSK_SEARCH_RATING_METHODS->ORA_SPC_RATING_METHOD

  233. ORA_PSC_STSK_SEARCH_RECORD_STATUSES->ORA_PSC_REC_STATUS

  234. ORA_PSC_STSK_SEARCH_RECORD_TYPE_DISPLAY_GROUPS->ORA_PSC_RECTYPE_DISPLAY_GROUP

  235. ORA_PSC_STSK_SEARCH_REPORT_CONFIGURATION->ORA_PSC_REPORT_MAPPING

  236. ORA_PSC_STSK_SEARCH_SET_UP_CONTEXTUAL_HELP->ORA_PSC_CONTEXTUAL_HELP

  237. ORA_PSC_STSK_SEARCH_STANDARD_COMMENTS->ORA_PSC_STD_COMMENT

  238. ORA_PSC_STSK_SEARCH_STATES->ORA_PSC_MANAGE_STATES

  239. ORA_PSC_STSK_SEARCH_SUBCATEGORIES->ORA_PSC_SUBCATEGORY

  240. ORA_PSC_STSK_SEARCH_TERMS_OF_USE->ORA_PSC_MANAGE_TOU

  241. ORA_PSC_STSK_SEARCH_THEME->ORA_PSC_DEFINE_THEME

  242. ORA_PSC_STSK_SEARCH_UOMS->ORA_PSC_MANAGE_UOMS

  243. ORA_PSC_STSK_SEARCH_UOM_CONVERSIONS->ORA_PSC_MANAGE_UOM_CONVERSIONS

  244. ORA_PSC_STSK_SEARCH_WORK_SCHEDULE->ORA_PSC_MANAGE_WORK_SCHEDULE

  245. ORA_PSC_STSK_TIME_CATEGORIES->ORA_PSC_TIME_TRANS_CATEGORY

  246. ORA_PSC_STSK_TIME_ENTRY_TYPES->ORA_PSC_TIME_TRANS_TYPE

  247. ORA_PSC_STSK_TIME_RULES->ORA_PSC_TIME_RULE_DEFN

  248. ORA_PSC_STSK_VALIDATION_GROUP->ORA_PSC_CONT_VALIDATION_GRP

  249. ORA_PSC_TSK_CREDENTIALS->ORA_PSC_CREDENTIALS

  250. ORA_PSC_TSK_EXEMPT_CREDENTIAL->ORA_PSC_CREDENTIAL_EXEMPT

  251. ORA_XCC_ENABLE_BUDGETARY_CONTROL->ORA_XCC_ENABLED_LEDGER

  252. ORA_XCC_MANAGE_CONTROL_BUDGETS->ORA_XCC_CONTROL_BUDGET

  253. ORA_XLA_MANAGE_FORMULA->ORA_SUBLEDGER_FORMULA_DETAIL,ORA_SUBLEDGER_FORMULA_SOURCE

  254. ORA_ZCA_MANAGE_PUID_SEQ->ORA_PUBLIC_UNIQUE_IDENTIFIER_SEQUENCE

  255. PAY_CONFIGURE_LEGISLATIONS_FOR_HUMAN_RESOURCES->PAY_ELEMENT_CLASSIFICATIONS

  256. PAY_MANAGE_BALANCE_DEFINITIONS->PAY_DEFINED_BALANCE

  257. PAY_MANAGE_BALANCE_EXCEPTIONS->PAY_EXCEPTION_REPORT

  258. PAY_MANAGE_BALANCE_EXCEPTION_REPORTS->PAY_EXCEPTION_REPORT_GROUP

  259. PAY_MANAGE_CONSOLIDATION_SETS->PAY_CONSOLIDATION_SET

  260. PAY_MANAGE_DEDUCTION_RANGES->PAY_DEDUCTION_VALUE_DEFINITION

  261. PAY_MANAGE_DEPARTMENT_COSTING->PAY_DEPARTMENT_COST

  262. PAY_MANAGE_ELEMENTS->PAY_ELEMENT_DEFINITION

  263. PAY_MANAGE_ELEMENT_CLASSIFICATIONS->PAY_ELEMENT_CLASSIFICATIONS

  264. PAY_MANAGE_ELEMENT_CRITERIA_COSTING->PAY_ELEMENT_COST

  265. PAY_MANAGE_FAST_FORMULA->FF_FORMULA

  266. PAY_MANAGE_JOB_COSTING->PAY_JOB_COST

  267. PAY_MANAGE_LEGAL_ENTITY_DEDUCTION_RECORDS->XLE_ENTITY_PROFILE

  268. PAY_MANAGE_ORGANIZATION_PAYMENT_METHODS->PAY_ORG_PAYMENT_METHOD

  269. PAY_MANAGE_PAYMENT_SOURCE_COSTING->PAY_PAYMENT_SOURCE_COST

  270. PAY_MANAGE_PAYROLL_COSTING->PAY_PAYROLL_COST

  271. PAY_MANAGE_PAYROLL_DEDUCTIONS->PAY_DEDUCTION_TYPE

  272. PAY_MANAGE_PAYROLL_DEFINITIONS->PAY_PAYROLL

  273. PAY_MANAGE_PAYROLL_FLOW_PATTERNS->PAY_PAYROLL_FLOW

  274. PAY_MANAGE_PAYROLL_FLOW_SECURITY_PROFILE->PAY_PAYROLL_FLOW_SEC_PROFILES

  275. PAY_MANAGE_PAYROLL_SECURITY_PROFILE->PAY_PAYROLL_SECURITY_PROFILES

  276. PAY_MANAGE_POSITION_COSTING->PAY_POSITION_COST

  277. PAY_MANAGE_TIME_DEFINITIONS->PAY_PAYROLL_TIME_DEFINITION,PAY_TIME_DEFINITION_USAGE

  278. PAY_MANAGE_USER-DEFINED_TABLES->PAY_USER_TABLE

  279. PER_DEFINE_DOCUMENT_TYPE->PER_DOCUMENT_TYPE

  280. PER_MANAGE_ACTIONS_AND_REASONS->PER_EMPLOYMENT_ACTION_REASON

  281. PER_MANAGE_ACTION_REASONS->PER_EMPLOYMENT_ACTION_REASON

  282. PER_MANAGE_ASSIGNMENT_STATUS->PER_ASSIGNMENT_STATUS_TYPE

  283. PER_MANAGE_CALENDAR_EVENT->PER_CALENDAR_EVENT

  284. PER_MANAGE_CHECKLIST_TEMPLATE->PER_CHECKLIST

  285. PER_MANAGE_COUNTRY_SECURITY_PROFILE->PER_COUNTRY_SECURITY_PROFILES

  286. PER_MANAGE_DEPARTMENT->PER_DEPARTMENT_ORG

  287. PER_MANAGE_DISABILITY_ORGANIZATION->PER_DISABILITY_ORG

  288. PER_MANAGE_DIVISION->PER_DIVISION_ORG

  289. PER_MANAGE_DOCUMENT_TYPE_SECURITY_PROFILE->PER_DOC_TYPE_SECURITY_PROFILES

  290. PER_MANAGE_EXTENDED_LOOKUP_CODE->PER_EXTENDED_LOOKUP_CODE

  291. PER_MANAGE_EXTRACT_DEFINITION->PER_EXTRACT_DEFINTION

  292. PER_MANAGE_GRADE->PER_GRADE

  293. PER_MANAGE_GRADE_LADDER->PER_GRADE_LADDER

  294. PER_MANAGE_GRADE_RATE->PER_GRADE_RATE

  295. PER_MANAGE_HCM_ROLE_PROVISIONING_RULES->ORA_PER_ROLE_PROVISIONING_RULE

  296. PER_MANAGE_JOB->PER_JOB

  297. PER_MANAGE_JOB_FAMILY->PER_JOB_FAMILY

  298. PER_MANAGE_LEGISLATIVE_DATA_GROUPS->PER_LEGISLATIVE_DATA_GROUP

  299. PER_MANAGE_LEGISLATIVE_DATA_GROUP_SECURITY_PROFILE->PER_LDG_SECURITY_PROFILES

  300. PER_MANAGE_LOCATIONS->PER_LOCATION

  301. PER_MANAGE_ORGANIZATION_SECURITY_PROFILE->PER_ORG_SECURITY_PROFILES

  302. PER_MANAGE_PERSON_AND_ASSIGNMENT_SECURITY_PROFILE->PER_PERSON_SECURITY_PROFILES

  303. PER_MANAGE_PERSON_NAME_FORMATS->PER_HR_NAME_FORMAT

  304. PER_MANAGE_PERSON_TYPES->PER_PERSON_TYPE

  305. PER_MANAGE_POSITION->PER_POSITION

  306. PER_MANAGE_POSITION_SECURITY_PROFILE->PER_POSITION_SECURITY_PROFILES

  307. PER_MANAGE_REPORTING_ESTABLISHMENT->PER_REPORTING_ESTB_ORG

  308. PER_MANAGE_WORK_SCHEDULE_ASSIGNMENT_ADMINISTRATION->PER_WORK_SCHEDULE_ASSIGNMENT

  309. PER_REVIEW_CALENDAR_EVENT_COVERAGE->PER_CALENDAR_EVENT

  310. QSC_MANAGE_PRODUCT_GROUP_MAPPING->QSC_PRODUCT_GROUP_MAP_INTENT

  311. XLA_MANAGE_ACCOUNTING_ATTRIBUTES->ORA_XLA_ACCT_FORMULA,ORA_XLA_ACCT_FORMULA_DETAIL,ORA_XLA_ACCT_FORMULA_SOURCE

  312. XLA_MANAGE_ACCOUNTING_METHOD->ORA_XLA_SLAM_JE_RULE_SETS

  313. XLA_MANAGE_JOURNAL_LINE_RULE->ORA_XLA_JLT_ACCT_ATTRS

  314. XLA_MANAGE_SUBLEDGER_APPLICATION->ORA_XLA_EVENT_CLASS_ATTRS,ORA_XLA_EVENT_CLASS,ORA_EVENT_CLASS_ATTRS,ORA_XLA_SUBLEDGERS_EVENTMAPPING,ORA_XLA_PROCESS_CATEGORY,ORA_XLA_ENTITY_TYPE,ORA_XLA_EVENT_MAPPING

  315. XLA_MANAGE_SUBLEDGER_APPLICATIONS_FOR_SCOPE->XLA_SUBLEDGER

  316. XLA_MANAGE_SUBLEDGER_APPLICATION_TRANSACTION_OBJECTS->XLA_SUBLEDGER

  317. XLA_MANAGE_SUBLEDGER_JOURNAL_ENTRY_RULE_SET->ORA_XLA_JERS_JLR_SEG_RULES,ORA_XLA_JERS_HDR_ACCTS,ORA_XLA_JERS_JLR_ASSIGNS,ORA_XLA_JERS_JLR_SREFS

  318. XLE_MANAGE_INTERCOMPANY_EXCEPTIONS->XLE_ENTITY_PROFILE

  319. XLE_MANAGE_LEGAL_ENTITY->XLE_ENTITY_PROFILE

  320. XLE_MANAGE_LEGAL_ENTITY_REGISTRATIONS->XLE_ENTITY_PROFILE

  321. XLE_MANAGE_LEGAL_REPORTING_UNIT->XLE_ETB_PROFILE,XLE_ENTITY_PROFILE

  322. XLE_SEARCH_LEGAL_ENTITIES->XLE_ENTITY_PROFILE

  323. XLE_SEARCH_LEGAL_REPORTING_UNITS->XLE_ETB_PROFILE

  324. ZX_MANAGE_TAXES->ZX_TAX

  325. ZX_MANAGE_TAX_REGIMES->ZX_TAX_REGIME

  326. ZX_MANAGE_TAX_STATUSES->ZX_TAX_STATUS

Please follow help provided in UI to enter attribute values for export criteria. See known issues and special consideration below for specific Setup Task.

Manage HCM Extract Definitions

To export an HCM Extract, use the PER_MANAGE_EXTRACT_DEFINITION Task Code.

image-20240607-140407.png

Export by ExtDefinitionId works but that id is not visible in FSM UI, you can upload this BIP Report and execute it to view the ExtDefinitionId values. Another option would be to manually export from FSM UI to capture ExtDefinitionId from ASM_SETUP_CSV_METADATA.xml which is part of Export zip file. Otherwise, filter on a different Attribute Name.

Payroll Flow Patterns

Export using BaseWorkflowName, plugin will automatically convert to use appropriate FlowId when you use BaseWorkflowName in export criteria.

Filter Criteria

Filter criteria are a list of rules used to filter the setup data after CSV export. This means if export criteria are configured, then filter criteria are applied to the result of that. The filter criteria are useful when the user only wants to deploy, a subset of the setup data to the target Oracle SaaS environment(s) and export criteria alone is not sufficient. It is recommended to start with export criteria first and after use filter criteria to fill any gaps if additional filtering is required by your use case. While export criteria only works for specific tasks and attributes combinations; filter criteria are configurable for any task and attribute. A couple reasons export criteria is preferred:

  1. There are known issues with Oracle’s Export API where API requests would timeout. Speculation says this is due to size limitation (default is 10MB). Export criteria will keep exported artifacts smaller and help prevent timeouts.

  2. Execution time will be much faster with Export Criteria versus exporting the entire Setup Task. Execution time on the Oracle’s side mostly depends on the number of business objects associated to the task and size of data for each.

Filter Criteria Operators

Filter criteria support a set of operators to help users achieve filtered CSV file packages. See the below for a full list below:

  1. Equals

  2. Equals (case insensitive)

  3. Not Equal

  4. Includes

  5. Includes (case insensitive)

  6. Doesn’t Include

  7. Empty

    • Empty includes column values containing empty string or white space characters only.

  8. Not Empty

    • Not Empty includes column values not containing empty string or white space characters only.

  9. Regex

    • Applies a regex expression to the column value

  10. Latest Version

    • Assuming the column contains a version number like MAJOR.MINOR.PATCH (1.0.1) or similar. This operator will find the latest or most recent version in the entire column.

    • If the attribute name (column) selected with this operator does not follow a version like format, then this operator will not behave as expected.

How is the criteria applied?

All configured rules are joined together with AND operations. For example, if 2 rules are configured for a given business object, then both rules must resolve to true to keep a row in the csv file. Logical or is not supported between rules. You can filter by multiple values in a given rule by separating the values with the delimiter ## (i.e. ClickShipCollect1##ClickShipCollect2).

Parent child relationships are maintained when any row is removed. If a row in fileA.csv is removed due to criteria and that row is referenced in fileB.csv, then all referenced rows in fileB.csv will also be removed. In other words, if the parent row is deleted/removed then all child rows from other CSV file(s) are removed. You can check if there is a parent child relationship between csv files by looking for column headers with period/dot in their name. The value before the dot is the parent file and the value after the dot is the parent column. i.e. DOO_ORCHESTRATION_PROCESS.ProcessName

Filter Criteria Examples

  • 1 rule with multivalue. Business Object → DOO_ORCHESTRATION_PROCESS

The below filter criteria means filter the DOO_ORCHESTRATION_PROCESS.csv file where ProcessName column is equal to “ClickShipCollect1” or “ClickShipCollect2”

image-20240116-180735.png

  • 2 rules same business object. Business Object → DOO_ORCHESTRATION_PROCESS, Rule 2 Attribute Name → DooProcessVersion

The below filter criteria means filter the DOO_ORCHESTRATION_PROCESS.csv file where ProcessName column is equal to “ClickShipCollect1” and DooProcessVersion column is equal to the Latest Version of the entire column. Remember Latest Version is a custom operator and the value is determined at runtime.

image-20240116-181111.png

  • 2 rules different business objects. Rule 1 Business Object → XLE_ENTITY_PROFILE, Rule 2 Business Object → XLE_LE_LEGAL_ADDRESS

The below filter criteria means filter the XLE_ENTITY_PROFILE.csv file where Name column is contains “US”. Additionally, filter the XLE_LE_LEGAL_ADDRESS.csv file where State column is equal to “WI”.

image-20240116-183229.png

With export and filter criteria it is highly suggested to avoid overlapping of file definitions between two or more Setup Task files. When two files deploy overlapping data, it will become difficult to track which package/project deployed changes and to prevent issues of deploying unwanted changes to the target SaaS environment. To guarantee no data overlap, review the CSV File Package from the csvExport and compare with other executions using the same Setup Task to confirm there are no duplicate rows.

Source from Development Environment

In order to download a CSV file package from an environment, at the minimum you must configure a file for a setup with the following steps:

  1. On the File Catalog or Package Files page click CREATE

  2. Select “Setup Task” as the Type

  3. Search for your Setup Task by task name or task code. FlexDeploy will give you suggestions as you are typing.

  4. (optional) If the task supports Export Criteria, then Export Criteria section will be shown. Configure as needed.

    • For each business object, select an attribute name and set a value. Think of the business object as a CSV file and the attribute name as a column in the CSV file. Multiple values can be filtered for by delimiting with ## (i.e. VALUE1##VALUE2). To filter by more than one attribute name in the same CSV file, click the Add button at the bottom of the business object. Naturally, if you can click the remove button to remove a filter.

  5. (optional) Configure Filter Criteria as needed.

    1. Click ADD to create a rule.

    2. Select a business object (CSV file) or type in your own if the business object you’re looking for is not in the drop down list.

    3. Select an attribute name (column) or type in your own if the attribute name you’re looking for is not in the drop down list.

    4. Select an operator from the available list.

    5. Type in the value you wish to filter by. Multiple values can be set by delimiting with ## (i.e. VALUE1##VALUE2). By design, if the selected operator does not require a value i.e empty, not empty, regex, etc…, then the value column will not display.

  6. Click Save to save your configurations. FlexDeploy will tell you the list exported CSV files which will eventually be in the exported CSV file package. Now you can add this file to a Package and perform export and import.

Note that File Name (with Path) will automatically be populated based the task and if there are any criteria defined.

image-20240111-210240.png

Source from SCM

The following convention is generally used for the File Name (with Path) in Source Code Repository. "/SetupTasks/<Task Code>.zip" for entire setup task or "/SetupTasks/<Task Name>/<Attribute Value>.zip" for a scoped setup task. If you follow these conventions, then you do not have to configure Files manually. You are ready to perform export and import using FlexDeploy package once files are discovered in FlexDeploy.

Task Code is derived from zip file sourced from SCM.

How to find Task Code for a Setup Task?

To initiate the export or import process, Oracle endpoints requires providing a code for the task. Following these instructions to find the Task Code. We are assuming you have access to FSM resource.

  1. Click Navigator > My Enterprise > Setup and Maintenance.

  2. In the Setup and Maintenance work area, click Manage Setup Content from the Tasks panel tab.

  3. To search for the code of a task

    1. On the Manage Setup Content page, click Manage Task Lists and Tasks.

    2. In the Search field, select Tasks and click Search.

    3. In the search results, click the name of the task.

    4. On the Task page, look for value that appears against Code.

    5. Copy the code and use it where necessary.

  • No labels