Page Comparison

Y, N

Toggles using streaming extracts in an environment. Please note, that this parameter was introduced in June 2016 EagleML Release. Its alternative obsolete version is w_eagleml_streaming_t which is strongly not recommended for newer environments.

formatted list of feedtypes

Sets the list of feedtypes that will utilize streaming extracts, if such exist. Default value: all feedtypes (the list may vary for different EagleML versions). Please note, that this parameter was introduced in June 2016 EagleML Release. Its alternative obsolete version is w_eagleml_streaming_t which is strongly not recommended for newer environments

N, Y (default)

If you create a custom streaming transformation step using IWS, the generated code will contain a link to core EJM file (/eagle_ml-2-0_cm/streaming_task_getinfo.inc). After publish if you drop any file into this process, the code inside core include file will overwrite the original incoming file name by simple CorrId value and cause errors.
This parameter by default has Y (or empty) value – in this case original file name will be kept in the TSR. If set to N – then only CorrID value will be in the processed file name in TSR.

Y, N

Generates an empty extraction file in case you get NO_DATA. Its task parameter version for RTR is ForceExtractFileCreation

Y, N

Toggle extract file compression (zip/gz archive). 

Y, N

Extraction with 'compress' parameter. 

Y, N

Entity Accounting Periods extract option. If W_AUTOADDBASIS = Y the extract will contain <autoAddBasis>Y</autoAddBasis> node. If such extracted file is sent for load afterwards, the inbound rule will load a new Accounting Basis (a row in RULESDBO.ENTITY_ACCT_BASIS) if it cannot find the Account Basis set in the inbound rule for the Portfolio Acct (Entity Id) in DB.
This option is especially useful for ETL processes in which the extract is sent for load at once. 

Y or empty (default)

Exclude Security Alias from all extracts.

Y or empty (default)

Enable adding Security Alias for Warehouse extracts. Has a higher priority than EXCLUDE_SECURITY_ALIAS for Warehouse objects.

N (default), Y, ALL

A setting for extracts with Entity fields (such as Entity Id, Name, Xref etc).
N: The following fileds are extracted: Entity Id, Entity Name, Entity Type, Xref Account Id, Xref Account Id Type, Xref Class Code
Y: These fields are extracted along with ones above: Long Entity Name, Legal Entity Name, Total Count Share Class, Partition Number
ALL: Physical Partition fields are extracted along with all fields above: PPTRADES, PPHOLDING, PPCASH, PPPERFORM, PPLEDGER
See a more detailed description of these fields. 

Y (default), N

This parameter works for all EagleML objects with Entity fields except for Warehouse. 

If set to Y, all Entity Xref identifiers existing in DB for the Entity Id are extracted.

If set to N, only one set of Entity Xref identifiers is extracted.

See a more detailed description of these fields.

N (default), Y

When set to Y, numeration is added for entity and security xref elements:

<entityXrefs>
	<entityXref1>
		<xrefAccountId>BT3903IU_TYPE2</xrefAccountId>
		<xrefAccountIdType>TST</xrefAccountIdType>
	</entityXref1>
	<entityXref2>
		<xrefAccountId>BT3903IU_TYPE3</xrefAccountId>
		<xrefAccountIdType>TST</xrefAccountIdType>
	</entityXref2>
</entityXrefs>

This can also be applied to a single extract by using task parameter UseNumerationForXrefs.

N (default), Y

If set to Y, the following fields are added to the extract inside the <navReportDetails> complex node.

• Prior NAV (NAV for the previous Valuation Date), 

• Mkt Value Cash (elements from the Position Detail table in case Base Currency = Local Currency or sum of elements in case Base Currency != Local Currency), 

• Share Class Level (elements of ARCH_CTRLCTR.NAV_DETAILS table linked with main table via Valuation Date, Entity Id, Share Class), 

• Total Fund Level (elements of  ARCH_CTRLCTR.NAV_DETAILS сtable linked with main table via Valuation Date, Entity Id for Share Class = 'TF')

• Distribution Log Level

Works only with WRHSNAVMONTHENDEXTRACT feedtype

Alternative for a single extract event is the RTR parameter includeReportDetails

N (default), Y

If set to Y, the following fields are added to the extract inside the <navReportDetails> complex node.

• Prior NAV (NAV for the previous Valuation Date), 

