13.3 Subledger Event Grouping using Header and Line

When the journals get published to ERP, the Header and Line relationship is governed by ERP, and each of these can be individually grouped. In the interest of volume and performance, it is recommended to remove information, which can be fetched later from Product Processor tables e.g. Customer, Account etc., from the COA segment codes in ERP. It is recommended that the Header-Line relationship should be appropriate with all common properties of Line being reflected in the Header e.g. if the Line contains properties like Legal Entity, LOB, Branch, Product, Date, Amount, Flag, etc, and if the Header is designed to balance all the Lines per Product, then the Header should contain all common properties of Line other than the Product i.e., LE, LOB, Branch, Date, Amount, Flag. This will ensure that all transactions for a particular Product will get grouped under the same Header.

Note:

For more details on how to group events using header and line, and how to manage group attributes for various product processor types like Loan contracts, Credit cards, and so on, see FSDF Integration with FAH Cloud User Guide

Process and Configuration

Decomposition is run during the POP_DECOMP_JOURNALS step in the RunChart for BCE Process Modeller Framework (PMF).

Figure 13-2 Runchart for BCE PMF


Runchart for BCE PMF

Journals are sent by ERP. Journals with Data source – ‘ERP-FAH’ are grouped together. Grouped journal information is placed in Stage accounting entries table.

Data is taken as input from transaction tables/PP tables, FSI_TXN_AH_HEADER_MAP and Stage Accounting entries.

Decomposition is done and output is placed in FSI_DECOMPOSED_FAH_JOURNALS

Grouping across contract/account grain is allowed.

Run Parameters

FIC_MIS_DATE is the parameter used for Decomposition.

The following Product Processors for Journal Decomposition had been added in 8.1.1.1.0 release:

  • Stage Over Draft Accounts
  • Stage Bill Contracts
  • Stage Letter Of Credit Contracts
  • Stage Term Deposit Contracts

The following Product Processors for Journal Decomposition had been added in 8.1.1.1.2 release:

  • Stage Borrowings
  • Stage Casa Accounts
  • Stage Loan Contracts
  • Stage Investments
  • Stage Cards
  • Stage Annuity Contracts
  • Stage Correspondent Accounts
  • Stage Leases Contracts
  • Stage Mutual Funds
  • Stage Retirement Accounts
  • Stage Trading Account
  • Stage Merchant Cards
  • Stage Cards
  • Stage Futures Contract
  • Stage Guarantees
  • Stage Option Contracts
  • Stage Repo Contracts
  • Stage Commitment Contracts
  • Stage Foreign Exchange Contracts
  • Stage Money Market Contracts
  • Stage Swaps Contracts