Tuesday Jan 12, 2016

Unplanned Depreciation in Fixed Assets

Unplanned depreciation is used in Fixed Assets to handle unusual accounting situations in which the net book value (NBV) and accumulated depreciation amounts for an asset need to be adjusted without affecting the asset cost.

There are some rules for using unplanned depreciation.  These include:

  • You cannot allocate unplanned depreciation amounts to specific distributions, as you can in a distribution set.
  • You cannot make expensed adjustments to assets for which you have previously entered unplanned depreciation and have since amortized the amount.Calculator
  • You can apply unplanned depreciation to assets using flat rate or units of production methods, in addition to straight line methods.
  • You cannot perform a mass change or prior period retirement for assets that have unplanned depreciation.
  • If you have run preliminary depreciation and then enter unplanned depreciation, the unplanned transaction functions as a rollback event.  Therefore, you cannot use unplanned depreciation as a negative adjustment of depreciation in the period of addition.
  • Unplanned depreciation can only be entered if you are using a table based or flat rate method.  For an asset using some other type of method, you will have to change the method first.

To enter an unplanned depreciation, navigate to the Asset Workbench:

1.  Select the asset for which you want to enter unplanned depreciation and click the Books button.

2.  In the Books window, enter a book.

3.  Enter a reason for the unplanned depreciation in the Comments field as needed.

4.  When you navigate to the Depreciation zone, you will see that the amounts will pop up. Click the Unplanned Depreciation button.

5.  In the Unplanned Depreciation window, select the unplanned depreciation type.

6.  Enter the unplanned amount as a positive or negative currency.

7.  Enter the unplanned depreciation expense account.

8.  Select the Amortize From Current Period check box. Leave this box clear if you want to amortize the remaining net book value in a subsequent period.  [The value of this check box overrides the value of the Amortize Adjustments check box in the Books window.]

9.  Click Done to save your work.

For additional information, view the document:  Unplanned Depreciation In Oracle Assets (Doc ID 114298.1).

Tuesday Oct 06, 2015

Which Transactions Are Copied Via Fixed Assets Mass Copy?

Which transactions does Fixed Assets copy from the corporate book to the tax book via the Mass Copy process?  Which kinds of transactions do not get copied?  How can you determine which transactions were not copied using the warning messages found in the Mass Copy logfile? 

Let's take a sample message indicating that a transaction could not be copied using Mass Copy:

Asset number 123456
Transaction header id 789789
This adjustment cannot be mass copied.

Cause: Only cost adjustments, salvage value, production capacity or group asset changes can be copied.
Action: Manually adjust this asset in the Tax Book.

Use this data to review the transaction that is NOT Mass Copied from the corporate book.  Note that the transaction header id is used for the Reference Number.

  1.  Login to FA
  2.  Navigate to:  Inquiry > Transaction History
  3.  Select the corporate book from the LOV
  4.  Enter the transaction header id from the logfile into the Reference Number field
  5.  Click FIND

The form will show the transaction type that was not Mass Copied.
Click DETAILS and the Before and After data is shown for the transaction.

Book-specific changes are intentionally NOT Mass Copied such as depreciation method, life, prorate convention, etc.  These fields are not Mass Copied because it is expected functionality that the tax books can have depreciation different from the corporate book.

Refer to the Oracle Assets Users Guide
Chapter:  Tax Accounting > Tax Book Maintenance

So, what does get copied?

The following basic financial information comes from the corporate book:

  •  Cost
  •  Original Cost
  •  Units
  •  Date Placed in Service
  •  Capacity and unit of measure, for units of production assets
  •  Salvage Value, if you choose to Copy Salvage Value for the tax book in the Book Controls window

The remaining depreciation information comes from the default category information for your tax book according to the asset category and the date placed in service.

With credit to Kathleen Herd, Oracle Assets Support

Friday Aug 07, 2015

Overview of Physical Inventory in Oracle Assets

Physical inventory is a critical business process through which a successful enterprise periodically inspects its assets to protect its large capital investments and to comply with auditing requirements.  Physical inventory is the process of ensuring that the assets a company has listed in its production system match the assets it actually has in inventory.  It also ensures that capital assets recorded in the Fixed Assets Accounting and Control System physically exist, determines if unrecorded or improperly recorded transactions have occurred, and identifies any excess, defective or obsolete assets on hand.  An effective inventory results in an accurate accounting of capital assets, and indicates the reliability of the system of accountability for the acquisition, use, and disposal of those assets.