• Mkt Value Cash (elements from the Position Detail table in case Base Currency = Local Currency or sum of elements in case Base Currency != Local Currency), 

• Share Class Level (elements of ARCH_CTRLCTR.NAV_DETAILS table linked with main table via Valuation Date, Entity Id, Share Class), 

• Total Fund Level (elements of  ARCH_CTRLCTR.NAV_DETAILS сtable linked with main table via Valuation Date, Entity Id for Share Class = 'TF')

• Distribution Log Level

Works only with WRHSNAVMULTIEXTRACT feedtype

Alternative for a single extract event is the RTR parameter includeCustomReportDetails

N (default), Y

If set to Y, the Asset Properties model is added to the extract. 

N (default), Y

Setting to Y adds singleLegLoadFlag = Y element to all SMFEXTRACT. RTR parameter version is SetSingleLegLoadFlagValue

QueryProfileName

Applies an element reduction profile to all extracts of the feedtype.

N (default), Y

Toggles removing numeric fields with zero values from the extract to decrease its volume. Valid only for Warehouse objects. Supported with regular extracts as well as with the Generic Extract workflow. Please note, that this parameter was introduced in June 2016 EagleML Release. Its alternative obsolete version is EXTRACTS_EXCLUDE_0 which is strongly not recommended for newer environments

parameters declared in specific format

Enables date rules for extracts. One of the parameters is the username you use in the environment. 

password

Example before encryption:

<COL TAG="wa_DateRulePass" EXPRESSION="'eaglepassword'"/>

Example after encryption:

<COL TAG="wa_DateRulePass" EXPRESSION="'base64aes~esC4Vn7jf6jjf0/SXstfjdw46mufgl0k/t'" ENCRYPTED="YES"/>

The password for the user name in the environment you specified in wa_DateRule parameter. Encryption is mandatory. 

N (default), Y

Enables/disables extraction of duplicate entities for entityselectiontype = ENTITYID filter. You do not get duplicate entities if set to 'Y'.

N (default), Y

Switch to Y, if you want to use XREF and LEI tables to filter records by update_date. E.g., you have an entity with update date 1/1/2012 with a linked XREF of 1/1/2014. Using update date filter by 1/1/2013 with W_ENTITY_UPDATE_DEEP option will return. 

 
 
ALWAYS (default), NEVER, ONLY_DATA_EXTRACTED

This parameter works only with delta-based extracts. 
 
ALWAYS - always rewrite the last run date value after delta-based extraction
NEVER - switches off rewriting last run date
ONLY_DATA_EXTRACTED - change last run date only if some data has been extracted

N (default), Y

This parameter works only with ReportDictionary extracts. If this parameter is set to Y, then whenever we do a delta based dictionary extract, we should only look at SECURITY_DICTIONARY_LINK.SECURITY_DATE to determine the linked assets (and their corresponding dict detail) records to extract. There is no need to check dict detail update_date for delta based dictionary extracts in the selection criteria if that flag is set to Y. Available as an RTR task parameter.

N (default), Y

A parameter exclusively for Warehouse Position extracts. Forces taking the value for baseCurrency from HOLDINGDBO.POSITION_DETAIL.BASE_CURRENCY instead of HOLDINGDBO.POSITION.BASE_CURRENCY field. Also available as a task parameter in the RTR TakeBaseCurrencyFromWRHSPosDet

Y(default), N

By default, businessTaskId element (inside taskIdentifier root node, next to the correlationId node) is extracted. Setting W_ADD_BUSINESSTASKID_EXTRACTS to N removes businessTaskId from the extract. This parameter is available since July 2017 EagleML release

formatted list of feedtypes
 

Adds a commonTransactionsInformation model with values of dates you have used in your Date filter (please note, that not all date filters are supported by your specific feedtype, refer to the table for date filters). Available as an RTR task parameter - IncludeCommonTransactionsInfo

N (default), Y

Setting to Y adds extractStats model to TSRs for all extracts on the region. Currently supported for the following interfaces: Schedule, GenericSMF, WarehouseCashActivity, WarehouseCashFlowProjection, WarehouseCloseLot, CustodyRestrictionActivity, CustodyRestrictionBalance, WarehouseDisclosureStatus, WarehouseGLBalances, WarehouseNAVMonthEnd, WarehouseNAVMulti, WarehouseNAV, WarehouseOpenLot, WarehousePendingTrade, WarehousePerformance, WarehousePosition, WarehouseTrade, WarehouseWashSaleTrade

