Oracle Fusion Cloud/EBS Knowledge Sharing Blog

There are many tables in each module of Oracle Fusion Financials. I have listed here a few important tables for your reference. Accounts Payables AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter. An invoice can have one or more invoice distribution lines. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. An invoice can have one or more invoice lines. AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import AP_TERMS_B stores header information about payment terms you define. You need one row for each type of terms you use to create scheduled payments for invoices. AP_PAYMENT_SCHEDULES_ALL contains information about scheduled payments for an invoice AP_DISTRIBUTION_SETS_ALL contains information about Distribution Sets you define to distribute invoices automatically. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribut...

A receipt write-off is a receipt activity that cancels a small unapplied amount remaining on a receipt which your organization considers to be immaterial. For ex: For a transaction amount $ 999 customer has sent the payment for $1000. So $1 is in unaplied which customer does not want to get as refund and unapplied. So this can be written off. There are two methods available to create these receipt write-offs: Manual - a write-off is created from the Accounts Receivables Work Area Automatic - A write-off would be automatically created by running the Create Automatic Receipt Write-offs Program. It would look at the approval limits that are assigned to the user of running the process. Setups Setup write off limits at System Options Setup write off limits for user Create Receivable Activity for Receipt Write Off Process Create Transaction $999 Customer paid $1000 –Apply $999 write off $1 Setup write off limits at system options Setup write off limits for user Create Receivables activity fo...

What is Fixed Asset Addition? Fixed assets provide value over several years. Fixed assets are not bought for resale like trading, but rather it is bought to create value in the business. They are used in routine business activities such as office building, warehouse, computerized equipment, machinery, office equipment, and vehicles. Fixed assets addition basically refers to assets that the entity acquired during the current accounting period. Assets can be created in four ways in Oracle Fusion Cloud. Manual additions (Quick and Detailed Additions) Mass Additions (Accounts Payables or Project Accounting) ADFDI (used by business users to load assets) FBDI(used for data conversion) Manual Additions: Assets created through UI manually are called Manual Additions. Mass Additions: We create asset related invoices in AP/PA modules and convert those lines as assets in Oracle Assets module, this process is called Mass Additions. ADFDI: We can create assets in bulk using ADFDI spreadsheet, basic...

Reference Data set is a new concept available in Oracle Fusion Application and Reference Data Sets allow sharing and partitioning of data elements For eg: Payables Payment Terms . Oracle fusion provides a default Reference Data set which can be used across all Business units. However, we can define our own Reference data sets. Main advantage of using Reference Data Sharing is to help organizations share common transactional data without unnecessary duplication. For example, if organization has several business units and each business unit uses different payment terms on a customer invoice. Instead of each business unit creating and maintaining individual payment terms, one can define the payment terms reference data at the organization level and use that data into partitions (create reference data sets) so that the different payment terms can be assigned to each business unit. Note: There are two default RDS that Oracle provides i.e  COMMON  and  ENTERPRISE How to...

ADFDI - Application Development Framework Desktop Integrator ADFDI is an excel based tool which is used to manage a large volume of data from cloud applications by using an Excel Spreadsheet.   Required Role : Employee If you don't see " Download Desktop Integration Installer" option under Tools, assign Employee role. Please follow below steps to install Desktop Integrator Tool Step1: Download ADFDI Installer First we need to download this into our machine N:Navigator à Tools à Download Desktop Integration Installer Once downloaded Install it. Right click -> Run as administrator ->  Install ->  once installed click Close Download it. Right click, run as administrator. Install it Step2: Check Add In in excel Excel Options Go to Excel options → Add-Ins → Select “COM Add-ins” from drop down list and click on “Go” Verify whether “Oracle ADF 11g Desktop Integration Add-in for Excel” is enabled or not. If it’s not enabled, then enable it. Ok Step3: Update Tr...

Fusion Financials provides various types of reporting methods that work off the same standard and multi-dimensional balances. Now because all of the reporting and analytic tools leverage the same source of truth, it ensures that all the roles in your company regardless of the type of report they need will be on the same page. Financial Reporting Studio OTBI (Oracle Transactional BI) BI Publisher Smartview Account Monitor Account Inspector Financial Reporting Studio Financial Reporting Studio is the report designer tool or a report repository. It is Oracle’s best client based report authoring tool. It enables users to create customize and view income statements and balance sheet reports. Business users do not have to run the report, all they got to do is open it and real-time balances are shown automatically. Users can then drilldown from reports to subledger transactions, as well as publish reports in a variety of formats (MS Excel, PDF, MS Word, MS Powerpoint, etc.). ...

