1. Oracle Banking Trade Finance - Oracle Financial Services Analytical Applications Integration
  2. Data Transfer from OBTF to OFSAA

2.1 Data Transfer from OBTF to OFSAA

For details on data transfer from OBTF to OFSAA, refer the below table:

This sheet has the following details:
  • Source System
  • Target System
  • Data Transferred
  • Source System Module
  • OBTF Staging Table Name
  • Extraction Package Name
  • Target System Table Name
  • Extraction Routine
  • Data Included in the Extraction

OBTF-OFSAA Data Transfer

OBTF uses FLEXCUBE Information Server framework components to extract data and stores the data in the staging tables of OBTF. During EOFI batch, the module wise data in the FLEXCUBE Information Server are extracted to staging tables in OBTF. OBTF provides a control table to indicate successful data extraction. OFSAA pulls the data from the tables in OBTF using the DIH connector. Source System - OBTF Target System - OFSAA

Table 2-1 OBTF-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