number

Sets the amount of records per batch.

Task parameter version is MicroBatchKeyRecordCount

Y(default), N

When set to N removes query file *_Q.txt during extract process.

N (default), Y

When set to Y deletes tag value *.dat file during extract process.

Works only with WRHSTRADEEXTRACT

Setting to Y enables S2P remaping for the following fields:
'secFee' is mapped into 'otherFee'
'secFeesBase' is mapped into 'otherFeeBase'
'exchangeFee' is mapped into 'secFee'
'exchangeFeeBase' is mapped into 'secFeeBase'
'otherFee' is mapped into 'exchangeFee'
'otherFeeBase' is mapped into 'exchangeFeeBase'.

RTR parameter is EnableS2PReMappingFlag

Y(default), N

Setting to N disables the rollback in xmldbapi format.

Works with WRHSOPENLOTEXTRACT and WRHSPOSITIONEXTRACT.

Y(default), N

Setting to N removes the Batch key added to Warehouse extracts in delta mode. 

RTR analog is BatchMode = N

Y(default), N

Setting to Y allows bringing back pricing records only when the price validation rule has an Active status. The alternative for a single extract is pricingactiveflag RTR parameter.

DAILY(default), MONTHLY

Setting to MONTHLY allows to extract pricing data from ESTAR.MONTHLY_PORTFOLIO_VALUATION table. The alternative for a single extract is pricingactiveflag RTR parameter.

Delivery Methods

FILE_IN_LOCATION












FILE_EXTRACT_LOCATION












FILE_REPLY_LOCATION












FILE_ACK_LOCATION

Please refer to Configure Delivery Method Options page for a complete guide.

FTP_URL
FTP_USER
FTP_PWD
FTP_FILES_LOCATION
FTP_EXTRACT_LOCATION
FTP_REPLY_LOCATION
FTP_ACK_LOCATION

SFTP_URL
SFTP_USER
SFTP_PWD
SFTP_PWD_ISENCRYPTED
​SFTP_FILES_LOCATION
SFTP_EXTRACT_LOCATION
SFTP_REPLY_LOCATION
SFTP_ACK_LOCATION

W_JMS_DEF_ACK_STREAM












W_JMS_DEF_REPLY_STREAM












W_JMS_DEF_EXTRACT_STREAM

W_SMTPSERVERW_SMTPPORT












W_SENDMAILFROM












W_SENDMAILTO W_EMAIL_DEF_ACK_STREAM












W_EMAIL_DEF_REPLY_STREAM












W_EMAIL_DEF_EXTRACT_STREAM












W_EMAIL_DEF_ALERT_STREAM

W_MQS_DEF_ACK_STREAM












W_MQS_DEF_REPLY_STREAM












W_MQS_DEF_EXTRACT_STREAM

formatted value (more details here)

A number of objects to be purged or archived and the parameters of the process in the appropriate format. 

Y (default), N

Toggle Purge and Archive logging. Available as an RTR task parameter - loggingEnabled.

file path

File path for purge and archive log file.

LISTONLY or STANDARD

Set purge and archive mode. See more details on this page. 

list of folders and time intervals

List of ftp folders to be cleaned up and purge intervals for them.

MOVE, DELETE

Cleanup mode: either MOVE or DELETE. If set to MOVE the Advanced Configuration Options#W_CONFIG_FTP_CLEANUP_MOVE_FOLDER variable must be specified.

folder path

The folder used in the ftp cleanup process.

folders and time intervals

List of app folders for cleanup and purge intervals for them. 

MOVE, DELETE

Cleanup mode: either MOVE or DELETE. If set to MOVE the W_CONFIG_APP_CLEANUP_MOVE_FOLDER variable must be specified.

folder path

The folder used in the app cleanup process.

N/OFF (default), Y/ON, ONonlyForIWS, ONuseExactFileName

Works with IWS workflows

• N or OFF - TSR/ASK messages are named by default.

• Y or ON - TSR/ASK messages are named as defined in the IWS solution.

• ONonlyForIWS - If the solution was created via IWS, the TSR/ASK messages are named as defined in the solution. If not defined - default names are assigned.

• ONuseExactFileName - excludes correlationID prefix from the file name when you use ACKStrictPattern or TSRStrictPattern parameters. Read more in EJM Job Notification Overview
  Please note, that this option should be handled with care, because in case different processes get the same file patterns, files will be rewritten by the latter process.

