Free Oracle Magazine Profit:The Executive's Guide to Oracle Applications

Enter your e-mail address to receive notifications when there are new posts

Profit Magazine: The Executive's Guide to Oracle Applications

Know 15 important things before you can do Auto lockbox setting

Posted on June 29th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Auto lockbox Implementation been never been an easy task. Though it requires own set up to handle this functionality. Therefore Its is very important to understand some key points before implementing LockBox in Oracle.

  1. How are you identifying the customer against which you apply the receipts? Are you using Auto associate, Customer Number or MICR number?
  2. What do you have for the Match Receipts “By option” in Lockbox? Is this by Customer Bill-to-Site, Customer or Lockbox?
  3. What do you have for Allow Payment of Unrelated Transactions when you submit lockbox and at the system level?
  4. Do you Require Billing Location?
  5. What do you have for Auto cash Rules?
  6. What do you have for Remaining Remittance Amount? Do you want this as unapplied or Onaccount ?
  7. Do you Apply Partial Receipts?
  8. What do you have for Remainder Rule Set? How the setup is done ? Is it at customer site or customer profile level?
  9. What do you have for Allow Payment of Unrelated Transactions?
  10. Do you use Autoassociate?
  11. What do you have for Invalid Transaction Number Handling? This mean how post partial amount as unapplied or you want reject entire receipt?
  12. Are you expecting Miscellaneous Receipt through AutoLockbox?
  13. Is customer expecting some Refunds with negative amount for returns to handled through Lockbox?
  14. Is customer expecting any adjustment through Lockbox?
  15. Are you using Lockbox standard format or have a different format? If not using standard format do you have details for transmission line details?

If you have already some more items need to be added, do share your experiences.:)

dgreybarrowSimilar Post

Posted in Oracle Receivable, Oracle Treasury | 1 Comment »

Understanding Depreciation Books: Back to Basic

Posted on June 15th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Fixed Asset is one of the easiest application in Financial side but whenever its comes to discussion for depreciation, people roll their eyes and shudder. I received lot many emails and offline request for understanding asset tax book and deprecation. This is back to basic subject, an attempt to draw a line in the sand.

In EBS , there are three types of Depreciation Books you can manage:

1 Corporate Book :This is the main asset book type used to hold the Fixed Asset Register in accordance with your corporate policy. The Corporate Book is linked to the appropriate GL Set of Books for journal postings.

The Corporate Book into which the invoice lines from Oracle Payables or Oracle Projects flow. It is the main depreciation book from which journal entries are created for General Ledger.

2 Tax Book : This book type is subsidiary to the your corporate book and is used to hold the same assets as in the Corporate book but depreciate them differently for tax or legal / fiscal purposes.

From the corporate book the transactions can be copied into the Tax Book. It is called tax book because it is generally used to keep the tax depreciation. One can maintain different depreciation methods and life from the corporate book for the same assets. The accumulated depreciation of previous fiscal years can only be adjusted for tax books.

3 Budget Book :This book type is also subsidiary to a Corporate book and is used to hold capital budget information. No actual assets are held in a Budget book. Multiple Budget books can be linked to one Corporate book.

Once you created Budget Book and budget assets, you can run budget reports and project depreciation expense for amounts budgeted to each category. Planning to have another post on Asset Budgeting.

dgreybarrowImplementation Consideration :Steps/process

When setting up the depreciation books, one defines which set of books and therefore which Accounting Flex field/Calendar/Currency will be the basis and for which set of books journal entries will be created. The depreciation and prorate calendar need to be chosen. The current open period needs to be chosen and the method for dividing the annual depreciation amount over the periods in the fiscal year.

The accounting rules have to be chosen and the profit/loss accounts that the account generator will use to create the account combinations. The journal categories for the journal entries in General Ledger have to be chosen.

Asset Calendars are assigned to asset books for purposes of calculating and allocating depreciation expense.

Asset Categories are assigned for use with asset books. All assets are assigned to an asset category which designates accounting information and default depreciation rules for the assets. Depreciation methods are assigned to asset categories.tax book

dgreybarrowCreating a Tax Book

  • Tax books can be created before you add and depreciate assets.
  • Driving factors for deciding tax books is to comply with tax laws .
  • You Can manage multiple tax books that are associated for each corporate book.
  • You can also define independent tax depreciation books for each reporting authority.
  • You can copy assets into each book and depreciate these according to each book’s depreciation rules.

dgreybarrow Entering Information in Tax Books

  • Mass Copy can be used moving corporate book to your tax books automatically .
  • As mention above , you can manage multiple tax book but you need to maintain your asset information in your corporate book, and then update your tax books with assets and transactions from your corporate book.
  • If you choose to copy adjustments, Oracle Assets copies cost adjustments from the associated corporate book if the unrevalued cost in the corporate book before the adjustment matches the unrevalued cost in the tax book. It copies both adjustments that are ADJUSTMENT type in the tax book and adjustment transactions that create a new ADDITION type and update the ADDITION/VOID in the tax book.
  • You should note that initial mass copy is used to initially populate your tax book by adding existing assets to a tax book.
  • Assets and transactions into the tax book can be entered manually.
  • Periodic Mass Copy each period can be used to keep your tax book updated with your corporate book.
  • You cannot copy assets from one corporate book into another corporate book.

