HDL

Create Bank, Bank Branch, External Bank Account and External Bank Account Owner objects using HDL in Oracle Fusion

Create Bank Object using HDL
*******************************
Bank data can be loaded using Bank.dat file in HCM Data Loader.

Bank template Mapping
—————————————

Bank Template

Bank.dat Sample File Record
————————————————

METADATA|Bank|BankName|BankNumber|CountryCode

MERGE|Bank|Vision Bank|560765A|US

Create Bank Branch Object using HDL
**************************************
Bank Branch data can be loaded using BankBranch.dat file in HCM Data Loader.

Bank Branch template Mapping
—————————————————-

Bank Branch Template

BankBranch.dat Sample File Record
———————————————————-

METADATA|BankBranch|BankBranchNumber|BankBranchName|BankName|CountryCode|EftSwiftCode

MERGE|BankBranch|67565AQ|New York|Vision Bank|US|76578

Create External Bank Account Object using HDL
**********************************************
External Bank Account data can be loaded using ExternalBankAccount.dat file in HCM Data Loader.

External Bank Account Template Mapping
———————————————————————-

External Bank Account Template

ExternalBankAccount.dat Sample File Record
—————————————————————————

METADATA|ExternalBankAccount|BankNumber|BankBranchNumber|CountryCode|AccountNumber|IBAN|AccountName|AccountType|CurrencyCode

MERGE|ExternalBankAccount|560765A|67565AQ|US|5467845|US23 ANBK 3350 1234 5678 20|John Miller||USD

Create External Bank Account Owner Object using HDL
*****************************************************
External Bank Account Owner data can be loaded using ExternalBankAccount.dat file in HCM Data Loader.

External Bank Account Owner Template Mapping
——————————————————————————–

External Bank Account Owner Template

ExternalBankAccountOwner.dat Sample File Record
—————————————————————————

METADATA|ExternalBankAccountOwner|BankNumber|BankBranchNumber|CountryCode|AccountNumber|CurrencyCode|PersonNumber|PrimaryFlag

MERGE|ExternalBankAccountOwner|560765A|67565AQ|US|5467845|USD|100|Y

Creating Calendar Event using HDL

For creating Calendar Event through HDL, you have to provide CalendarEvent and CalendarEventCoverage in CalendarEvent.dat file.

METADATA|CalendarEvent|Name|Description|Category|CoverageType|ShortCode|StartDateTime|EndDateTime|TreeCode|TreeStructureCode|TreeVersionName|HalfDayForElapsed
MERGE|CalendarEvent|Republic Day|Republic Day|PH|G|RP_DY|2020/01/26 08:00:00|
2020/01/26 23:30:00|Vision_GEO_TREE|PER_GEO_TREE_STRUCTURE|Vision Geo TreeV1|Y
MERGE|CalendarEvent|Independence Day|
Independence Day |PH|G|IND_DY|2020/08/15 08:00:00|
2020/08/15 18:00:00|Vision_GEO_TREE|PER_GEO_TREE_STRUCTURE|Vision Geo TreeV1|N

METADATA|CalendarEventCoverage|ShortCode|CoverageScope|TerritoryCode|TreeStructureCode|TreeCode|TreeVersionName
MERGE|CalendarEventCoverage|RP_DY|I|IN_BLR|PER_GEO_TREE_STRUCTURE|Vision_GEO_TREE|Vision Geo TreeV1
MERGE|CalendarEventCoverage|IND_DY|I|IN_BLR|PER_GEO_TREE_STRUCTURE|Vision_GEO_TREE|Vision Geo TreeV1