Setting the File Upload Interface Master Configuration

Procedure

To set the file upload interface master configuration:

  1. Click the Admin link in the Application toolbar.
    A list appears.
  2. From the Admin menu, select M and then click Master Configuration.
    The Master Configuration screen appears.
  3. In the Master Configuration zone, click the Edit (The Edit Icon) icon in the Edit column corresponding to File Upload Interface Configuration.

    The Master Configuration screen appears. It contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Master Configuration Displays the master configuration.
    Note: This is a read-only field.
    		 Not applicable
    Validate Checksum Used to indicate whether you want the system to check the integrity of the file before staging its contents in ORMB. If you select this option, the system will perform the checksum validation using the checksum file available on the SFTP server when the file validation algorithm C1-FRHFVA attached to the respective file request type is executed. However, if you do not select this option, the system will not perform the checksum validation for the files uploaded through the File Upload Interface feature.
    Note:

    The checksum file is available for the file on the SFTP server.

    The name of the checksum file should be identical to the name of the file that you want to upload. You must use the following naming convention for the checksum file - <FILE_​NAME>.checksum.

    The C1-FRHFVA algorithm should be attached to the File Validation Algorithm field in the respective file request type.

    The checksum file is created using the md5sum command. During the checksum validation, the system checks whether the checksum value generated for the file in ORMB matches the checksum value specified in the checksum file. If so, the validation is successful. Otherwise, an error occurs indicating that the checksum value is incorrect.

    If you update a file after creating the checksum value for the file, you need to update the checksum value in the checksum file before uploading the file in the staging area of ORMB.

    		 No
    Validate Duplicate File Name Used to indicate that a validation check for duplicate file-name is performed before the file is uploaded in the ORMB system.
    Note: If this field is unchecked, file with same name can be uploaded multiple times.
    		 No
    Audit Log Required Used to indicate whether to log corresponding status changes of an individual file request after processing.
    Note:

    Logging is done in CI_​FILE_​REQUEST_​DTL_​MSG table with LOG_​ENTRY_​TYPE_​FLG value as F1ST

    CI_​FILE_​REQUEST_​DTL_​MSG table is also used for error logging with LOG_​ENTRY_​TYPE_​FLG value as F1EX.

    		 No
    File Name Size Used to specify the maximum allowed size of a file name. Yes (Conditional)
    Note: This field is required when you want to set the maximum length for a file name.
    Max File Records Used to specify the maximum number of records a file can contain during the upload process. Yes (Conditional)
    Note: This field is required when you want to set the total number of records per file.
    Max File Processing Size (in MB) Used to specify the maximum size (in megabytes) of the file that can be processed.
    Note: For plain files, the file size should not exceed 2 GB (2000 MB) and for an encrypted file, the file size should not exceed 1 GB (1000 MB)
    		 Yes (Conditional)
    Note: This field is required when you want to set the maximum size of a file to process.
    Archive File Used to indicate whether to archive the file or not once the corresponding file is processed.
    Note: You need to specify the location that refers to the path mentioned in the Archive File Location or Archive Error File Location field.
    		 No
    Archive File Location Used to specify the file path that is needed to store the file(s) which are marked for archival.
    Note:

    CFS Environment File Path: The bucket path for storing files in the CFS environment is specified as file-storage://ORMB_​SHARED/DEV_​IMPORT.

    On-Premise File Path: The shared directory for file uploads in an on-premises setup is defined as @SHARED_​DIR/fileupload.

    		 Yes (Conditional)
    Note: This field is required when the Archive File option is selected.
    Archive Error File Location Used to specify the file path that is needed to store the file(s) which have been failed during the upload process.
    Note:

    CFS Environment File Path: The bucket path for storing files in the CFS environment is specified as file-storage://ORMB_​SHARED/DEV_​IMPORT.

    On-Premise File Path: The shared directory for file uploads in an on-premises setup is defined as @SHARED_​DIR/fileupload.

    		 Yes (Conditional)
    Note: This field is required when the Archive File option is selected.
    File Decryption Required Used to indicate whether decryption is necessary for the uploaded file. Yes (Conditional)
    Note: This field is required when you need to decrypt the file.
    File Decryption Algorithm Used to specify the algorithm that is used for decrypting the third party provided encrypted file before uploading in the ORMB application. Yes (Conditional)
    Note: This field is required when the File Decryption Flag option is selected.
    Cipher Type Used to specify the type of cipher used for encryption or decryption. The valid values are:

    • Advanced Encryption Standard

    • Data Encryption Standard

    • Pretty Good Privacy

    • RSA with AES

    Note: It is used to get the encrypted keystore password that is required to read ouaf_​keystore file which holds the encrypted file key.
    		 Yes (Conditional)
    Note: This field is required when the encryption or decryption is required.
    Private Key Used to specify the key required for encryption or decryption.
    Note:

    It is updated in ouaf_​keystore file, as it does not reside in the database.

    This field appears only when you select the Advanced Encryption Standards, Data Encryption Standard, or the RSA with AES option from the Cipher Type list.

    		 Yes (Conditional)
    Note: This field is required when the encryption or decryption is required.
    Pass Phrase Used to specify the pass phrase required for decryption.
    Note: This field appears only when you select the Pretty Good Privacy option from the Cipher Type list.
    		 Yes (Conditional)
    Note: This field is required when the File Decryption Flag option is selected.
    File Encryption Required Used to indicate whether encryption is necessary for the processed file. Yes (Conditional)
    Note: This field is required when you need to encrypt the file.
    File Encryption Algorithm Used to specify the algorithm that is used for encrypt the third party provided decrypted file before uploading in the ORMB application. Yes (Conditional)
    Note: This field is required when the File Encryption Flag option is selected.
    Encryption Pass Phrase Used to specify the pass phrase required for encryption.
    Note: This field appears only when you select the Pretty Good Privacy option from the Cipher Type list.
    		 Yes (Conditional)
    Note: This field is required when the File Encryption Flag option is selected.
    Upload Private Key Used to provide an option to upload a private key file required for decryption or encryption.
    Note: This field appears only when you select the Pretty Good Privacy option from the Cipher Type list.
    		 Yes (Conditional)
    Note: This field is required when the encryption or decryption is required.
    Note: You can also set the file upload interface master configuration by clicking the Edit button in the Master Configuration Details zone.
  4. Enter the required details in the Main section.
  5. Click Save.
    The file upload interface master configuration is set.

    Related Topics

    For more information on... See...
    Master Configuration screen Master Configuration Screen
    Master Configuration zone Master Configuration
    Master Configuration Details zone Master Configuration Details