How this works in Oracle Assets:flowchart

Oracle Assets is a worldwide best practice tool which automates the physical inventory process to minimize administrative costs.  The Physical Inventory feature in Oracle Assets assists you in comparing and reconciling your physical inventory data with the data loaded in Oracle Applications.  This flow chart gives an overall picture of how physical inventory functionality works in Oracle Assets. 

The standard steps are:

  1. Collect the actual asset details like asset tag number, asset number, units, etc. owned by each department.  This is normally done by the physical inspection of the assets owned by each department.
  2. The second step would be to load the physical inventory details / actual asset details collected through the physical inspection into the FA_INV_INTERFACE table.
  3. Run the physical inventory Comparison Report which compares the actual asset details with the data loaded in the FA_INV_INTERFACE table.
  4. View the comparison details which will provide the details of assets which are different and the assets which match between the application and the physical inventory.
  5. Take the necessary actions to match the data in the application to the actual data.

A detailed discussion of the physical inventory functionality in Oracle Assets, the required setups, the different ways physical inventory details can be loaded to the interface table (FA_INV_INTERFACE), and how reconciliation happens can all be found in the document:   Physical Inventory Overview in Oracle Fixed Assets (Doc ID 2003290.1)

With credit to Vaishali Karanth, Oracle Assets.

Wednesday Jul 01, 2015

Revaluation in Fixed Assets

Oracle Assets allows you to periodically adjust the value of your assets due to inflation or deflation, according to rates you enter.  This process is known as revaluation.  The rules for revaluation often differ from country to country.  Oracle Assets has the flexibility to handle your specific requirements.

Revalue assets to adjust the value of your capitalized assets in a highly inflationary economy.  You can revalue all categories in a book, all assets in a category, or individual assets.  You can revalue all assets using the Mass Revaluation process.  The Mass Revaluation process does not use price indexes to revalue assets.

Reval Flow Oracle Assets multiplies the asset cost by the revaluation rate you enter in the Mass Revaluations window to determine the adjustment to the asset cost. 

Revaluations are not processed for:

  • Fully retired assets
  • Assets with pending retirements

Since Oracle Assets does not Mass Copy revaluations, when you perform a revaluation in your corporate book, also perform it in each tax book associated with that corporate book.

To process revaluations, revaluation accounts and revaluation rules must be set up.  The default revaluation rules that are set up for a book can be overridden when creating a revaluation definition in the Mass Revaluations window.

You will need to consider whether or not to revalue accumulated depreciation.  You can revalue fully reserved assets that are depreciating under a life-based method.  If you choose to revalue fully reserved assets, you would need to enter a life extension factor to extend the asset life.  To revalue a retired asset, you would need to first reinstate it.  You can also revalue CIP assets, but only for a tax book.  A ceiling can be set to prevent revaluation above the fair market value.

To assist in these, and other revaluation considerations and setups, there is a new white paper available.  In addition to setup steps, this white paper provides the steps for performing revaluations as well as sample calculations for different scenarios.  You can review the document to understand how different book control settings might affect the revaluation calculations.  What might be expected if you decide to revalue accumulated depreciation?  Or, perhaps you only want to revalue year-to-date (YTD) depreciation?  Or, what might the revaluation amounts look like if you amortize the revaluation reserve?

The Revaluation in Oracle Assets White Paper can be found in Doc ID 2018027.1.

Friday May 29, 2015

Depreciation Calculation Considerations in Fixed Assets

There are many variables that can affect the depreciation calculation for an asset.  Some of the basic variables include: 

  • Cost Financial Inquiry
  • Depreciation method
  • Date Placed in Service (DPIS)
  • Prorate convention
  • Prorate date

You can view these variables for an asset via the Financial Inquiry form and make changes to these via the Asset Workbench / Books form.

Additional factors in the calculation of depreciation for an asset include:

  • Specifics of the depreciation method
  • Depreciation calendar
  • Depreciate when placed in service flag
  • Dividing depreciation evenly or by days
  • Other specifics of the prorate convention
  • Prorate calendar

Some of the factors that seem to cause more confusion than others surround the allocation (divide evenly or by days) setting on the Book Controls form and the the prorate information.

