13.1 Grouping

Grouping logic essentially contains information on which Events compose the grouped Event and in what proportion those Events constitute the grouped Event before this information is published to Oracle ERP Financials Cloud Accounting Hub. FSDF-AHCS INT (Data foundation Accounting Hub Integration Application) supports grouping of Events.

Grouping information consisting of Header IDs, Event IDs, and the aggregated Grouped Event ID and the lookup values of the respective Product Processor tables to be used for Decomposition are maintained in the mapping table: FSI_TXN_AH_HEADER_MAP. This mapping is used to decompose the grouped journals received from ERP along with the Account and Amount information gathered from transaction tables (Stage Casa Transactions, Stage loan Contract transactions, Stage Card Transactions, and so on) and customer information gathered from Product Processor tables (Stage Casa, Stage Loan contracts, Stage cards, and so on). They are then loaded into the FSI_DECOMPOSED_FAH_JOURNALS table in the BCE processing area. Hence, the Journal that is received back from ERP is Decomposed using Event information and Transaction lookups so that the proportion in which originally sourced Events constituted the grouped Event is reflected back in the received Journals.