Oracle Fusion Cloud/EBS Knowledge Sharing Blog

Auto Lockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank.  The Oracle AR module provides a capability to automate your lockbox process by integrating with the bank. Oracle Cloud can consume the lockbox file that banks share and create receipts automatically for different customers using this data. These receipts can then be applied to the corresponding transactions based on the Auto-Match and Auto-Cash rule sets. Thus, it eliminates any requirement for manual intervention. Advantages Process Receipt Batches daily basis Speedup Collection Process Convert receivables into Cash more effectively Lockbox Process has three steps: Import Data : Lockbox reads and formats the data from your bank file into the interface table from the data uploaded using the Receivables Standard Receipt Import FBDI Template. Validate Data : Lockbox validates the data in the interface table for compatibility then transfers the data to the receipts tabl...

In AR, we can send copies of the invoice to customers automatically. Some setups need to be done to send Transaction Copies Delivery using E-Mail. Configurations required: Update “Transaction Delivery Using Email settings” at Receivables System Options Setup Assign Preferred Delivery Method as Email in Customer Profile Update Customer Contacts at Communications tab  Add “Role Type” as “Contact”, Add Email Contact Point and Responsibility Type should be “Bill To” Process to run: Run ESS Job “Print Receivables Transactions” (Master program that initiates other child programs which prints transactions or delivers transactions using email) Manage Receivables System Options Setup Use the Transaction Delivery using E-Mail section of the Billing and Revenue tab of the  Receivables System Option  pages to set up the details of transaction delivery using e-mail for the applicable business units. Enter these values in the corresponding fields: From Name: Name of your enterprise. Fr...

Some of us are still confused with O2C journals, especially on the Receipts side. I am trying to clarify the same here. If you need to understand the complete flow and journals of O2C you can refer to the same in my blog which I already posted before.   Let me explain how the receipts are accounted for using different remittance and clearance methods. Receipt with no Remittance and clearance method By Matching When creating Receipt Remitted Cash A/C…..Debit Unapplied Cash A/C…......Credit When applying receipt to open invoices Unapplied Cash A/C…...Debit Receivables A/C…....Credit When reconciling in Cash Management Cash A/C….....Debit Remitted Cash A/C…...Credit Receipt with Remittance When creating Receipt Confirmed Cash A/C……………Debit Unapplied Cash A/C…......Credit ...

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...

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. § ...

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...

The Order to Cash flow is the complete process of entering an order into the system (Sales Order), delivery the good(s) (Shipping), and then producing the Invoice for the goods.  O2C Flow: Modules Involved O2C Process Steps Receive Sales Order Book Sales Order Pick Release Ship Confirm Sales Returns Sales Invoice Receipt Reconciliation Book Sales Order : Booking of the Sales order is done through Order Management and as the order progresses, users can track the status of the order. Pick Release : Moving stock from Sub Inventory to Staging Area.  Pick Release finds and releases the order and creates a move order request. The process of transacting move orders creates a reservation against the source sub inventory. Ship Confirm : Moving stock from staging to customer address.  Ship confirm is the process of confirming that items have shipped. Shipping Execution confirms that the delivery lines associated with the delivery have shipped. Sales Returns : if are ...

I am going to explain about Customer Numbering in this post.  When we create customers in Oracle, system automatically creates the customer number. Customer number is the unique number assigned for each customer when it is created. We can also set our custom sequence for the customer number in Oracle. How to set Customer Numbering for Party, Account and Site levels? Best practice is to have 1XX series for Party, 2XX series for Account and 3XX series for Site. Generally clients have same series across application, we can still have customer numbering generated at LE/Ledger level(this is very unlikely). This can be achieved by selecting determining type while defining document sequence. Clients generally go for same series across application. Task: Manage Document Sequences BILLING_ACCOUNT_NUMBER = Customer Account Number PARTY_SITE_NUMBER = Customer Site Number REGISTRY_ID = Customer Party/Registry Number BILLING_ACCOUNT_SITE_USE_NUM = Site Uses Number How to ove...

Name Description Bad Debt Provision Report Provides information for reviewing bad debt exposure and provisioning based on percent collectible assigned to the customer. Includes transaction number, balance due amount, and bad debt provision amount in the ledger currency. Invoices Posted to Suspense Report Provides a list of all transactions that have revenue amounts posted to suspense accounts as a result of running the Import AutoInvoice process. Includes information on transaction class, customer, transaction date, and transaction amount by business unit. Potential Reconciling Items Report Provides a list of journal items that may potentially post to incorrect general ledger accounts. Includes customer account number, payment number, transaction number, and credit and debit amounts by reporting level, reporting context, accounting date, and balancing segment. Billing His...