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 | 5 Comments »

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 | 8 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 »

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 »

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 »

Managing Cash , EBS and SWIFT

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

In last couple of years, IT and Internet open the new door not only to IT Finance Managers but also Corporate Treasurers .The role of treasurers is more demanded and expectation with their banking partner have been greatly increased Changing Banking Relationships, Single Bank Model ,globalization , SWIFT corporate access and XML and end to end Integration with In house accounting system are some of the key points that enforce treasury department to look options with usage of Technology by either in building custom online applications or integrated and modified products From commercial vendors of ERP.

Lets start the topic of Treasurer Dilemma for exploring Integration of Oracle ERP with SWIFT Network.Here is one of case where treasurers seeking information with Oracle.

greyBarrowBackground

- Currently using Oracle E-Business Suite and planning to generate e-files from AP and Treasury modules and transfer it to SWIFT.
- Came to know that many messages stating that Oracle is developing some applications that would help integrate the e-business suite with SWIFT.
- As Oracle Treasury has the ability to generate MT 100. ( Assume AP has this functionality).

Read the rest of this entry »

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

Are you seeking auditing ability in EBS…use ‘AuditTrail’

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

greyBarrowWhat is an AuditTrail?

An AuditTrail is one of functionality for retaining a history of changes to data. What ,who and when can be identified on a particular table or column if the functionality is enabled.

When you enter or update data in your forms, you change the database tables underlying those forms. An audit trail tracks which row in the database was updated at what time, and which user was logged in using the associated form(s).

If you are seeking auditing ability to track changes on a particular table of Oracle this post might helpful to you.

greyBarrowEnabling the Functionality of AuditTrail

You can turn AuditTrail on or off (Yes or No). Normally the default setting is No (Off). When you enter or update data in your forms, you change the database tables underlying the forms you see and use. AuditTrail tracks which rows in a database table(s) were updated at what time and which user was logged in using the form(s). Also..

  • Several updates can be tracked, establishing a trail of audit data that documents the database table changes.
  • AuditTrail is a feature enabled on a form-by-form basis by a developer using Oracle’s Application Object Library.
  • All the forms that support AuditTrail are referred to as an audit set. You should also note not all forms may be enabled to support AuditTrail.
  • To enable or disable AuditTrail for a particular form, you need access to Oracle Application Object Library’s Application Developer responsibility.
  • Users cannot see nor change this profile option.
  • This profile option is visible and updatable at the site and application levels.

 

audit

The internal name for this profile option is AUDITTRAIL:ACTIVATE.

greyBarrow Setting Up AuditTrail(>11i )

You can choose to store and retrieve a history of all changes users make on a given table. Auditing is accomplished using audit groups, which functionally group tables to be audited. For a table to be audited, it must be included in an enabled audit group.

greyBarrowThe steps for setting up AuditTrail include:

Yuu need to verify Select Privileges on SYS.DBA_TABLES

Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally, this step would Normally taken care during the installation of Oracle.

greyBarrowDefine Audit Groups

This is very very important.These are groups of tables and columns, where you do not necessarily need to include all the columns in a given table. You enable auditing for audit groups rather than for individual tables. You would typically group together those tables that belong to the same business process (for example, purchase order tables see at the end).

A given table can belong to more than one audit group. If so, the table is audited according to the highest “state” of enabling for any of its groups, where Enabled is the highest, followed by Disable Dump Data, Disable No Growth, and Disable Purge Table, in that order.

Navigation: Security -> AuditTrail -> Groups

greyBarrowDefine Audit Installations

You choose the registered Oracle IDs at your site that you want to audit. This allows you to audit across multiple application installations. When a table is added to an audit group, auditing will automatically be enabled for all installations of the table for which audit is enabled.

Navigation: Security -> AuditTrail -> Install

greyBarrowRun the Audit Trail Update Tables Report to Enable Auditing

Your AuditTrail definitions (and auditing) do not take effect until you run the Audit Trail Update Tables Report. If you change any of your definitions later, you must rerun this program. You run the Audit Trail Update Tables Report from the standard submission (Submit Reports) form.

greyBarrowAudit Trail Update Tables Report

This program creates database triggers on the tables in your audit groups for your installations. It also creates shadow tables, one for each audited table, to contain the audit information. If you have changed your audit definitions or disabled auditing for an audit group, the program drops or modifies the auditing triggers and shadow tables appropriately.

The program also builds special views you can use to retrieve your audit data for reporting.

You can check SQL*Plus to see if the Shadow Tables have been created or not. Shadow Table name is the same 26 Characters of the Table being audited followed by a suffix of “_A” ,suffix of “_AI” for Insert Triggers, “_AU” for Update triggers , “_AD” for Delete Triggers,suffix of “_AIP” for Insert Procedures “_AUP” for Update Procedures and “_ADP” for Delete Procedures.

greyBarrow AuditTrail Limitations

These are limitation of AuditTrail:

  • Your table should consist of maximum 240 columns
  • You cann’t use the column for audit trail whose data type is LONG, RAW, or LONG RAW
  • Your audit group must include all columns that make up the primary key for a table; these columns are added to your audit group automatically.
  • Once you have added a column to an audit group, you cannot remove it.
  • AuditTrail requires two database connections. If your operating platform does not automatically support two database connections
    (e.g., VMS or MPE/XL), then add the environment variable ‘FDATDB=<database connect string>’ to your environment file.
  • Because the structure of the audited table may change between product versions, AuditTrail does NOT support upgrading existing shadow tables or audited data. Before an upgrade, you should archive the shadow tables and perform all necessary reporting on the audited data.
  • Oracle recommended Disabling AuditTrail feature Prior to Upgrade to higher version.
  • If your plan is to use some auditTrail on table which name is bit longer(> 26 characters), you can’t achieve this. As there is Bug(#3872242
    ) reported by Oracle that restrict you from this, as AuditTrail Update Tables Errors out on audited tables that are > 26 characters.

Sometime back we found while enabling this on these tables.

  • PO_REQUISITION_HEADERS_ALL
  • PO_REQUISITION_LINES_ALL
  • PO_REQ_DISTRIBUTIONS_ALL

greyBarrowWhat are the primary Auditing Tables?

  • FND_AUDIT_COLUMNS
  • FND_AUDIT_GROUPS
  • FND_AUDIT_SCHEMAS
  • FND_AUDIT_TABLES

greyBarrowClient Dilema : HOW TO ENABLE AUDITING AT “FORMS” AND “USER” LEVEL TOGETHER

Customer has set the profile “Sign-on: Audit Level” to FORMS to collect information about the forms sessions at a particular time .
By default the value for this profile was USER.
Since he has set the value to Forms can he collect the User related information

Yes you can …
If the profile “Sign-on: Audit Level” is set to FORMS then it will collect Form sessions information in addition to user session information.
So you will get information related to User session as well as forms session. There is no harm in setting this profile value to FORMS.

Posted in AOL, Cash Management, EBS Suite, Oracle Application, Oracle Treasury, Tool | 1 Comment »

Page 1 of 11