VAIBHAV KUMAR DWIVEDI

Vaibhav Kumar Divedi. I am born and brought up in Balia. I completed my post-graduation from the University of Lucknow in 2022 in a Master's of Computer Application. I have almost 2.2 years of experience working as a network and IT analyst. Currently, I am working with Tech Mahindra as a technical support associate. My hobbies include reading books and writing poems. I have also worked as an SPOC, managing the team in Lucknow, keeping a check on them by rostering, and managing the knowledge base articles for the team. https://www.techmahindra.com

Basically, there is no development experience on Accounts Payable, Accounts Receivable, and General Ledger. Only as far as I have studied about it, AP stands for Accounts Payable, AR stands for Accounts Receivable, and GL stands for General Ledger. These are the key financial processes within an ERP. Accounts Payable stands for its prime focus is on handling a company's outgoing payments and managing vendor invoices. Its key areas include invoice processing automation, vendor management, payment processing, and expense report building to handle employee reimbursement and expenses. Account Receivable basically involves managing incoming payments and customer account development. It includes invoicing and billing, payment reconciliation, and credit control, as well as monitoring customer feedback and collection management, implementing workflows for managing collections and aging reports. General Ledger is the backbone of an organization's accounting system. It records all financial transactions and provides the foundation for financial reporting. Its prime focus is on account design, general entries, automation, multi-currency, and consolidation, as well as financial reporting. So, AP, AR, and GL often need to be integrated with other modules such as procurement, sales, and inventory. This ensures accurate and real-time data flow across the system.

E-Business Suite Oracle, basically it's Oracle E-Business Suite R12. We can say it's a comprehensive integrated business application used by organizations to manage core business processes. My experience with Oracle E-Business Suite R12 spans various modules, customizations, and technical configurations. The overview is that account payable involves automating invoice captures, approvals, and payment processes, addressing customer issues, and resolving payment workflows, customizing payment methods for banks, and integrating with external banking systems, managing suppliers, and streamlining their supplier setup and management workflows to ensure smooth payment processing. In account receivable, we have invoicing, customizing, and automating invoices, creating customers based on various transaction sources, such as sales and contracts. Cash applications are also there, where we can automate the process of applying customer payments to outstanding invoices with certain rules for different payment methods, collecting dunning letters or processes, and improving the AR aging report. General ledger is the backbone of the organization, so we customize automatic general entries, generate from sub-ledgers, and use multi-currency accounting, which involves handling transactions in various currencies and reporting them in base functional currencies. Financial reporting is also there, where we design custom financial reports using the financial statement generator. P2P, or procure to pay, and order to cash, involve procurement module integration and sales order integration, where we work with order management workflows to ensure seamless sales into accounts receivable for billing and revenue recognition. We also include customizations and extensions here, where we can personalize forms and customize them by modifying Oracle forms to meet business requirements without altering the base code of Oracle forms, develop reports, and design them by customizing reports using Oracle reports, XML publisher, and Oracle discoverer. Workflows involve implementing or customizing Oracle workflows for approval in financial and procurement processes, concurrent programs, where we can create and schedule concurrent programs for batch processing, custom report generation, and data uploads or downloads. That's all.

So, as far as the question includes, I am lacking experience in development of APARGL EG integration projects and configuration of APAR. So basically, my strategy includes the first step of understanding the functional concepts of what APAR and GL process are, EG integration projects, forms, personalization, stored procedures, DFF, and customer reports. Therefore, I will start by gaining a solid understanding of the business process behind accounts payable, accounts receivable, and general ledger. This is essential for both the integration and development or configuration. To learn accounts payable, I will understand the full life cycle from vendor onboarding, purchase order, matching the workflows, approval of workflows, and payment generation. For accounts receivable, I will basically understand the customer invoicing, payments, application, credit management, and collection of process. To familiarize myself with general ledger, I will study various charts of accounts, general ledgers or journal entries, financial reporting, and consolidation, P2P and OTC. As far as it is concerned, I will study the end-to-end requirement of the procure to pay and order to cash cycles. To see how AP and AR fit into broader business projects, there are various books and online courses available for learning. Learning Oracle EBS fundamentals will also provide extensive documentation for each module, which covers both functional and technical aspects. There are Oracle courses available in the learning library by which I can add my experience in learning various fields of AP, AR, and custom reports migration. So, I will start with AP, move to AR, then learn GL, and finally practice hands-on.

When updating an Oracle ERP system, to ensure smooth and secure updates, I apply a structural approach to identify the risks and mitigation. There are various techniques, including risk assessment and impact analysis, with main steps that include identifying critical modules, listing key Oracle modules that are impacted by the update, such as AP, AR, GL, procurement, and others. I assess the change impact, analyze how the impact will affect integration and customization workflows, and third-party tools, and document known risks for review after the update cycle for any issues that occur after the update. Mitigation impact analysis can be conducted through functional and technical impact analysis, involving module owners, business users, and technical teams, documenting each risk and assigning a risk rating as high, medium, or low based on business disruption or technical complexity. Effective testing strategies are identified, which can be part of risk mitigation during the Oracle ERP update, including regression testing, integration testing, custom code testing, user acceptance testing, which involves various end-users in testing scenarios that reflect real business operations, helping to identify issues not evident in technical testing, and automation testing, with various test environments set up and a back-out plan in place.