You will find more details in the Setting Custom TSR/ACK Names tutorial on IWS wiki.

N/OFF (default), Y/ON, ONonlyForIWS

Works with IWS workflows

• Y or ON – TSR messages will be saved in ../cmw/reply/workflowname and ACK messages in ../cmw/ack/workflowname. 

• N or OFF – TSR and ACK use default folders as their location.

• ONonlyForIWS – Only IWS created solutions will use custom folders as their location.

CustomReplyLocation and CustomAckLocation parameters override this parameter.

Read more in the Setting Custom TSR/ACK Locations tutorial on IWS wiki.

0, 1

Toggle moving result ZIP file to FTP. 

0, 1

Toggle using an additional subprocess (dp_log insert) within Generic Load.

XMLDBAPI (default),
EagleML

Defines the format of Warehouse Position and Warehouse Open Lot extracts.

N (default), Y

workflow name

time in seconds

These three parameters allow to enable and control CacheValidation sub-process prior to the extract step. 

• EnableValidateCache (RTR) and global parameter W_ENABLE_VALIDATE_CACHE to enable the step prior to extract

• CacheValidationWorkflow (RTR) and global parameter W_CACHE_VALIDATION_WORKFLOW which specifies the Name of the workflow which will be triggered via the sub-process

• CacheReloadPeriod (RTR) and global parameter W_CACHE_RELOAD_PERIOD which controls how often cache validation will run. The established setup time is in seconds.

batting order

Specify a batting order for all workflows that differs from the default

xref map

Specify xref transformations that should occur for all files

security resolution option

Specify security resolution options that are different from default for an entire box (meaning, for all workflows, streams and other processes)

Read more about security resolution..

batting order

Set a custom batting order for all extracts in the environment.

xref map

Set a custom xref map for all extracts in the environment.

security resolution option

Set a custom security resolution option for all extracts in the environment.

custom type

Available for Warehouse Position and Warehouse Open Lot. Provides an option to force custom primaryAssetIdType in the extract.

Y (default), N

Toggles using specific SWAP security resolution logic.

ALLOW_DUPL_XREF

Setting this parameter to ALLOW_DUPL_XREF turns off the logic excluding xref duplicates.

Can be used for a single message by adding the following element to it: 

<assetResolutionOption>ALLOW_DUPL_XREF</assetResolutionOption>

Y (default), N

For Accounting CA only.

By default the message is not failed if tag 302 is not resolved and throws only a WARNING.

If tag 302 is not resolved, you can choose to fail such messages by setting either:

• global variable W_GENERICCA_IGNORE_EDITCHECK302 with the value ‘N’ or

• element referenceTransaction/header/processingOptions with the value ‘USE_TOASSET_CHECK’ 

N(default), Y

For IssuePrice, ExchangePrice and IssuePcPrice.

By default SWAP resolution for prices has specific logic based on Processing Security Type and only one leg could be priced.

The flag allows to switch on SWAP resolution based on xreferences, ignoring PST.

This mode can be enabled for a single message by setting element referenceTransaction/header/processingOptions with the value 'PRICE_RESOLVE_SW_BY_XREF'

W_SKIP_DELISTED_SECURITY

N(default), Y

Indicates that delisted security will be skipped or not.

W_DELISTED_SECURITY_IDENTIFIER_TYPES

Default value: REUTERS

Xreference identifier types separated by comma or 'ALL’ (which indicates that all xref identifier types will be checked).

W_DELISTED_SECURITY_TOKENS

Default value: ^

Tokens are used to indicate that a security is delisted. List of tokens separated by comma.

N(default), Y

Setting to Y makes the interface use not only the first entity cross reference in the incoming data, but all xrefs instead to resolve the entity.

Can be especially useful for Warehouse and Accounting interfaces which have full entity resolution switched off for compatibility reasons.

batting order

Entity Batting Order determines which entity xreference identifiers are used in the security resolution and their order for matching.

entity resolution option:

RESOLVE_ENTITY_BY_XREFS,
SKIP_INCOMING_ENTITY_ID 

RESOLVE_ENTITY_BY_XREFS switches on entity xref resolution even if the entity id is defined. This mode can be enabled for a single message by setting <entityResolutionOption>RESOLVE_ENTITY_BY_XREFS</entityResolutionOption> in the incoming message.

