Steps for OFSAA ALM cash flow generation

Please find the steps below for the OFSAA ALM cashflow generation.

--------------------------------------------------------------------------------------------------------------
0. OBJECT REGISTRATION
1. Create Product Hierarchy in front end.--- DIM_PRODUCTS_B
2. Create COA hierarchy in the front end. -- dim_common_coa_b
3. Map product members to COAs
4. Create one Legal Entity in the Front end.
5. Execute "Reverse Population" -- DT name : REVERSE_POPULATION
6. Create one Active Time bucket.
7. Populate DIM_DATE : Execute function "" in the back end with start date and end date.
8. Populate FSI_D_LOAN contracts
9. Create one product characteristic in ALM
10. Create one ALM Static Deterministic process for Loan data.
11. Execute from ALM Process.
12. Use the below queries for cashflow data.

select /* + PARALLEL(16)*/
a.as_of_date,
a.account_number,
a.amrt_type_cd,
a.int_type,
a.origination_date,
a.last_reprice_date,
a.next_reprice_date,
a.maturity_date,
a.adjustable_type_cd,
a.reprice_freq,
a.reprice_freq_mult,
a.org_term,
a.org_term_mult,
a.amrt_term,
a.amrt_term_mult,
a.last_payment_date,
a.next_payment_date,
a.pmt_freq,
a.pmt_freq_mult,
a.remain_no_pmts_c,
a.cur_par_bal,
a.after_payment_balance,
a.cur_net_rate,
a.cur_payment,
a.org_payment_amt
  from fsi_d_loan_contracts a
where a.as_of_date = '29-JAN-2016';

cash flow query

select /* + PARALLEL(16)*/
  id_number, tl.financial_elem_name, a.*
   from fsi_o_process_cash_flows a, dim_financial_elements_tl tl
  where a.financial_elem_id = tl.financial_elem_id;

select
AMRT_TERM_MULT,
ORG_TERM_MULT,
PMT_FREQ_MULT,
ISO_CURRENCY_CD,
ACCOUNT_NUMBER,
ORG_TERM,
AMRT_TERM,
AMRT_TYPE_CD,
--LAST_TRANSACTION_DATE,
ISSUE_DATE,
NEXT_PAYMENT_DATE,
MATURITY_DATE,
AS_OF_DATE,
ID_NUMBER,
PRODUCT_ID,
IDENTITY_CODE,
CUR_PAR_BAL,
CUR_BOOK_BAL,
LEGAL_ENTITY_ID,
BEHAVIOUR_TYPE_CD,
PMT_FREQ,
ORG_BOOK_BAL,
NET_MARGIN_CD,

ADJUSTABLE_TYPE_CD,

--RESIDUAL_AMT_OF_GUARANTEE,
COMMON_COA_ID,
ORG_UNIT_ID,
GL_ACCOUNT_ID,
CUSTOMER_ID
from fsi_d_ledger_stat_instrument where as_of_date = '30-Sep-2016';

----------------Functional Currency ----------------
select * from FSI_DB_INFO;
update FSI_DB_INFO set functional_currency_cd = 'INR';