Oracle Fusion Cloud/EBS Knowledge Sharing Blog

Some common interview questions What is your role in last implementation project? What are the critical issues you handled? How did you gather requirements? Explain the Enterprise Structure for your last project Explain the process of Data Conversion Period Close Process for all modules How to configure approval rules in BPM COA Structure Vs Instance Revaluation vs Translation CVR Vs Security Rules Types of Ledgers(PL, SL and RL) and their conversion levels What are the four Cs Mass Allocations with business use case P2P and O2C process with Journals Mandatory setups in AP for Invoicing and Payments Ways to create invoices Types of AP invoices Invoice Match Levels Multi Period Accounting Prepayment process with journals Unable to cancel invoice what could be the reasons What is PPP and PPR WHT and setups Auto Accounting Rules and various sources available Transaction Types and Importance of Transaction Sources Auto Invoice Setups and common issues Different statuses of receipts Auto Lo...

Multiperiod Accounting (MPA) in Oracle Fusion is a feature that allows users to create accounting entries for a single financial event across multiple accounting periods. It can be useful for situations where a single transaction spans multiple accounting periods, such as prepaid expenses. There are certain expenses which are incurred once but you want to apportion those expenses over a period of time. Ex: Software licenses, if you purchase a software license which is valid for one year. Setups Required : In case we want to use Pro-rate expenses by number of periods we don’t to need to configure anything, this is a default setting. If you want apportion the expense based on a number of days in a month, then custom SLA setups are needed. MPA Process Steps Create AP Invoice Provide Multiperiod Account details like Start Date, End Date and Accrual Account  Validate and Account the invoice Run “Create Multiperiod Accounting” program View Accounting to check the Accounting Entries Creat...

What is an Adjustment in Fusion Receivables? An adjustment is a manual or automatic billing update that increases or decreases the balance on a transactions such as an invoice, debit memo, chargeback or a credit memo. We can  make either positive or negative adjustments to your invoices.   We can approve adjustments that are within approval limits and give pending statuses to adjustments that are outside approval limits. We can automatically write off debit items that meet specific selection criteria. Configurations required: ·        Setup Approval limits for User - Approval limits are going to determine whether a user can approve adjustments. These are defined by document type, amount and currency. §   A document type - can be adjustment, or it can be something like credit memo refund or receipt write off. §   Amount - Amount can be part of a defined range. the range can go from a negative number to a positive number. § ...

What is Chart of Accounts Structure? The Chart of Accounts (COA) is the account structure the organization uses to record transactions and maintain financial account balances. GL defines the COA structure in the Accounting Flexfield. The structure enables the organization to categorize accounting information during the recording process. We are generally confused about about COA Structure and COA Structure Instance in Oracle fusion. Let us try to understand the significance of both Chart of account is called accounting flex field and is used for financial reporting of an organization. In chart of account you have to define your segment. Segments are different dimensions of a business. They capture the different element of a business for financial reporting purpose. For example Company, Accounts ,cost center, Product line etc. capture the financial position of a company with different reporting tools. In each segment of Chart of Account you have to mention two important things-...

Oracle Fusion has provided a feature to migrate OTBI reports from one Instance to another Instance. Source code migration is very easy process in Oracle fusion. Migration process helps in Cloud Implementation projects where we have to migrate hundreds of reports from one instance to another instance like from Dev instance to Prod instance. This is one of the great feature for OTBI reports migration. Step1: Go to the OTBI Report which you want to migrate from one Instance to Another. Step2: Select the OTBI Report. Go to Source Instance(means from which instance you want to migrate) Select report and click More. Click on Archive System will ask these below options that if you want to keep same permissions like this instance then you should check this checkbox. like the same for Timestamps. Check both and click Ok It will be saved. You can save this report in your local desktop. Step 3: Go to the Target Instance in which we want to migrate this Report Source Code. This is the Folder...

There could be a business requirement in any organization where in the bank account information should not be displayed completely for all the users, only the users who setup the bank account might have or should have access. Only last few or first few digits of the bank account to be displayed and remaining digits should be masked. We have different setups for internal bank accounts and external bank accounts masking. Internal Bank Accounts Masking Internal Bank Accounts are those we use to make payments to suppliers or to receive cash collections from customers. Set the profile option “Mask Internal Bank Account Numbers” using Task “Manage Cash Management Profile Options” Setup Go to Setup and Maintenance à Search à Task: Manage Cash Management Profile Options Search This can be set at Site level and we would like to set the “Display Last Four” and remaining to be masked. Save and Close à Done Go to Internal Bank Accoun...