dgreybarrow What is the difference between book depreciation and tax depreciation?

Corporate book depreciation is the amount recorded on the “books” and reported on the financial statements. This depreciation is based on the matching principle of accounting.

Whereas , the tax depreciation is recorded on the company’s income tax returns and will be based on the Local Internal Revenue Service’s rules.The IRS might specify that the machine is a 7-year machine regardless of a company’s situation. The IRS rules also allow a company to accelerate the depreciation expense. Accelerated depreciation means taking more depreciation in the first few years and less depreciation in the later years of the machine’s life. This saves income tax payments in the first few years of the asset’s life but will result in more taxes in the later years. Companies that are profitable will find the accelerated depreciation to be attractive.[Apoted]

dgreybarrow Some FAQ

Q. Which Book allows mass copies checked in order for the mass copy to copy.
A. Only the tax book needs to have the allow mass copy checked

Q. How do I disable a Book?
A. You can disable the book is to end date it.The end date The end date is as of today or later and cannot be post-dated.

Q. Can be manage multiple FA Books pointing to a GL book?
A. Yes, you may have multiple FA books tied to the same GL Set of Books.
Create Journal Entries, which is where the interface from FA to GL occurs, is run by individual book in FA.

Q. Can it be possible to push the same payables item into 2 different fixed asset books to get depreciated with 2 different methods?
A. Yes, you can ..If you would create a corporate book and attach a tax book with different depreciation rules. Then you can send the invoice from AP to the corporate book and later mass copy it to the tax book.

dgreybarrowSimilar Post

Posted in Asset, Cash Management, Oracle Treasury | 1 Comment »

Oracle Fixed Asset:Security by Book

Posted on June 13th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

You can manage your Asset Book Security, as mention in one of last post.This Functionality you can

  • Secure access to each depreciation book
  • Create a flexible hierarchy of asset organizations
  • Associate a responsibility with one or more depreciation books

Asset Book Security allows multiple asset books/registers to be manage/administered independently.

Read the rest of this entry »

Posted in Asset, Cash Management, Oracle Treasury | 2 Comments »

FNDLOAD for AME’s

Posted on June 12th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Approvals Management (AME) is a self-service Web application that enables users to define business rules governing the process for approving transactions in Oracle Applications .This enables development of custom rules to manage transaction approvals that is integrated with multiple Oracle EBS applications such as HR, PO, AP and UMX.

If you want to migrate the AME setup like rules,conditions,approval groups etc. from one instance to another instance, you can use some of them by mean of FNDLOAD utility. The process is similar to what we are regularly using for other AOL Objects.

FNDLOAD will have such ldt file through which you can use.

list

You should read the lct first before using any FNDLOAD Command. In the lct, there is an Entity section, where the Entity details are mentioned.Newcomer in OracleApps if you are not familiar with lcts, i would suggest you to go through the DOWNLOAD section and find the bind variables, which are mandatory.

Here are the details steps for each setup’s availability till date.

Read the rest of this entry »

Posted in AOL, Cash Management, Oracle Treasury, Tool | 5 Comments »

Migration of XMLPub Templates :XDOLOADER Utility

Posted on June 11th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

As it is well known fact that XMLPublisher stores the metadata and physical files for templates and data definitions in BLOB columns in its schema. During Development you need to download information from a development instance to a test instance before porting over to production environment.These steps you normally follow:

  • Use the FNDLOAD utility to upload and download the data definition information and the template metadata stored in the Template Manager.
  • Use the XDOLoader utility to upload and download the physical files (RTF, PDF, XSL-FO, XML, and XSD).

dgreybarrowUsing FNDLOAD to Manage Metadata

As per user guide,both templates and data definitions are stored in the database, therefore we can use the FNDLOAD loader to download the metadata for these objects and then to upload this metadata to another instance. The FNDLOAD program requires a control file (lct) as discussed earlier that XML Publisher provides for use with its objects. The file which is used called xdotmpl.lct and it is located under your APPL_TOP directory as follows:

XDO_TOP/patch/115/import/xdotmpl.lct

Read the rest of this entry »

Posted in Cash Management, Oracle Treasury, XML Publisher | 1 Comment »

R12 : Cash Management & SLA

Posted on May 22nd, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

dgreybarrow-2What two program responsible for creating events in R12 CM

They are

  • bank account transfers
  • bank statement cash flows

Once events created and the accounting program is run, the journal entry setup and the accounting configurations are referenced to produce journal entries. The journal entries are then transferred to GL which had visibility upto source transactions. This way CM user can drill down from the transaction level to the journal entry details.

SLA

dgreybarrow-2How it is differ from R11i

In 11i release Cash Management produced journal entries for bank statement activity based on simple rules and sent them to the GL interface

dgreybarrow-2A bit on Bank account transfers