If the book is set to divide depreciation evenly, the annual depreciation for the assets will be divided evenly over the number of periods in the fiscal year.  If the book is set to divide daily, the annual depreciation will be divided based on the number of days of the periods in the fiscal year, with the amount of depreciation varying in each period.  For sample calculations of depreciation using "Divide Depreciation By Days" (the less common scenario), review the Depreciation Methods White Paper found in Fixed Assets Depreciation Methods and Calculations With Examples (Doc ID 1179655.1).  There are a number of examples using different parameters, starting on page 25.  Look for those that use "Depreciation Allocation" = "Daily."

For prorates, the prorate calendar determines the number of prorate periods in your fiscal year.  The depreciation program uses the prorate calendar to determine the prorate period, which is used to determine the annual depreciation amount.  The prorate convention is used to determine how much depreciation to take in the first and last years of the asset's life.  Together with the date placed in service (DPIS), the prorate convention helps to determine the prorate date.  For example, if you use a prorate convention with a defined period of 1-JUN-2015 to 30-JUN-2015 and a corresponding prorate date of 30-JUN-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the current month of June.  If the prorate convention, instead, is set to a defined period of 1-JUN-2015 to 30-JUN-2015 with a prorate date of 01-JUL-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the following month of July.  Thus, the prorate date is tied to the DPIS, but the DPIS might not be when the asset starts depreciating.  Examples of varying prorate setups can be found in the white paper in The Wonderful World of Prorate Conventions White Paper (Doc ID 115323.1) 

Monday Apr 13, 2015

A Brief Discussion of Globalization Profile Options

If you are setting up country-specific globalizations and you use custom responsibilities, then you may need to know about the profile options you would set upGlobe for a non-multi-org product such as Fixed Assets.  For each custom responsibility that uses windows with country-specific or regional features that belongs to a non-multi-org product, you must set the JG: Application, JG: Territory, and JG: Product profile options.  Note:  You do not need to set these profile options for multi-org products such as Payables and Receivables, which make use of the organization field.

These globalization profile options are:

  • JG: Application:

Used to determine which Oracle Applications product the responsibility is associated with.  The list of values for this profile option consists of a complete list of Oracle Applications products.

  • JG: Territory:

Used to determine which country the responsibility is associated with.  The list of values for this profile option consists of a list of countries.

  • JG: Product:

Used to determine which Global Financials product the responsibility is associated with.  The list of values for this profile option consists of a list of Global Financials products.

You will find additional information about globalization setups in the Oracle® Financials Country-Specific Installation Supplement.

Monday Mar 09, 2015

Mandatory Post Patch Required for Fixed Assets Feb 2015 RPC

UPDATE 3/23/2015: Fixed Assets Development has now combined the two patches (the former RPC and the mandatory post-RPC) into one patch. They have re-released the Feb 2015 FA RPC under this new, combined patch.  The new RPC patch number is 20687418:R12.FA.B.

IMPORTANT UPDATE 3/13/2015: Fixed Assets Development will be combining these two patches (the RPC and the mandatory post-RPC) into one patch. They will re-release the Feb 2015 FA RPC under this new patch number. Watch this blog for the announcement of that new RPC patch number, when released. Thanks!

There is now a mandatory post-RPC patch (Patch 20530852 - Do Not Allow Changes To Other Financial Details Along With Depreciate Flag) for Fixed Assets that has to be applied after the Fixed Assets Feb 2015 RPC.  Development discovered an issue due to the fix made in 19933377:R12.FA.B, which has now been obsoleted, but was included in the RPC.  The issue in that bug was certain valid transactions were not allowed to go through.  However, after the fix, transactions that should be prevented also got through.  These transactions will cause data corruption in the product.  The issue typically occurs when customers change multiple fields when performing an adjustment such as depreciate flag and cost, but this could be any combination of multiple changes during a single adjustment transaction.

The Readme for the RPC - R12.1: Fixed Assets Recommended Patch Collection, Feb 2015  (Doc ID 1983884.1) has been updated to reflect this mandatory patch.  If you have downloaded the Fixed Assets Feb RPC Patch 20183189, please also download, test and apply the post-requisite Patch 20530852.

Thursday Jan 22, 2015

Obtaining Bonus Depreciation Methods for Oracle Fixed Assets

Are you looking for bonus depreciation methods for Release 12?  These could be depreciation methods used for the Jobs and Growth Tax Relief Reconciliation Act of 2003 or for the American Jobs Creation Act of 2004

