1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Working with Data Objects and the Data Chain
  4. Understanding Bindings and Bound Data Objects
  5. Inspecting and Editing a Binding
  6. Editing Binding Keys

Editing Binding Keys

Binding keys are created during application registration to control the binding rules and the import and export constraints on a binding for a dimension. You can edit the binding keys to change the direction (for example, to specify that a binding key is valid for exports only) and the column order in your export file.

Note:

The binding keys for Oracle Financials Cloud General Ledger applications are view-only. You cannot edit the column order or direction in the export file for these applications.

To edit the binding keys:

  1. Inspect the binding that you want to edit the keys for. See Inspecting and Editing a Binding.
  2. Click the Keys tab. The following information is displayed for the binding keys:
    Field Definition
    Header The column headers in the import and export files for all application types except for Oracle Financials Cloud General Ledger applications (which do not have column headers in their import and export files).
    Key Determines what type of information the binding key contains. For example, the PARENT key contains the parent for a node, and the VALIDCONSOL key contains information on whether or not the node is valid for consolidations.
    Sub Key Works with the Key to determine the type of information the binding key contains. For example, for the key ALIAS, the sub key DEFAULT contains the default alias table for a node, and the sub key ENGLISH contains the English alias table.
    Key Type The usage for the key:
    • Property: contains information about a node property.
    • Constant: contains a value for a constant.
    • Editable Constant: contains a value for a constant in a Oracle Financials Cloud General Ledger application that can be edited during application registration or on the Settings tab of the binding inspector. See Editing Binding Settings in Inspecting and Editing a Binding.
    • Node Type: identifies the column for the node type and the parent node type in a Universal application if you have selected Use Node Type Column or Use Parent Node Type Column. See User Defined Dimension Import and Export Settings.
    Source Value
    • For property key types, contains the fully-qualified property name.
    • For constant and editable constant key types, contains the constant value.
    Direction Determines the importing and exporting of the binding key:
    • Import: binding key is not processed during exports.
    • Export: binding key is not processed during imports.
    • Both: binding key is processed during imports and exports.
    • None: binding key is not processed during either imports or exports. Select this option if a bound property in Oracle Enterprise Data Management Cloud is not needed in your external application.

    Note:

    Constant and Editable Constant binding keys can be set to Export or None only.
    Action Enables you to move the column order for the key up or down in the export file, or to delete the key for constant columns in Universal applications.
  3. Optional: To change the direction for a binding key:
    1. Click Edit.
    2. In the Direction column for a binding key, select whether the binding key should be processed for exports, imports, both, or neither.
  4. Optional: To change the column order for your export file:
    1. Click Edit.
    2. In the Actions column, click actions, and then select an option to move the binding key up, down, first, or last in the file.
  5. Optional: To delete a binding key:
    1. Click Edit.
    2. In the Actions column, click actions, and then select Delete.
  6. Click Save.

Managing Constant Keys for Universal Applications

For Universal applications only, you can create, edit, move, and delete constant keys:

  1. Inspect the binding that you want to manage a constant key for.
  2. Click Edit.
  3. Perform an action:
    • To add a constant key, click Create, and then enter a header, source value, and direction.
    • To edit a constant key, modify the header, source value, or direction of a constant key.
    • To move a constant key, in the Actions column click select, and then select an option to move the column up or down in the export file.
    • To delete a constant key, in the Actions column click select, and then select Delete.
  4. Click Save.

Note:

By default, when you create a constant key for a Universal application it is sorted to the end of the export file.