When an AP invoice is entered, there may be multiple expense/ distribution accounts and the corresponding liability account generally booked is the default account picked from the Supplier site or the one defaulted at Invoice header level. However, there may be scenarios where a business entity is using the same Operating Unit to make purchases against multiple balancing segments. In such cases, it would be imperative to have different liability accounts booked against each of the different distribution accounts. For example, consider an AP Invoice with a default liability account and two different distribution accounts. Liability is an offset account. We can offset liabilities in three ways i.e None Balance Account If you enable Automatic Offsets, Payables automatically balances invoice and payment distributions that cross balancing segments by creating offsetting entries for each balancing segment. Automatic Offsets is a powerful feature that greatly affects processing th...

1. Purchase Requisition no JE 2. Request for Quotation no JE 3. We prepare a Purchase Order against best RFQ no JE 4. Goods Receipt(You receive the goods enter a  Goods Received Note (GRN)  in Oracle Purchasing)                Receiving Inventory A/c…………….Debit (Picks from Receipt Accounting options )                AP Accrual A/C………Credit (Picks from Accrual Account of PO-TAB/TAD ) 5. When we are moving the Goods from Staging area to Sub-Inv or Delivery happens/ Put Away                Material A/C..............Debit (Picks from Charge Account of PO-TAB / Cost Accounting Options )                Receiving Inventory A/C......Credit (Picks from Receipt Accounting options ) 6. While Creating the...

Centralized Setup using FSM: Centralized implementation experience using FSM. Central place to enter all setups across products like Financials, SCM, PPM. Revenue Recognition Compliance: Centralized and automated revenue management to address revenue as per ASC 606 and IFRS 15 accounting standard with ability to recognize revenue independent of billing Multi-dimensional reporting . This is a key feature for general ledger. General ledger in the Financials Cloud integrates with Essbase, a multidimensional database that can generate financial statement reports. You can use the data from Essbase using Oracle Financial Studio reports, using Smart View, a spreadsheet tool so accountants can retrieve these reports in a very familiar environment, in Microsoft Excel. File Based Data Import: Seeded functionality to upload high volumes of data. Data conversion can be done using FBDI templates in Cloud without any technical knowledge. Extensive spreadsheet integration . You can create q...

Data Conversion is a process of moving required volumes of data from our clients' existing systems to Oracle Points to note Convert Master Data as well as Transactional Data The conversion of closing balances data as on Cut Off Data in the form of journals in Oracle General Ledger Conversions of open transaction as on Cut Off Date into Oracle Subledger modules like Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing and Inventory. Import of Oracle Subledger Module data into Oracle General Ledger and reversing those entries in GL. Summary of what we convert by module Module Conversion Data AP Supplier/ Supplier Sites Master AP Open Invoices, Debit Memos/Credit Memos and Prepayments AR Customer Master AR Open Customer Invoices, Debit Memos and Credit Memos and Unapplied Receipts CM Bank Master CM Open Bank Statement Lines...

  Role Title Role Name Accounts Payable Manager AP_ACCOUNTS_PAYABLE_MANAGER_JOB Accounts Payable Specialist AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB Accounts Payable Supervisor AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB Accounts Receivable Manager AR_ACCOUNTS_RECEIVABLE_MANAGER_JOB Accounts Receivable Specialist AR_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB Asset Accountant FA_ASSET_ACCOUNTANT_JOB Asset Accounting Manager FA_ASSET_ACCOUNTING_MANAGER_JOB Billing Manager AR_BILLING_MANAGER_JOB Billing Specialist AR_BILLING_SPECIALIST_JOB Buyer PO_BUYER_JOB Cash Manager CE_CASH_MANAGER_JOB Chief Financial Officer GL_CHIEF_FINANCIAL_OFFICER_JOB Controller GL_CONTROLLER_JOB Expense Audit Manager ...