Bonus depreciation methods are generally made available via a patch after the enactment of new laws.  In R12, bonus depreciation methods were made available for R12.0 (R12.FA.A) via Patch 6511705:R12.FA.A.  These methods were made available for R12.1 (R12.FA.B) via Patch 6511705:R12.FA.B.

As R12.2 was released well after the enactment of these laws, a later patch was created for delivery of these bonus depreciation methods.  For R12.2 (R12.FA.C), apply Patch 20012197:R12.FA.C.

 For reference, please review the documents:

  • R12 and R12.1 Seeded 30% 50% Bonus Depreciation Methods Missing In New Install (Doc ID 561517.1) and 
  • How To Obtain The 30%, 50% and 100% Bonus Depreciation Methods For Release 12.2.3 Of Oracle Assets? (Doc ID 1955574.1).

Wednesday Dec 17, 2014

An Insight Into Asset Impairment

Why would you have an asset impairment? 

An asset impairment is a situation in which the usefulness of an asset suddenly declines, making it so expensive to maintain that it can no longer be expected that it will pay for itself through future cash flows.  A company can choose to maintain the asset on its books but write down the value to more accurately reflect its value, or it can list the asset for sale and dispose of it.  Once an asset is impaired, it cannot be recovered.  Therefore, companies should test assets before placing them in this category.

IAS 36 Impairment of Assets seeks to ensure that an entity's assets are not carried at more than their recoverable amount (i.e. the higher of fair value less costs of disposal and value in use).  With the exception of goodwill and certain intangible assets for which an annual impairment test is required, entities are required to conduct impairment tests where there is an indication of impairment of an asset.  The test may be conducted at the asset level or for a 'cash-generating unit.'

What is an impairment?

If the recoverable amount of an asset is less than the asset’s carrying amount:
•  The asset is impaired
•  The asset’s carrying amount should be reduced to the recoverable amount
What is the recoverable amount of an asset?

The recoverable amount of an asset is the greater of:

1.  The net selling price of the asset or
2.  The asset’s value in use

An example:

   Asset A  Asset B
 Cost  1000  1000
 Accumulated Reserve  400  400
 Carrying Amount  600  600
 Recoverable Amount  900  400
   Asset not impaired

 Asset is impaired - reduce the carrying amount

 When does an asset need to be impaired?

There are several circumstances under which an asset can become impaired. 

There can be external sources such as:

•  Market value declines
•  Negative changes in technology, markets, economy, or laws
•  Increases in market interest rates

Or internal sources:

•  Obsolescence or physical damage
•  Asset is idle, part of a restructuring or held for disposal
•  Poorer economic performance than expected

Which assets can be impaired?

IAS 36 applies to:

•  Land
•  Buildings
•  Machinery and equipment
•  Investment property carried at cost
•  Intangible assets
•  Goodwill
•  Assets carried at revalued amounts under IAS 16 and IAS 38

How does impairment work in Oracle Assets?

These are the processes for creating, posting and managing asset impairments in Oracle Assets:

•  Assigning Cash-Generating Units to Assets (optional)
•  Entering and Uploading Asset Impairments
•  Updating Asset Impairments
•  Reviewing Asset Impairment Reports
•  Posting Asset Impairments
•  Viewing Asset Impairments
•  Rolling Back Asset Impairments
•  Deleting Asset Impairments

For details on each of the above steps, reference the Impairments White Paper in Doc ID 461834.1.

With credit to Vaishali Karanth, Oracle Assets

Monday Nov 17, 2014

How FA and GL Calendars Work Together in R12 Versus R11i

Both FA and GL have calendar setups.  How do these setups work together?  In R11i, Assets maps the calendar period to GL using an exact match of period name.  If your GL period is SEP-14 for September 2014 (as an example), then your FA September 2014 period has to be called SEP-14 as well.  Any variance, even Sep-14 rather than SEP-14, will cause the posting from Assets to GL to fail.  Then you have to log a Service Request (SR) to get that data mismatch fixed.calendar

One data mismatch you don’t have to worry about in 11i, though, is if you have set the actual period of September 2014 to have different dates in FA and GL.  For example, say your FA September 2014 period runs from 01-Sep-2014 to 30-Sep-2014, but in GL it runs from 31-Aug-2014 to 27-Sep-2014.  Since FA doesn’t check those dates, there is no issue posting depreciation amounts dated in FA on 30-Sep-2014 into the GL September period.  As long as the period names are the same, the dates don’t matter.

