To interact with Oracle® Financial Data Quality Management, Enterprise Edition (FDMEE), add a step in a chain that uses an Oracle FDMEE connection command.
To enable these commands, an IT admin first creates an Oracle FDMEE connector.
Execute data rule
To execute a data rule, use an Execute data rule command. This command returns any errors in a log file.
Properties
| Property | Detail |
|---|---|
| Name | Enter the name of the data rule. |
| Import from source | Select whether to include the import step. |
| Export to target | Select whether to include the export step. |
| Execution mode | Select the execution mode. |
| Load exchange rate | For a multi-currency application, select whether to load exchange rates. |
| Start period | Enter the start period for the rule. |
| End period | Enter the end period for the rule. |
Outputs
| Output | Output Type |
|---|---|
| Process ID | String |
| ODI session number | String |
| Rule error log | Rule |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Error during execution |
| 2 | Error | Unable to authenticate |
Get balance column mappings
To retrieve a list of balance column mappings for a particular location, use a Get balance column mappings command.
Properties
| Property | Detail |
|---|---|
| Partition key | Enter the partition key for the location. In Oracle, this appears at Data Management > Setup Location. |
Outputs
| Output | Output Type |
|---|---|
| Mappings | JSON |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Error during execution |
| 2 | Error | Unable to authenticate |
Get data rules
To retrieve a list of the available data rules in a particular location, use a Get data rules command.
Properties
| Property | Detail |
|---|---|
| Partition key | Enter the partition key for the location. In Oracle, this appears at Data Management > Setup Location. |
Outputs
| Output | Output Type |
|---|---|
| Data rules | JSON |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Error during execution |
| 2 | Error | Unable to authenticate |