For those who are new to R12, should note The bank account transfer functionality of R12 is one in which you can take action on the projected closing balances calculated by the system. This is integrated with the Payments application that allows you to send payment instructions to the bank in a variety of payment formats.

Posted in Cash Management, Release12 | 1 Comment »

R12 :Bank Statement Reconciliation

Posted on May 22nd, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

We already aware for changes for new Bank Account Model feature of R12.

Lets investigate how bank model drive some changes in Bank statement Reconciliation.

1….R12, Bank Transaction Codes is linked to multiple sources.

In 11i each bank transaction code had to be linked to a single source, such as Accounts Payable. This could create an issue if the bank was using the same transaction code to report back a payment that was initiated from an application other than Accounts Payable. With this enhanced changes link with bank transaction code to sources can easily manage and this way you can assign a priority number which can be used in the auto reconciliation for sequencing.

2..Another feature is Reconciliation tolerances.This R12 feature is moved from the system level to the bank account level. This moves simply means that each bank account can manage unique set or reconciliation tolerances. The options for setting tolerance is still distinct for at both manual and auto reconciliation. You should also note auto reconciliation tolerances is unique with sources, that mean each source like AP,.AR,CM, and Open Interface can have there own level.

3… Most important,now it is possible to use the same bank account, created in the centralized model, in multiple organizations, the bank statement reconciliation can also done across Operating Units.

dgreybarrow-2Underline Setup

Most of setup is now attached at Bank level which includes your Transaction codes. There is provision to manage and assign transaction code to multiple transaction sources.

Another changes you can see in R12 accounts Control in which you can easily manage reconciliation control parameters.

dgreybarrow-2

Post of your Intrest

Posted in Cash Management, Release12 | No Comments »

News: Citibank Japan and Oracle cash management solutions

Posted on May 21st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This is not Oracle acquisition news, rather yet another Big news this morning locally in Singapore for partnership with global bank Citibank Japan and Oracle for enhancing the Oracle Global Cash Management System,that provide a integrated solution for managing Cash Management for global manufacturing operations, retail, transportation, financial services sector of Japanese clients.

“Oracle Global Cash Management System” is SOA based product of Oracle Japan used for managing group corporate finance, fund management and financial risk management, financial transaction management function.

Some of the important Fund management features that product offers are : centralized group of companies in the financial management of pooling funds, payments to suppliers to pay a centralized agency, balances between group companies to make the difference between the settlement and netting capabilities.

“Oracle Global Cash Management System” available for local clients since October 1, 2007 with price tag 15 million yen for 4-user license,supported with most of available platforms(AIX, Solaris, HP-UX, RedHat Linux, Windows).

read this entire story

As need for banking Integration is greatly felt in corporate world, and Lets hope, this might bring some more banking functionality in next releases of Oracle EBS ..what you say…

Posted in Cash Management, News, Oracle Treasury | No Comments »

XML based statement for Cash Management

Posted on May 21st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

One of reader from Mid-east region asked one question “does Oracle support XML based Bank statement?”

It was/is really a new area , just brought attention this afternoon and I did manage to run through Oracle user guide as well as some of the release note of 11i Financial Family pack D(ce minipack H).

What I understood from Oracle Documentation is ..If your bank delivers previous day account statements in the IFX XML format, you can manage the XML bank statement by setting up Oracle XML Gateway to receive and process these bank statements using a secure internet connection.

Oracle XML Gateway is seeded product that comes in bundle and used to validates the XML messages if they follow IFX Release 1.2 specifications . Oracle CM does have predefined mapping rules that take care of loading apart from BAI or MT940 format.Once record is successful validated, Oracle XML Gateway push the data into bank statement open interface tables and kick the bank statement import program to transfer the bank statement information to Oracle Cash Management.This is integrated by workflow.

If you have plan to use XML statement feature of bank interface then you must requires Oracle XML gateway, Oracle advance queuing (AQ) product and Oracle Transport agent. The user guide have step by step procedure of enabling this out of box functionality.

dgreybarrow-2Reference

  • Note:216560.1:About Oracle Cash Management in Financials Family Pack D

dgreybarrow-2Going Forward

XML Bank statement is relatively a new area as far as advance countries like US,Europe, Australia, Singapore, Hongkong where presence of most of the global bank still prefer to provide in BAI or SWIFT format. If anyone get a chance to implement XML , its is good to share your thoughts …:)

Posted in Cash Management | 3 Comments »

Implementing SWIFT MT’s within EBS

Posted on May 20th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Companies to Banking partner connectivity and online information exchange has long been an issue for many reasons for so many years. Driven by tighter regulation and the need for better cash management and effective working capital management prompt Treasures to explore more areas so that they can get better insight into their cash positions and forecasts. As mention in last post globalization, Single instance strategy, global bank model, multi-cash feature provided by banks, centralization and standardization of finance processes that makes finance department to explore more in this area. Integration with any banking partner solutions either interacting with third party netting system or Sending a simple wire payment instructions to bank, you does requires a very tight integration with your accounting system.

Read the rest of this entry »

Posted in Cash Management, Oracle Application, Oracle Treasury | No Comments »

« Previous Entries