1. User Defined Fields User Guide
  2. Text Field
  3. Derivation Rule

2.5.4 Derivation Rule

Check against the option 'Derivation Allowed' if you want to the values of a UDF to be populated based on certain conditions. According to the requirements of the bank, the implementer of Oracle Banking Trade Finance will write a PL/SQL code to populate the values of the user defined field. The values of the UDF will be displayed in the 'User Defined Field/ Field Name to Value Definition' screens of Contract Input or Function Id screen.

Click 'Derivation' button to write the PL/SQL code.

After writing the PL/SQL code, click 'X' button to execute the code. The derivation code will be validated by the system. If any checks fail, you must alter the statement so that the validation can be made successfully. Click 'E' button to view the errors.

For example, the bank wants to have a new field to display the Euro equivalent of the contract amount in the 'User Defined Field' screen of Contract Input screen. To do this, you need to:
  • Define a field of type 'Number',
  • Specify 'Usage Allowed' as 'Product',
  • Check against 'Derivation Allowed', and
  • Write a code to display the Euro equivalent of the contract amount.
Subsequently, you will link the UDF to a product and process transactions under it. In the 'User Defined Field' screen of Contract Online screen, system will execute the derivation rule to convert the transaction amount to Euro equivalent and displays the Euro equivalent of the transaction amount.

After writing the PL/SQL code, click 'X' button to execute the code. The derivation code will be validated by the system. If any checks fail, you must alter the statement so that the validation can be made successfully. Click 'E' button to view the errors.

Parent topic: Text Field