1. File Upload User Guide
  2. File Upload
  3. Bank Setup File Upload

1.2 Bank Setup File Upload

This topics describes the information to perform the bulk upload for the bank setup in Oracle Banking Liquidity Management.

File Type Supported - CSV

File Naming Convention - LMBankParams_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 1-2 Bank Setup File Upload - Master Records

Sequence Attribute name Type Size Description
1 Discriminator* String 1 Denotes master record type. Default value is always “P”
2 Action* String 10 Denotes file operation type. Allowed values are new/modify
3 Cross Border Sweep* String 1 Indicates the bank allows Cross Border accounts in sweep structures
4 Cross Border Pool* String 1 Denotes the bank allows Cross Border accounts in pool structures
5 Cross Border Hybrid Sweep* String 1 Indicates the bank allows Cross Border sweep accounts in hybrid structures
6 Cross Border Hybrid Pool* String 1 Denotes the bank allows Cross Border pool accounts in hybrid structures
7 Cross Ccy Sweep* String 1 Indicates the bank allows Cross Currency accounts in sweep structures
8 Cross Ccy Pool* String 1 Denotes the bank allows Cross Currency accounts in pool structures
9 Cross Ccy Hybrid Sweep* String 1 Indicates the bank allows Cross Currency sweep accounts in hybrid structures
10 Cross Ccy Hybrid Pool* String 1 Indicates the bank allows Cross Currency pool accounts in hybrid structures
11 Source System* String 35 Specifies the source of maintenance
12 Source System Bank Code String 4 Denotes the Source System Bank Code
13 Bank Code* String 4 Specifies the Bank Code
14 Bank Description* String 200 Indicates the description of the Bank
15 Bank Short Name String 30 Denotes Short Name of the Bank
16 Bank Type* String 10 This will always default to Internal. External banks are created from Third Party Maintenance screens
17 Line1 String 100 Indicates the bank address details - Address Line 1
18 Line2 String 100 Indicates the bank address details - Address Line 2
19 Line3 String 100 Indicates the bank address details - Address Line 3
20 Line4 String 100 Indicates the bank address details - Address Line 4
21 Country Id String 10 Denotes the Country Id
22 State Id String 10 Specifies the State Id
23 City Id String 10 Specifies the City Id
24 Zip String 10 Indicates the Zip Code
25 Phone Number String 13 Specifies the Phone Number
26 Fax String 20 Specifies the Fax details
27 Is Mbcc Allowed* String 1 Multi Bank Cash Concentration - Indicates the host bank supports MBCC
28 Is Bvt Allowed* String 1 Indicates banks allow BVT
29 Sweep* String 1 Indicates the sweep structures are allowed in the Bank
30 Pool* String 1 Denotes the pool structures are allowed in the Bank
31 Hybrid* String 1 Indicates the Hybrid (Combination of Sweep and Pool) structures are allowed in the Bank
32 Domestic Sweep* String 1 Indicates the bank allows Domestic accounts to participate in sweep structures
33 Domestic Pool* String 1 Denotes the bank allows Domestic accounts in pool structures
34 Domestic Hybrid Sweep* String 1 Denotes the bank allows Domestic sweep accounts in hybrid structures
35 Domestic Hybrid Pool* String 1 Indicates the bank allows Domestic pool accounts in hybrid structures
36 Ext Acc Sweep Basis String 15 Denotes the External Account Sweep Basis
37 If Avl Bal Ext Acc Not Avl String 15 Indicates the Available Balance Tag Absense Handling
38 Charge Calc Pref* String 1 Specifies the Charge Calculation Preference
39 Charge Col Pref* String 1 Specifies the Charge Collection Preference
40 Chg Include Closed Va* String 1 Change include when closed

Table 1-3 Bank Setup File Upload - Child Records

Sequence Attribute name Type Size Description
1 Discriminator* String 1 Denotes child record type. Default value is always “C”
2 Parameter Name* String 50 Indicates the Parameter Name
3 Parameter Value* String 300 Indicates the Parameter Value

Parent topic: File Upload