3.7 Copy Parametrization Data

This topic describes the systematic instruction to copy parametrization data.

You can copy parametrization data from Oracle Banking Treasury Management environment to any other environment and vice versa. The data from Oracle Banking Treasury Management can be exported into an excel sheet or an XML format.

If Excel Export Required option is checked for a function Id in the Function Description Maintenance (SMDFNDSC) screen then an Export button is enabled in the summary screen of that function Id.

1. In the Summary screen, you can query records based on the query parameters available and then select the required records to be exported and click Export button.
2. On clicking Export button, system would export the data into an excel sheet and opens the excel sheet with data populated. You can then save the excel sheet.
   The records can be exported either in .XLS or .XLSX format. The format of the export file must be maintained in ‘CSTB_PARAM’ against the parameter ‘EXCEL_FORMAT’.

   You can also import data into Oracle Banking Treasury Management environment using the Excel Import screen.

3. On Home screen, type CSDXLUPD in the text box, and click next. Till Balancing screen displays.
   The Excel Import screen displays.
4. On Excel Import screen, specify the fields.
   For more information on fields, refer to the field description table.

   Table 3-3 Excel Import - Field Description

   Field	Description
   File Name	Select the excel file to be imported by clicking Browse button.
   Total Number of Records	The total number of records to be uploaded is displayed here.
   Function Id	The function id mentioned in the excel file chosen is displayed here.
   Batch Reference	The unique reference number generated for an upload is displayed here.
   Post Upload Status	Select the status to be set for the file post upload, from the drop-down list. The following statuses are available in the drop-down list: Authorized Unauthorized Hold
   Override Action	Select the action to be taken if an override message is encountered, from the drop-down list. The following options are available: Ignore Error
   Action	The action is displayed here.
   Numer of failed records	The total number of records which failed to get uploaded is displayed here.
   Generate or Upload	Select the action to be taken for importing the file, from the drop-down list. The following options are available for selection: Generate XML – Select this option if an XML has to be generated from the imported file. Import – Select this option if the data has to be uploaded as an excel file itself. Note: To start the upload process click Upload button. Once you click this button system starts importing the data from the excel file.
   Source	Specify the source code of the file to be used for generating the XML file. You need to specify the source if you have chosen Generate option in the Generate or Upload field.
   Record Id	The unique number of the record uploaded is displayed here.
   Record Key	The record key is displayed here.
   Status	The upload status of the record is displayed here.
   Record Id	The unique number of the record, which encountered error while uploading, is displayed here.
   Error Code	The error code corresponding to the error encountered during upload is displayed here.
   Error Message	The error message corresponding to the error code displayed is defaulted here.

5. Click Save button to save the operation.