Devendrakumar Rajendran - A Blog to Oracle Financials World

Plsql apis Faster transaction processing. Code executes directly on database server with not much io disk reads Code reusability- write once and call from multiple applications Modular design- clean and neat. Serving specific business processes and functions Reusuable libraries bring down development and testing efforts.. Quality and greater efficiency business examples Create an invoice api, receipt api, asset additons, dereciations api, GL journal apis What invoice api does, It creates an sales invoice for any business entity. How the skeleton design looks like, Invoice business validations Invoice header Invoice lines Business calculation logics Tax calculations Calculate sales commissions Exception handling scenarios Transaction handling - commit, rollback, and savepoints Apis will be called from multiple business applications within a company or external partners- it can be java, dot net, or any platform just to correlate above business example-

Fixed Assets Additions Transfer in-transfer out Allocations Depreciation Retirements Gain/Losses Asset maintenance (warranty, insurances, repairs, services) finance cost and transaction inquiries Create accounting Transfer to gl and posting Major asset classes for any business are PPE- plants, property, equipments/machinery depreciation is calculated based on useful period, cost value, and salvage value Most common type of depreciation method used across industries.. Flat rate- straight line calculation Production per unit method.. assets retirement will be after useful life period.. If asset is sold out before useful period, and disposal price is more than the net book value than the price is recorded as gain.. Other way- if sold less than net book value - then its a loss.. How net book value is calculated Net book value = total cost less accumulated depreciation Depreciation is calculated based on asset cost less salvage value and arrived number is di

General Ledger This module is one of the important area for any business organization.. What you can do with this module- Journals Budgets balance inquiry Prepare financial statements (Balance sheet, pl statement, cash flow analysis) Core setups and definitions- Currencies Calendar Chart of accounts Conventions 4C's- Ledger Ledger is associated to a legal entity Ex- let's take a company going to start a business in india per central government regulations ledger setup will be- Currency- INR Calendar- Apr20 to Mar21 (called as fiscal year for accounting) Chart of accounts - design will be based on enterprise needs.. based on number of operating units, products and services they are into.. and management reporting needs.. Conventions- accrual/cash basis journals, budgets, account balance inquiries are the important functional areas for business Journals- records total dr and cr entries from sub ledger budgets- you can prepare with respect to o

Technical stack within ebusiness suite r12 Oracle forms- Oracle bip reports PLSQL apis, packages, procedures, functions Open interface tables Oracle workflows Oracle alerts Oracle schedulers Host scripts- it can be for linux or solaris oracle oaf framework Page personalization form personalizations Conversions and migrations unit Many more functional setups that support technical stack Application object libraries support- Define forms Define form functions Define menu Define responsibility Define executables Define concurrent programs Define requests Define request sets Define lookups Register flexfields (knowledge and descriptive) Define profile options Define application messages I may missed out few things.. it will take time to recall past experiences.. Many more.. plenty.. It will take a decade to become a masterpiece within erp framework. Slow and steady wins the race.. this rule i am applying to knowledge and gaining insights Brain should

Procure to pay lifecycle within ebusiness suite r12 Create requisition Create purchase order Take internal approval process- PO goes approval stage Send document to supplier supplier fullfillment - goods will be sent to warehouse Gate in- Create po receipt and stock into warehouse inventory Inventory on-hand quantity increases raw materials are input for manufacturing Billing and invoicing to supplier Payments Create accounting Transfer to gl Post gl Affects ledger outstanding balance Accounting entries.. inventory account increases (dr) while receiving stocks Inventory decreases(cr)- at the time of moving materials for manufacturing Liability account increases (cr) at the time of invoicing liabilities gets knock off at the time of payment - thus decreases (dr) Expense account increases(dr) at billing Cash account decreases (cr) at clearance and settlement

Accounts payables what corporate do? Purchase raw materials or discrete assembly- make that as a input to their business to make finished goods and proceed sales Raise commercial invoice and account it under liabilities and expenses. Invoice is recorded with supplier name and how much corporate has to pay for.. less credit memo if any - for return goods or defects less prepayments if any token advance Apply taxes.. it can be vat, gst, state tax,county tax, city tax levy per country less withhold tax-remit it to tax revenue department Apply discounts- It can be bank charges It can be early payment to suppliers Record final invoice has liability Make a payment remittance with bank payment mode eft or cheques Accounting entries.. liability to expense cash clearing to liability cash to cash clearing Transfer to gl hits 4 control accounts with respective totals A single journal gives snapshot of it Post to gl Cash account will result in credit balance

Accounts payables Invoice and billing invoice accounting Payments Transfer to ledger Post to gl Gl balances supplier liability, Short term and long term liabilities Financial statements This is one part of sub ledger flows and corporate needs.. Another flows- How to automate with banks.. Transmission protocols and servlets Payment systems Payment gateway / payment processors auto clearing houses file formats Payment remittance Payment clearance Load account statements Auto reconciliation Cash forecast and positioning Other part of corporate to bank and bank to corporate flows Within oracle erp - many more features.. just for info and knowledge.. World is big to sail...

Oracle fusion cloud has inbuilt iso payment system iso payment system has designed with out-of-the-box features Ability to generate payment instruction in isoxml format uses built-in payment transmission protocols, connectivity, payment security gaps in oracle ebusiness suite r12 has been addressed in fusion accounts payables module As per my research and study- corporate to bank flows been fully addressed within fusion cloud payables (SaaS0