Now you upgrade to R12.  Assets no longer maps by period name.  In fact, it does not control the selection of the GL period at all.  SubLedger Accounting (SLA) does.  Now it no longer matters if the period names are the same or not, but the calendars matter a lot. 

Take this example:

1.  You run depreciation on September 30th.  Assets creates the rows in the depreciation tables and also inserts a row in xla_events with an event_date of September 30th.  That row is in U/U (Unprocessed / Unposted) status.
2.  You then run Create Accounting.  It picks up that row in xla_events with the September 30th event_date and it maps that date to the GL calendar.  It finds that September 30th is in the October period in GL, and it then sets the field xla_ae_headers.period_name to OCT-14.
3.  You review your postings in GL after Create Accounting has completed, and you find September’s depreciation in October’s period.

This is why it is highly recommended that you consider aligning your FA and GL calendars in R12.  

Here are the basic rules you will encounter for Assets' choice of event_date:

a.  If the event is added in period A and has a DPIS or other effective date of earlier (ex:  a backdated addition or backdated retirement), the event_date will be the first day of the open period.
b.  If the event has an effective date within the period, that date is normally used.  For example, an asset added in September with a DPIS of September 10th will have an event_date of September 10th for the addition’s accounting.
c.  Depreciation works a bit differently since it doesn’t really have an effective “date” so much as a period.  You will find:

  • If you run depreciation on a sysdate later than the last day of the period, you will get the last day of the period as the event_date.
  • If you run depreciation on a sysdate that falls within the period, you will get the sysdate as the event_date.
  • If you run depreciation before the first day of the period, you will get the first day of the period as the event_date.  That scenario is normally only encountered in testing, as when you want to test closing and close a number of periods so that the open period is now sometime in the future when compared to sysdate.

This is why we recommend you take steps to synch up your FA to GL calendars if you have not been running the same dates in 11i, as part of your upgrade to R12.  It is not required, but it does normally reduce the heartburn associated with when and how things post from FA.  

If you do synch up those periods, are there any implications?  In most cases, there is only the pain of the one-time setup work (see below).  However, you do need to think this over if you use Divide by Days, and/or Daily Prorate Conventions, as it will move some depreciation from one period to another.  Straight Line with Even Distribution won’t do that, as it allocates annual depreciation by period regardless of the dates of the period.  Depending on your setup, you could see some depreciation changes periods.  Over the life of the asset, depreciation will still take the full amount, and normally the annual amount is the same as well.  However, some customers using Divide by Days might see the amounts distributed within a year will be slightly different from period to period than they were in 11i.

How do you actually synch up those calendars?  The critical limitation is that you can only modify periods that are not open.  You must retain whatever your current depreciation period is and whatever your current prorate convention periods are.  Thus, the first recommendation is, if possible, make the changes in 11i before you upgrade.  This is because 11i is indifferent to the dates and, since you can’t modify the open periods, you don’t want to find you have mismatched dates after upgrade, and have to manage that for the upgrade period.

The basic plan is (taking the depreciation calendar as an example):

1.  Query up the calendar in the calendars form.
2.  Go to the last record.
3.  Delete the last record.
4.  Save.
5.  Delete the new last record.
6.  Save.
7.  Repeat until you arrive at the currently open period, which you cannot delete.
8.  Add new periods back with your amended dates.

Remember that this must be done for prorate conventions as well.

With credit to Kathy White, Oracle Assets

Friday Oct 24, 2014

Using the Concurrent Request "Transfer Journals to GL - Assets"

PreventMost users transfer journals to GL via the transfer parameter within Create Accounting.  If you set that parameter to yes, Create Accounting will transfer everything it accounts within that batch to GL as part of the Create Accounting process.  However, what if you accidentally set that parameter to No?  Create Accounting, when next run, will not pick up the items accounted in the earlier run.  It handles ONLY those items accounted within the specific run.  To move those earlier items, you have to run the concurrent request Transfer Journals to GL – Assets.

Another normal use of the Transfer concurrent process is immediately after an upgrade from 11i to R12.  If you upgrade with some transactions already completed in the open period, those will be accounted by the upgrade (not by Create Accounting – but by the upgrade process itself).  They will have their xla_ae_headers.gl_transfer_status set to ‘N’ (No), so that you can move them to GL by running the Transfer concurrent.

