Table of Contents

Connections

Commands

Connections

Oracle FDMEE

Oracle FDMEE connector via username authentication to the Web Services.

Inputs

Input

Type

Detail

Notes

Web Service URL

TextField

The full URL for your Oracle FDMEE Web Service (i.e. http://localhost:28080/oracle-epm-erpi-webservices/RuleService)

Username

TextField

The username to connect with

Password

TextField

The password for the user

Commands

Execute Data Rule

Execute a data rule. Errors will be returned if a log file if there are any.

Inputs

Input

Type

Detail

Notes

Name

TextField

The name of the data rule

Import from Source

DropdownField

Whether or not to include the import step

Export to Target

DropdownField

Whether or not to include the export step

Execution Mode

DropdownField

The execution mode

Load Exchange Rate

DropdownField

Whether or not to load the exchange rates. This parameter can be used only in case of multi-currency applications.

Start Period

TextField

The start period for the rul

End Period

TextField

The end period for the rule

Outputs

Output

Output Type

Notes

Process ID

String

ODI Session Number

String

Rule Error Log

File

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error during execution

2

Error

Unable to authenticate

Get Balance Column Mappings

Get a list of balance column mappings for a particular location

Inputs

Input

Type

Detail

Notes

Partition Key

NumberField

The partition key for the location. You can find this in Data Management -> Setup -> Location

Outputs

Output

Output Type

Notes

Mappings

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error during execution

2

Error

Unable to authenticate

Get Data Rules

Returns a list of the available data rules for the user in a particular location

Inputs

Input

Type

Detail

Notes

Partition Key

NumberField

The partition key for the location. You can find this in Data Management -> Setup -> Location

Outputs

Output

Output Type

Notes

Data Rules

Json

Exit Codes

Code

Type

Detail

0

Success

Success

1

Error

There was an error during execution

2

Error

Unable to authenticate

Did this answer your question?