SKIP_INCOMING_ENTITY_ID allows to skip incoming entity id value and to generate entity id if it was not resolved. This mode can be enabled for a single message by setting <entityResolutionOption>SKIP_INCOMING_ENTITY_ID </entityResolutionOption> in the incoming message.

xref map

Sets a custom entity xref map for all loads in the environment.

entity load xref options

Sets entity xref options for load.

partition mapping

Sets partition mapping for Generic Entity.

Y (default), N

By default any number of identifiers can be loaded in the <xrefIdentifiers> complex node. Switch to N to return to old logic, limiting this number by 10.

string value

Set to Y to ignore identifiers with empty id values specified in the <xrefIdentifiers> section. Read more on this page.

W_DUP_XREF_CHECK

Y, N (default)

Set to Y to check and skip duplicate identifiers in current message. Available only with W_USEDYNAMIC_FOR_XREF flag enabled

JMS,MQ,EMAIL

Specify the delivery method for which task reporter should be enabled. RTR analog is CollectDistributionErrors.

number

Sets the number of retries for JMS delivery. Default value is 10.

time in seconds

Sets the wait time between retry attempts. Default value is 1 second.

number

Sets the number of retries when the file is sent.

time in seconds

Task reported checks the size of received files,
- for FILE - once in 5 seconds
- for FTP/SFTP - once in 20 seconds

By default, if file size remains the same between two checks, the file is taken into further processing.

You can make the process perform size checks for an extended time to make sure the file was fully delivered. Default value is 300 seconds. Read more

N (default), Y

Y value sets the timeout for curl command execution to 30 minutes (1800s).

folder path

The folder where workflow profiles will be stored (default value is ../estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm_profiles).

clientId, default value is EAGLE

Client information added to alerts. Can be used to identify the environment sending alerts and to provide more details about it.

:W_EAS_MAIL_LIST:+ list of emails

Add emails to the default list (:W_EAS_MAIL_LIST: in w_config.inc) to receive EAS alerts.

Patterns separated by ! sign

A filter for EAS alerts. Alerts matching a pattern will be delivered, others will be ignored.

email

The sender email in the message. Set by default in w_config.

name of environment

This parameter is usually resolved automatically in the get_enviroment_name.inc include. But you can set it manually.

Y or N

Enables/disables monitoring stream

number

Adjust the output of debug messages in the status. Default value is 1, increase it to reduce the amount of debug messages.

time in milliseconds

Sets a timeout at the end of the health check cycle to let the workflow return to normal status and avoid false errors. Recommended value is 600, but should be adjusted for a particular environment.

formatted value

This parameter contains delivery methods, separated by “!”. For each delivery method you can (optionally) specify methods for Control Messages. The attempt to send Control Message(s) will take place after trying to write and read a file using the specified method.

Delivery method is separated from optional parameters by “:”. Optional parameters are separated by “,”. At least one method for Control Messages should be specified for each Delivery method.

The example gives the following instructions: read/write through FILE method, then try to send EXTRACT and WORKFLOW Control Messages, then check read/write for FTP and FTP_CURL. If there is an instruction to send Control Messages, the results will be checked after a timeout. In case the Control Message returns an error or does not return any results, alert will be generated and sent according to the configuration. 

Available delivery methods:
•       FILE
•       FTP 
•       FTP_CURL
•       SFTP_CURL

Available commands for them:
•       EXTRACT
•       WORKFLOW
•       PACE_EVENT
•       STAR_EVENT
•       LOAD 

formatted value

Settings for an RTR job.

time in seconds

Defines the timeout between steps since the last message processed (or queued if W_LAST_SEQUENCE is empty).

:w_mcdata_dir: + folder name

Sets the processing folder for Sequencer. Default is out/TAGVALUE/eagle_ml-2-0_default_cm_sequencer/incoming/ 

number

Number of file masks fed to the nuggetizer. 

W_NGTZR_DIST_FOLDER

folder path

eagle_ml-2-0_default_cm_disribute_to_nuggetizer (if involved into the workflow) puts files into this folder and eagle_ml-2-0_default_cm_nuggetizer can then use these files.

W_NGTZR_MASK1

file mask

Expected file mask.

W_NGTZR_MASK1_OUT

file mask

The file mask for outgoing nuggets.

W_NGTZR_MASK1_SIZE

number

