3 Replies Latest reply on Dec 8, 2011 10:41 PM by Hussein Sawwan-Oracle

    [ASK] Hardware sizing for FAH and GL Implementation

    904255
      Hi All,

      I'm wondering how to determine the best hardware sizing for implementing Oracle FAH (Financial Accounting Hub) and GL module.
      Our conditions :
      1. we have around 7 legacy system that will be integrated in Oracle EBS, and one the source system may have million of daily accrual transactions (debit and credit transaction, totally 8 millions rows).
      2. all source system will generate textfile daily and put in the FTP server where Oracle EBS will take the textfile from that server and upload into FAH before the journal transfer in to GL Ledger.
      3. Processing step that will be done (end to end process) :
      - File Processing (validating the textfile, upload the textfile into temporary table)
      - Pre Processing (mapping, validating from temporary table and inserting into interface table for FAH). In this process, we will do summarization from 8 millions become 100K based on COA Segment
      - Create event program for FAH
      - Create accounting
      - Transfer to GL
      - Posting in GL

      Our estimation regarding the hardware
      1. apps server -> SUN (T4 series)
      - CPU : 16 cores ( 2x 8cores)
      - Memory : 64GB
      - HDD : 2 x 300GB
      2. database server --> SUN (between M5000 or M8000 series)
      - CPU : 16 Cores (4 x 4cores)
      - Memory : 96GB DDR3
      - HDD : 4 x 300 GB

      So, if we have conditions and processing requirements above what is the best hardware sizing ? Is our estimation is already enough for processing bulky transactions ?
      Based on processing above, we predict that create accounting program will need more resources.


      Thanks for any comment or suggestions