Transfer Journals to GL – Assets is an “all or nothing” process.  That is, it has to move everything available to transferred, or it will rollback everything it attempted.  This is important because there is a known upgrade issue which can cause some items from very old periods (sometimes from years earlier) to have xla_ae_headers.gl_transfer_status set to ‘N’ (No), thus indicating – incorrectly – that they still need to be transferred.  Thus, this scenario can be encountered:

  • You upgrade from 11i to any version of R12 with some additions and retirements already done in the open period.
  • The upgrade accounts for these additions and retirements and, since they do actually need to be transferred, it leaves xla_ae_headers.gl_transfer_status set to ‘N’ (No).
  • You run Transfer Journals to GL – Assets after upgrading with the aim of moving those open period pre-upgrade items to GL.
  • It fails with an error message relating to musty old data from years ago.  You know this data is already transferred.
  • However, there is no reference in the log file to the open period data, which is the data you really want in GL, and which continues to not be in GL.

Since the Transfer is an all or nothing process, it failed everything because of the old data.  Since the open period data does not actually have an issue, there is no mention of it in the log file at all.  This does not mean it was not transferred, just that due to the other unwanted data failure, the open period data got rolled back, too.

Another common way to encounter this:

  • You  upgraded from 11i to R12 with no transactions entered into 11i in the period open at the time of upgrade.
  • You have successfully closed a number of periods while using Create Accounting with Transfer parameter as ‘Y’ (Yes).  You have, in fact, never run the Transfer concurrent.
  • Your user accidentally sets the Create Accounting transfer parameter to ‘N’ (No) or you have some type of database issue that causes Create Accounting to complete normally but not submit the transfer.
  • Many users who are unfamiliar with Transfer Journals to GL – Assets open an SR at this point to find out how to transfer data outside of Create Accounting.
  • Once you run the process, though, you encounter the same set of errors on old pre-upgrade data as in the earlier scenario.

How does that open period data actually get posted?  You are going to have to get a data fix to mark the old musty data as transferred to GL, so that the Transfer concurrent can run without failure and move the open period data.  To get that data fix, open a Service Request with Oracle Support and tell the analyst you have the issue in Transfer Journals to GL - Assets Attempts to Transfer Old Pre-Upgrade Data and Will Not Transfer Open Period Data (Doc ID 1347364.1).  The analyst will be able to provide a data fix that cleanly marks the old data transferred and allows you to post your open period data.

With credit to Kathy White, Oracle Assets

Tuesday Oct 14, 2014

An Explanation of Automatic Asset Numbering and Skipped Numbers

What is an asset number?

An asset number uniquely identifies each asset.  If you enter an asset number in Fixed Assets, it must be unique and not in the range of numbers reserved for automatic asset numbering. 

What is automatic asset numbering?

When you add an asset, you can enter the asset number, or you can leave the field blank and the system will use automatic asset numbering.  Automatic asset numbering uses the database sequence FA_ADDITIONS_S, which assigns a number to asset_id and asset_number.  The asset_id is the internal asset number and cannot be modified or updated.  The asset number is the public number and can be assigned by the user.  By default, the same number is assigned to asset_id and asset_number, which is then incremented by one after each asset addition.

The system skipped asset numbers.  Why?

A user entered an asset and the asset number of the last asset added was 16450.  Later, the user resumed entering assets and noticed that the next asset number was 16471 rather than 16451 as expected.

Oracle Applications requires space to execute stored packages and functions.  If that space is fragmented, there may not be enough space for a package or function, so the system pre-allocates space for packages, functions, and sequences by "pinning" them.  The asset number (asset_id) values created by the sequence FA_ADDITIONS_S are cached for performance reasons. 

What happens is that the sequence FA_ADDITIONS_S will be aged out of the cache.  The applications' perspective is that the next value of sequences will increment to the next multiple of the sequence cache value.  This is generally set to 20 by default.

How can I change how many values are being cached?

The easiest option is to set the nocache value to zero, but do realize there could be a performance issue when adding a larger number of assets.

Another solution is to prevent sequences from aging out of the library cache by pinning them using dbms_shared_pool.keep().  Pinning the sequence will prevent the sequence values from being aged out of the cache.

For more information on either option, please review Automatic Asset Numbering Skips Numbers (Doc ID 1036833.6).  An additional resource for this topic is the FAQ: Automatic Asset Numbering (Doc ID 469359.1).

