Oracle Financial Cloud Configuration – Accounting Hub (FAH)

Following configuration is based on the assumption that GL configuration has been completed.

Following sequence is recommended by Oracle to setup accounting method and rules after source system is registered.

Register Source System

Download rapid implementation spreadsheet

Generate zip using spreadsheet

Upload the zip file

Verify and confirm source system is created

Configure Accounting Rules

Accounting rules are attached to accounting method, which is in turn attached to primary or secondary ledger.

To access accounting rules, use following navigation:

Create Mapping Set

Mapping set is used to derive single segment value, or even account combination values from source transaction or reference attribute values. Up to 10 transaction or reference attributes can be used as input to a mapping.

Create Account Rule

Account rules derive the accounts for the journal lines. At least one account for debit and one account for credit is required. Account run can either use or not use mapping set.

Create one rule to derive account segment value from mapping set created in previous step, in case Refinance Type is None.

Create another rule to derive account combination value for receivable account.

Create one more rule to derive account combination value for cash account.

Create User-Defined Formula

Create Description Rule

Create Supporting Reference

There is another article describes how to get supporting reference values in SQL query for BIP report.

Create Journal Line Rule

Create Subledger Journal Entry Rule Set

This step combines 4 configurations setup by previous steps:

1. Journal line rules – this derives DR/CR lines
2. Account rules – this derives accounting segments
3. Description rules – this derives line and header description
4. Supporting reference – this derives supporting references

Create Subledger Accounting Method

Assign Subledger Accounting Method to GL Ledger

Upload Transaction Data from Spreadsheet

Download FAH transaction data template

FAH transaction data template can be obtained from following navigation.

Edit transaction date

FAH transaction data is a zip file containing 3 sub files

1. Metadata_08PER_LOAN_MORG.txt
2. XlaTrxH.csv
3. XlaTrxL.csv

Metadata file inclusing the metadata information of specified subledger application. Normally it doesn’t need modification.

Metadata version number : 1
ZIP Version number : 1
Creation date : 2021-04-28 03:21:47.0
Application Short Name : 08PER_LOAN_MORG
Date format : yyyy-MM-dd
Transaction Headers file : XlaTrxH.csv
Transaction Lines file : XlaTrxL.csv

XlaTrxH.csv contains subledger journal header data

TRANSACTION_TYPE,LEDGER_NAME,TRANSACTION_DATE,TRANSACTION_NUMBER,LOAN_SCHEDULED_PAYMENT_DATE,LOAN_MATURITY_DATE,LOAN_TYPE,LOAN_AMOUNT,LOAN_ORIGINATION_DATE,MORTGATE_OWNER,CUSTOMER_NUMBER,LOAN_NUMBER,LOAN_OFFICER,REFINANCE_TYPE
LOAN_ORIGINATION,08Ledger US,2021-04-30,CL-001,2021-05-31,2021-04-30,Fixed Rate,100000,2021-01-01,Kimberly,1002,101,John Nile,None
LOAN_ORIGINATION,08Ledger US,2021-04-30,CL-002,2021-05-31,2021-04-30,Adjustable Rate,300000,2021-01-01,Douglas,1003,106,John Nile,None
LOAN_ORIGINATION,08Ledger US,2021-04-30,CL-003,2021-05-31,2021-04-30,Fixed Rate,150000,2021-01-01,Nancy,1008,109,Patric Lee,None

XlaTrxL.csv contains subledger journal line data

TRANSACTION_NUMBER,DEFAULT_AMOUNT,DEFAULT_CURRENCY,LOAN_RATE08
CL-001,100000,USD,3.5
CL-002,300000,USD,3.25
CL-003,150000,USD,3.875

Package these 3 files into zip.

Upload Transaction Data

Submit Import Accounting Transaction Process

Wait for import completion

Verify import result from subledger