2.1 Data Transfer from OBTFCS to OFSAA
For details on data transfer from OBTFCS to OFSAA, refer the below table:
This sheet has the following details:
- Source System
- Target System
- Data Transferred
- Source System Module
- OBTFCS Staging Table Name
- Extraction Package Name
- Target System Table Name
- Extraction Routine
- Data Included in the Extraction
OBTF-OFSAA Data Transfer
OBTFCS uses FLEXCUBE Information Server framework components to extract data and stores the data in the staging tables of OBTFCS. During EOFI batch, the module wise data in the FLEXCUBE Information Server are extracted to staging tables in OBTFCS. OBTFCS provides a control table to indicate successful data extraction. OFSAA pulls the data from the tables in OBTFCS using the DIH connector. Source System - OBTFCS Target System - OFSAA
Table 2-1 OBTFCS-OFSAA Data Transfer
| Data Transferred | Source System Module | FCUBS Staging Table Name | Extraction Package Name | Target System Table Name | Extraction Routine | Data Included in the Extraction |
|---|---|---|---|---|---|---|
| Letter of Credit contracts | LC | AATB_STG_LC_CONTRACTS | AAPKS_EXTRACT_LC_CONTRACTS | Stg_Lc_Contracts | Daily | Complete Data |
| Letter of Credit accounting entries | LC | AATB_STG_LC_TXNS | AAPKS_EXTRACT_LC_TXNS | Stg_Lc_Txns | Daily | New and Modified Data |
| Guarantee contracts | LC | AATB_STG_GUARANTEES | AAPKS_EXTRACT_GUARANTEES | Stg_Guarantees | Daily | Complete Data |
| Guarantee accounting entries | LC | AATB_STG_GUARANTEES_TXNS | AAPKS_EXTRACT_GUARANTEES_TXNS | Stg_Guarantees_Txns | Daily | New and Modified Data |
| Letter of Credit contract events | LC | AATB_STG_LC_CONTRACT_EVENT | AAPKS_EXTRACT_LC_EVENT | Stg_Trade_Fin_Cntrct_Event | Daily | Complete Data |
| Letter of Credit documents | LC | AATB_STG_LC_DOCUMENT | AAPKS_EXTRACT_LC_CONTRACT_DOCS | Stg_Trade_Finance_Document | Daily | Complete Data |
| Letter of Credit goods | LC | AATB_STG_LC_GOOD | AAPKS_EXTRACT_LC_GOODS | Stg_Trade_Finance_Goods | Daily | Complete Data |
| Letter of Credit parties | LC | AATB_STG_LC_PARTY_EVENT | AAPKS_EXTRACT_LC_PARTY_EVENT | Stg_Trade_Finance_Party_Event | Daily | Complete Data |
| Letter of Credit to accounts | LC | AATB_STG_LC_ACCOUNT | AAPKS_EXTRACT_LC_ACCOUNT | Stg_Trade_Finance_Acct | Daily | Complete Data |
| Bills and Collections contracts | BC | AATB_STG_BC_CONTRACTS | AAPKS_EXTRACT_BC_CONTRACTS | Stg_Bills_Contracts | Daily | Complete Data |
| Bills and Collections accounting entries | BC | AATB_STG_BC_CONTRACTS_TXNS | AAPKS_EXTRACT_BC_TXNS | Stg_Bill_Contracts_Txns | Daily | New and Modified Data |