Tuesday Sep 09, 2014

New Fixed Assets White Paper for Insurance Policies and Calculations

If you are contemplating the use of the insurance policy feature of Fixed Assets, you may be interested in a new document:  White Paper – Insurance Calculations in Oracle Assets (Doc ID 1913774.1).   Setup steps and insurance calculation methods are included in this new white paper.  Insurance

With this insurance feature, you can check if assets are under- or over-insured based on the annual index provided by your insurance company.  You can enter, view and maintain the insurance policies as well as the calculation methods.  There are three different calculation methods that can be used to obtain the current insurance value, which is then compared to the actual insurance coverage for an asset.

The three calculation methods are:

  • Value as New (VAN) - This method calculates the base insurance value of the asset, based on acquisition or production costs.  This value can be indexed annually to give a current insurance value.  It can also incorporate the indexed value of transactions that affect the asset value.
  • Market Value (CMV) - This method calculates the current market value of the asset.  Assets automatically calculates the current value from the net book value of the asset, incorporating index factors and the indexed value of any transactions affecting the asset value.
  • Manual Value - This method allows you to manually enter an insurance value for an asset.  With this method you can also manually enter updates to the asset insurance calculations in the insurance value.  Assets updates the current insurance value automatically only if you enter an optional maintenance date.

Additionally, there are two associated reports:

Insurance Data Report - Used to review insurance details for assets and to verify that the assignments for insurance records are correct.

Insurance Value Detail Report - Used to review calculations of insurance coverage for selected assets.  The Insurance Value Detail Report prints all insurance amounts for the selected assets and displays totals at the Balancing Segment level, Insurance Calculation Method level, Insurance Company level, and Insurance Policy Number level. The insurance coverage calculation indicates the differences between insured amounts and current insurance values.

For more details on the Fixed Assets' insurance feature, take a look at the white paper.  It also includes example cases with sample calculations and comparisons.

Tuesday Jul 29, 2014

Let's Talk About Reclassifications in Fixed Assets

MOS SupportThere have been some questions raised about asset reclassifications recently, so let's have a brief discussion about the reclass of assets. 

What is a reclassification?  Simply put, a reclass of an asset is moving the asset from one category to another. 

Perhaps the asset was in an incorrect category.  Perhaps the accounting for the category has changed and a new category needed to be created and the assets moved from the old category to the new category.

A reclass is performed at an asset level (not at a book level).  Therefore, a reclass performed on an asset will move that asset from the original category to the new category simultaneously in each book that the asset exists in.  Thus, the reclass of an asset occurs in all books and cannot be performed in only one book.  If an asset cannot be reclassified in one book, the asset will not be reclassed in any of the books to which it belongs.
You cannot reclassify fully retired assets.

When you reclass an asset in a period after the period of addition, journal entries are created to transfer the cost and accumulated depreciation to the accounts of the new asset category.  The depreciation expense account is also changed to the default depreciation expense account for the new category, but there is not an adjustment for prior period expenses.   

Reclassification does not re-default the depreciation rules of the asset to the default rules from the new category.  Manual changes would be necessary if the depreciation rules for the asset should also be changed.

You can reclass a group of assets by using the Mass Reclassification process.

Two resources for additional questions about the reclassification of assets and using Mass Reclassification are:

1.  Chapter 3 (Asset Maintenance) of the Oracle Assets User Guide
2.  Reclassifications of Assets in Oracle Assets (Asset Reclass) (Doc ID 107079.1)

Wednesday Jun 25, 2014

My Oracle Support Accreditation for E-Business Suite

The My Oracle Support Accreditation Series delivers a targeted learning experience that is designed to increase your expertise with My Oracle Support core functions and build skills to help you leverage Oracle product solutions, tools, and knowledge.

The accreditation framework for Oracle E-Business Suite is targeted to customers and partners who actively use My Oracle Support and Oracle E-Business Suite. The content is focused on building skills around best practices, recommendations, and tool enablement – taking your expertise with Oracle E-Business Suite to the next level. The Oracle E-Business Suite course covers:

•    Staying informed
•    Period Close
•    Patching
•    Certifications
•    Upgrade Advisor
•    Reporting 

Visit the My Oracle Support Accreditation Index and get started with the Level 1 My Oracle Support Accreditation path and the Level 2 Oracle E-Business Suite learning path today.


Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« February 2016