The number of files matching W_NGTZR_MASK1, 'glued' into one nugget.

W_NGTZR_MASK1_WAIT

time in seconds

The timout for nugget creation (the nugget is not considered complete till this time runs out). 

W_NGTZR_MASK1_FORMAT

EagleML

File formatting. (Currently only EagleML available).

W_NGTZR_MASK1_WKFL

workflow name

The workflow to which created nuggets are sent for further processing. 

W_NGTZR_MASK1_LOADFROMDIR

folder path

The folder in which nuggetizer looks for files matching W_NGTZR_MASK1.

Other masks are configured in a similar way (see the example).

0, 1

Toggle skipping the load step (generic_load) within generic_load_enrichment workflow.

0, 1

Toggle skipping RDC call (PACE job) within generic_load_enrichment workflow. 

Y, N

Toggle monitoring stream usage.

Y, N

Toggle monitoring sch stream usage - monitoring_sch stream is used to launch monitoring for a separate process.

stream name

Name of the monitoring stream.

process id

Process id for your monitoring stream. 

application id

New application id for your monitoring stream.

application id

Old application id for your monitoring stream. W_MONITOR_CUR_APP_ID will be replaced with W_MONITOR_APP_ID in the system.

formatted list

List of streams and folders to be monitored.

Y, N

CM_EA_FTP_READER is an alternative for the FTP stream, its main feature is that it takes the list of files from DB sitesee instead of calling FTP
It is commonly used to avoid the FTP plugin issue - too frequent FTP pulling.

time in seconds

Maximum status check timeout. Can be set as a task parameter ExecutionMonitoringTimeout for a single process.

time in seconds

Time interval between status checks. Can be set as a task parameter ExecutionMonitoringPeriod for a single process.

TNS

TNS (server alias) for SiteSee.

user name

Setting user name for SiteSee.

password

Enter the password for SiteSee (encrypted). When you set a new password restart MC to apply changes.

folder path

Specifies the folder for SiteSee FTP Reader. Standard setting is CMW/control

time in seconds

Sets the timeout for SiteSee FTP Reader.

file path

Set custom XSD validation file location. 

file path

Set custom schema location. 

YES or empty

Defines if an environment is set as Spoke in an I2I process.

YES or empty

Defines if an environment is set as Hub in an I2I process.

Y or empty

Toggle loading SMF into the history table (equal to forcing <historyOnlyFlag>=Y) within an I2I process, when the data is extracted from the composite table of Hub and then loaded into the history table of Spoke. 

Y, N

If set to Y, this parameter forces all Warehouse Trade extracts on the box to have the updatetype of I. 

This option is also available as a Task Parameter in the control message (especially useful, when you do not want to apply this updatetype to all Warehouse Trade extracts on the box). Task parameter version for RTR is ForceWRHSTradeIns

N (default), Y

This parameter affects Warehouse Performance - Delta Mode only. Allows to load Warehouse Performance even in case STATUS_FLAG is already set as F(FINAL). 

Y(default), N

When set to N, extracts in delta mode do not use orchestration. 

Configure the FTP for I2I

Some parameters are noted as Required - this is only in case you want to use FTP delivery method

ftp url

FTP URL. Required

password

FTP Password (It can be either encrypted or not - we recommend that you encrypt your password). Required

YES or NO (default)

YES – password is encrypted. NO or NULL if not encrypted. Optional.

user name

FTP User Name. Required

folder path

Folder for archive on FTP. Default value is 'CMW/inbound/'. Optional

folder path

Required when the workflow is launched remotely (Extract or Load). If you want TSR to be loaded on FTP.

folder path

Required when the workflow is launched locally (Extract or Load). If you want RTR to be loaded on FTP.

Configure the Web Service for I2I

Some parameters are noted as Required - this is only in case you want to use Web Service delivery method

WS url

WS URL. Required

password

WS password. Required

user name

WS user name. Required

number (integer)

WS number of retries. Optional

I2I Filters

I2I workflow parameters

This is the MAIN parameter in configuration, which defines the way TSRs/RTRs are sent to the other side of the I2I process.

YES or NO (default)

If this parameter set to YES, extracted data will be base64-encoded and wrapped into RTR/TSR

Y (default), N

Available since May 2016 EagleML Release. Toggles displaying details for successful substeps. Switched off ("Y") by default. Read more... 

N (default), Y

