1 / 8

Ajaya Kumar Rath – Associate Consultant Capgemini

Oracle GL : Jack of E-Business Suite. Ajaya Kumar Rath – Associate Consultant Capgemini. Abstract. Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance .

billd
Download Presentation

Ajaya Kumar Rath – Associate Consultant Capgemini

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle GL : Jack of E-Business Suite Ajaya Kumar Rath – Associate Consultant Capgemini

  2. Abstract Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance. As per global practices and criticality of the business and volume any implementation of a Banking application or enhancements should be systematically tested and confirmed by Independent Testing before deploying the same in production. This paper attempts to highlight the critical aspects of Oracle Financial Application General Ledger Module and key testing, best practices for a successful testing delivery in terms of approach, tools & accelerators.

  3. Typical Oracle GL Testing Process • Receive Transaction files from several source systems, convert them to standard format and feed to ETL. • Receive output files from ETL Tables, once the transformation is completed. • Compare ETL Table Extracts against the source files as per the mapping rules defined. • Similarly the corresponding files from ETL to Core Banking System and then to Oracle GL Module need to be tested to ensure the Total Record count, Total Debit Amount, Total Credit Amount and other balance information populated correctly. • Perform Functional Testing within Oracle GL to enter new Journals, Journal Posting, Journal Approval, Journal reversal and generating standard Oracle Financial reports. • Downstream to Oracle GL Module are critical and should be tested for various Report generation functionality.

  4. Case Study – GL Testing Manual vs Automation Effort

  5. Conclusion and Recommendations • Oracle General Ledger System Integration Testing is unique in terms of skill set and mind set required to handle the extremely complex technical and coordination needs as well as volumes of data. A thorough and systematic approach is the only answer to achieve the quality as well as time to market

  6. References & Appendix • https://docs.oracle.com/cd/A89549_01/acrobat/115oaug.pdf • http://docs.oracle.com/cd/E26401_01/index.htm • https://docs.oracle.com/cd/E18727_01/doc.121/e13627/T312864T314710.htm

  7. Author Biography I started my journey with Capgemini focusing majorly into Core Banking, Accounting and Oracle Finance module. I have completed 3.7 Years of Experience in Banking & Financial Domain in working with Testing, Quality Control, and Quality Management. I hope this paper will bring value to the readers in the context of testing Oracle General Ledger and Finance Module.

  8. Thank You!!!

More Related