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, which are marked with an asterisk, 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