Setting to Y enables Event Entity Details for STAR events and for DataMart Model Manager steps in the final TSR for PACE jobs - these are available since May 2016 EagleML Release for PACE and since September 2016 EagleML Release for STAR. In addition, includes execution details for STAR (available since October 2016 EagleML Release). Read more... 

N (default), Y

Enable support for Pace Jobs with incoming parameters.

N (default), Y

Enable security-level details for failed TSR for RDC Composites. 

stream name

Data delivery stream for TBA workflow. 

N (default), Y

If value is set to Y the last step of each relevant workflow will start the next one automatically. 

number, default is 5

Defines the number of retry attempts. 

time in seconds, default is 1

Defines the timeout between attempts. Read more.. 

number, default is 5

Defines the number of retry attempts. 

time in seconds, default is 1

Defines the timeout between attempts. Read more.. 

NG, CUSTOM, CORE

For some Warehouse objects, such as Warehouse Month End, this parameter allows:
•    NG – to use common NG XSLT – 1 for all NG SP
•    CUSTOM – for warehouse objects this allows to use custom xslt for each data type object like: wrh_pos_cust.xsl
•    CORE- to use CORE XSLT and SP.
This value can also be set within the Warehouse message itself - in the procedureSwitch node

list of feedtypes

Defines the list of feedtypes for which NG logic is enabled

schema name

Custom NG schema name. Default value is core schema name

package name

Custom NG package name. Default value is core package name + _NG

SP name

Custom NG SP name. Default value is core SP name + _NG

custom TSR strict pattern

Please refer to this page to learn more about configuring EJM Notification Filenames.

custom ACK strict pattern

custom TSR name pattern

user ID

UserId for the encryption process of GPG. 

GPG,PGP,NONE

Set encryption mode.

GPG Decryption

Y (default), N

By default automatic detection of encrypted files for both unpacker and ndfa streams is enabled. This flag has a higher priority than W_NDFA_INCOMING_ENCRYPTED

EXTENSION BASED (default), ALL

By default, the ndfa automatically detects encrypted files by their extension. ALL value enables 

pass phrase

Pass phrase for the decryption process.

GPG,PGP

Set decryption mode.

Y (default), N

Setting to Y makes the process store wait event info in orch_request_params table.

W_GLOBAL_ERROR_QUEUE_CLEANUP_PERIOD

time in days

Sets the cleanup period for global error queue in days.

W_WORKFLOW_SPECIFIC_ERROR_QUEUE_CLEANUP_PERIOD

time in days

Sets the cleanup period for workflow specific error queue in days.

W_WORKFLOW_SPECIFIC_WAITING_QUEUE_CLEANUP_PERIOD

time in days

Sets the cleanup period for workflow specific waiting queue in days.

W_GLOBAL_ERROR_QUEUE_ORCH_INSTANCE

instance number

Sets the value of ORCH_INSTANCE for global error queue.

W_WORKFLOW_SPECIFIC_WAIT_QUEUE_ORCH_INSTANCE

instance number

Sets the value of ORCH_INSTANCE for workflow specific waiting queue.

W_WORKFLOW_SPECIFIC_ERROR_QUEUE_ORCH_INSTANCE

instance number

Sets the value of ORCH_INSTANCE for workflow specific error queue.

w_mc2_http_retry_count

time in seconds

N (default), Y

Setting to Y disables the execution of update_tasks_statistics.inc logic globally. Alternative to apply it to a single process is DisableTaskStatisticsUpdate RTR parameter.

Y (default), N

Disable single commit scope mode when loading Schedule, Variable Rate and Earnings in batch mode (when loading via the _mi stream). 

N (default), Y

Disable single commit scope mode when loading Schedule, Variable Rate and Earnings in batch mode (when loading via the _mi stream). 

N (default), Y

Ignore POS_FLAG field in POSITION flag during load. Available since February 2017 EagleML release.

Y (default), N

Setting to N disables validation for SQL injection.

N (default), Y

Global analog of noLoadValidationFlag element for Reference objects.

N (default), Y

Setting to Y turns off validation of fields during the load of Underlying SMF shell records created for Underlying from the SMF .

Effect is close to noLoadValidationFlag, but works only for Underlying.

N (default), Y

Setting to Y allows to delete the underlying record by key and reinsert a new incoming one. RTR analog is underlyingDeleteReinsertSwitch.

N (default), Y