Configure Tasks in the Process Flow

Datastore Name

Refers to the name of the Information Domain.

By default, the Information Domain to which you are connected is selected.

DQ Group Name

Select the required DQ Group.

Rejection Threshold

Enter the maximum errors in absolute value that a Data File can have and the Data Load will be marked successful. This is part of the specifying properties for load to table option

Once the erroneous record count exceeds the Rejection Threshold value, the data loading task will fail and the inserted values will be rolled back for that table.

Inserts for the previous tables won't be reverted.

Rejection Threshold will be applied to each of the target table individually in a batch.

By default, the value is set as UNLIMITED.

If you set Rejection Threshold as UNLIMITED or blank, the whole Data file will be loaded irrespective of the number of errors.

Additional Parameters

Enter any additional parameters for the Run DQ Rule filtering criteria for execution in the pattern:

Key#Data type#Value; Key#Data type#Value; and so on.

NOTE: In case the Additional Parameters are not specified, the default value is taken as NULL. Except the standard place holders $MISDATE and $RUNSKEY, all additional parameters for DQ execution should be mentioned in single quotes.

For example, STG_EMPLOYEE.EMP_CODE = '$EMPCODE'.

Fail if Threshold Breaches

Enter Yes to mark execution of the task to fail if the threshold value is breached. Enter No to continue execution of the task if the threshold value is breached.

Rule Exec Connection

Enter Connection Details for the Rule Execution such as the IP address and port.

Result Store Connection

Enter Connection Details for the server where the result will be stored such as the IP address and port.

Batch on Fail

?

Micro service Id

Enter the Micro Service ID

Datastore Name

Refers to the name of the Information Domain.

By default, the Information Domain to which you are connected is selected.

Name

Select the required dimension table name.

Dimension Retire

Select the dimension that you want to overwrite.

Execution Venue

Enter name of the Execution Venue. This field is case-sensitive and does not allow duplication.

For example, logical name “R_DF” is not allowed if a name “R_DF” exists.

Ensure that there are no special characters such as `, {,},”, ‘, ~, <,>, /, \, and multiple spaces.

Effective Date

Enter the start date from when the data is valid.

Entity

Enter the table name in which the hierarchy data is stored.

Hierarchy Codes

Specify the hierarchy codes separated by tilde “~” or caret “^” to resave only those hierarchies. Specify the hierarchy codes separated by exclamation mark “!” to exclude those hierarchies from resaving.

Load type

Enter the Load Type:

·        S - Complete/Full Snapshot

·        I - Incremental Snapshot

Connector Name

Select the required Dimension Columns from the drop-down. The selected dimension column loads the data as mapped in the staging tables of the ledger into AFCS.

Variables

Enter the required variables.

Variables

Enter the required variables.

DataService Name

Select the required Data Service from the drop-down.

Subledger Application

Select the required Subledger Application from the drop-down.

Extract Type

Select the required BICC extract type to load from the options in the drop-down.

Oracle Business Intelligence Cloud Connector (BICC) extracts business intelligence and other data in bulk and loads it into designated external storage areas.

Adjustment Rule

Enter the Adjustment Rule name.

Exchange Rates Rule

Enter the exchange rates rule to apply to the transaction or set of data.

The rule computes the rate to convert the value from one currency to another.

DQ Reporting Rule

Enter the DQ Reporting Rule that you wish to use for validation of the data.

Rule Name

Enter the Rule Name that you want the use to reconcile the transactions and statements generated.

Process Type

Enter the required process type.

For example, Run Pipeline

GL Type

Enter the required General Ledger Type to consider during Balance Computation.

Comments

Enter a description for the amount balance.