Friday, 8 July 2011

mass assets transfer - oracle r12

Oracle Assets allows you to transfer multiple assets in one transaction. You use the Transfer From and Transfer to fields to identify the assets to be transferred. You can transfer between expense accounts, locations, and employees and employee numbers. By selecting any combination of these criteria, you can further restrict the range of assets to be transferred. (N) Mass Transactions > Transfers
Select the corporate depreciation Book for the assets you want to transfer
Select the corporate depreciation Book for the assets you want to transfer

using mass changes-oracle erp r12

(N) Mass Transactions > Changes Sometimes a change applies to more than one asset. This can be a change in the prorate convention, the depreciation method, or the life, rates, capacity, and unit of measure for the method. For example, tax laws for a group of assets may change. If you enable Mass Change for the specified book, you can make expensed adjustmen Now you can adjust your asset financial information then click (B) done ts to financial information for a group of assets

C-Adjusting Financial Information: Oracle applications R12-1.1 financial

C-Adjusting Financial Information: You adjust the financial information in the Books window to correct an error, update the financial and depreciation data, and expense or amortize the adjustment following the period in which you added the asset.

B-Adjusting Asset Units: Oracle applications R12-1.1 financial

You change the number of units for an asset in the Asset Details window which will then take you to the Assignments widow to update the distribution and assignment information
Assets > Asset Workbench
Enter your asset information then click (B) find Find your asset notice the unit's status

Find the assets you want to reclassify

Find the assets you want to reclassify. -Specify the corporate book on which you want to run reclassification.

-Optionally specify other asset selection criteria in the following fields: Asset Type-Expense Accounts-Location-Group Asset-Employee Name-Employee Number-Category -Asset Key-Cost Range-Asset Numbers and Dates in Service. - Enter the new category.

Copy category descriptive flexfield to new category: Specify if you want the current category descriptive flexfield information copied to the new category. If you do not choose to copy the flexfield information, the current category Descriptive flexfield information will be deleted. Inherit description rules of new category: Specify whether to inherit the depreciation rules of the new category. If you choose to inherit the depreciation rules of the new category, specify whether to amortize the changes. Click (B) Preview to run the Mass Reclassification Preview report. Query the Mass Transaction number and choose Run to submit the Mass Reclassification concurrent process.

reclassifications - Oracle applications R12-1.1 financial

reclassifications - Oracle applications R12-1.1 financial
You can reclassify a group of assets using the Mass Reclassifications window. In addition to reclassifying assets to a new category, when you run the Mass Reclassification process, you have the option to have assets inherit the depreciation rules of the new category. If you choose to have the reclassified assets inherit depreciation rules, you can also choose to either amortize or expense the resulting depreciation adjustments. Restrictions: -Reclassification is done at the asset level. If an asset cannot be reclassified in one book, the asset will not be reclassified in any of the books to which it belongs. -You cannot reclassify an asset in a prior period. (N) Mass transactions > reclassifications

A-Reclassifying an Asset: Oracle applications R12-1.1 financial

A-Reclassifying an Asset: You assign an asset to a new category in the Asset Details window to update information, correct data entry errors, and consolidate categories. -When you reclassify an asset in a period after the period you entered it, Oracle Assets creates journal entries to transfer the cost and accumulated depreciation to the asset cost and accumulated depreciation accounts of the new asset category. This occurs when you create journal entries for your general ledger. -Reclassification does not redefault the depreciation rules to the default rules from the new category. Manually change the depreciation rules in the Books or Mass Change windows if necessary.

4-Assets adjustment - Oracle applications R12-1.1 financial

You adjust an asset by reclassifying, changing the number of units, adjusting the financial information, or performing a mass change. These adjustments are automatically reflected in the reporting currencies asset books. All cost adjustments use the daily exchange rate based on the transaction date entered during adjustment. Oracle Assets calculates new weighted average rate for the asset.

3-CIP assets - Oracle applications R12-1.1 financial

A construction–in–process (CIP) asset is an asset you construct over a period of time. You create and maintain your CIP assets as you spend money for raw materials and labor to construct them. Since a CIP asset is not yet in use, it does not depreciate. When you finish building the CIP asset, you can place it in service and begin depreciating it. You can track CIP assets in Oracle Assets, or you can track detailed information about your CIP assets in Oracle Projects. If you use Oracle Projects to track CIP assets, you do not need to track them prior to capitalization in Oracle Assets. Create CIP assets using mass additions or manual additions. Oracle Assets identifies invoices with distributions to CIP clearing accounts in Oracle Payables, and creates mass additions from them. You can create new CIP assets from your mass additions, or add them to existing assets. You can also add non–invoiced expenses, such as labor cost, to your CIP assets. You can perform transfers or adjustments on your CIP assets if necessary.
Assets > asset workbench
Enter your CIP asset and note assets type Find your asset after create it

Mass additions > prepare mass addition

Mass additions > prepare mass addition
Looking for invoices by queue-transaction date-asset number
Click queue and select post then chose your category then select you category-expense account-date in service and depreciation. Note: you can also change your asset cost in this window
Note: the queue will change from new to post (N) Mass addition > post mass addition
When your request will be completed normal you can search about your asset in assets workbench window (N) Assets > assets workbench

2-mass addition: Oracle applications R12-1.1 financial

The mass additions process lets you add new assets or cost adjustments from other systems to your system automatically without reentering the data. For example: you can add new assets from invoice lines brought over to Oracle Assets from Oracle Payables, or from CIP asset lines sent from Oracle Projects. A-create an asset invoice with this conditions: 1-the account must be asset clearing. 2-you must be enabling track as asset. 3-the asset invoice must be payee. 4-the invoice transfer to general ledger. From payables responsibility (N) invoice > entry > invoices

2-Details additions: Oracle applications R12-1.1 financial

Use the Detail Additions process to manually add complex assets, which the Quick Additions process does not handle: -Assets that have a salvage value -Assets with more than one assignment -Assets with more than one source line -Assets to which the category default depreciation rules do not apply -Subcomponent assets -Leased assets and leasehold improvements -Assets assigned to warranties

Quick addition - details Addition

Assets > asset workbench
To enter an asset by quick addition click (B) quick addition and to enter details click (B) additions

1-Quick additions: Use the Quick Additions process to quickly add ordinary assets. When you enter minimal information in the Quick Additions window, the remaining asset information defaults from the asset category, asset corporate book, and the date placed in service. (N) Assets > assets workbench
Click (B) quick additions

Assets transactions in apps

1-Manual addition: You use Quick Additions or Detail Additions to add assets manually. All assets added to the primary asset book are automatically converted to the reporting currencies asset books when you save the transaction. Based on the asset date placed in service, Oracle Assets retrieves an exchange rate to convert the asset cost and depreciation reserve.

Use Depreciation Limit - USE ITC Ceilings

Use Depreciation Limit: Check the Use Depreciation Limit check box if you want to depreciate an asset beyond its useful life. You can enter the default depreciation limit as a percentage or an amount.

USE ITC Ceilings: If you are defining this category for a tax book, indicate whether assets in this category are eligible for Investment Tax Credit (ITC) and whether assets in this category Use ITC Ceilings.

Mass Property Eligible: Check the Mass Property Eligible check box if you want to make assets added to this category eligible for mass property treatment.

Group Asset: In the Group Asset field, you can enter the group asset to which all assets added to this category will be assigned. If you enter a group asset number in this field, all capitalized and CIP assets using this category will be automatically assigned to the group asset entered.

assets in this book and category

Method: Enter the depreciation Method that you normally use for assets in this book and category: Life-based: If you enter a life-based method, you must enter the asset Life in Years and Months. The method you enter must have the same number of periods as the prorate calendar for this book. Flat-rate: If you enter a flat-rate method, you must enter default values for the Basic Rate and Adjusted Rate that you normally use to depreciate assets in this book. Units of production: If you enter units of production method, you must enter the unit of measure (UOM) and production Capacity that you normally use to depreciate assets in this book and category. Bonus rule: Enter the bonus rule that you normally use for assets in this book and category. You can use bonus rules for corporate books and tax books, using all depreciation methods except UOM.

Prorate convention and retirement convention: Enter the Prorate Convention and Retirement Convention that you normally assign to assets in this book and category.

Default salvage value: If you chose Use Default Percent from the Salvage Value pop list. Controls window for this book, you can enter a Default Salvage Value percentage for this category, book, and range of dates placed in service. For example: if you want the salvage value to default to 10% of the cost, enter 10 in this field. When you perform transactions affecting asset cost, Oracle Assets uses this default percentage to calculate the salvage value according to the following formula: Salvage Value = Cost? Default Percentage

Ceiling: If you are defining this category for a tax book, optionally enter either a depreciation expense or cost ceiling. Price index: Enter a Price Index if you want to run reports that use the revalued asset cost to calculate gains and losses.

Straight Line For Retirements: Check Straight Line for Retirements if you are setting up an asset category with a 1250 property class in a tax book. Oracle Assets uses a straight-line depreciation method in determining the gain or loss resulting from the retirement of 1250 (real) property. If you check Straight Line for Retirements, enter the straight-line depreciation
Method and Life you want to use for the Gain from Disposition of 1250 Property Report. This is the default method for your asset in the Retirements window and in the tax book if you use mass copy.

CIP clearing - Placed in service - Depreciate

CIP clearing: Enter the CIP Clearing account for this category and book if you entered a CIP Cost account. Then click (B) default rules Note: Enter default depreciation rules for each depreciation book for which the category is defined.

Placed in service: In the Default Depreciation Rules window, enter the date Placed in Service range for which these category defaults are effective. When you add an asset, the depreciation rules default according to the date placed in service of the asset, the category, and the book. Depreciate: Check Depreciate if you normally depreciate assets in this book and category

Asset cost - Asset clearing - Depreciation expenses

Asset cost: Enter the Asset Cost account for this category and book. Oracle Assets uses this account to reconcile asset costs to your general ledger. Oracle Assets creates journal entries for this account to reflect additions, retirements, cost changes, revaluations, transfers, reclassifications, and capitalizations. Asset clearing: Enter the Asset Clearing account for this category and book. Oracle Assets uses this account to reconcile your payables system and Oracle Assets. For mass additions, it uses the complete Account combination that comes over with a mass addition line to reconcile the asset addition or cost adjustment with your payables system.

Depreciation expenses: Enter the general ledger Depreciation Expense Segment to which you charge depreciation for assets in this category and book. This is the default value for the account segment of the depreciation expense account in the Assignment window.

Accumulated depreciation: Enter the Accumulated Depreciation account for this category and book. This account is the contra-account for the asset cost account for this category.

Bonus expenses: If you have set up bonus rates, enter the Bonus Expense account. If you do not enter a value in this field, it defaults to the Depreciation Expense account.

Bonus reserve: If you have set up bonus rates, enter the Bonus Reserve account. If you do not enter a value in this field, it defaults to the Accumulated Depreciation account. Revaluation reserve: Enter the Revaluation Reserve account for this category and book. This account is used for the change in net book value due to revaluation, if you revalue accumulated depreciation.

Revaluation amortization: Enter the Revaluation Amortization account for this category and book. This account is used to amortize the revaluation reserve over the remaining life of the asset after you revalue it, if you amortize revaluation reserve.

CIP cost: Enter the CIP Cost account for this category and book. This account is used to reconcile CIP asset costs to your general ledger.

Category and description - assets r12

Category and description - assets r12
Category and description: Enter a Category name and Description to identify the asset category you want to set up.

Enabled: Check enabled if you want to use this category. Capitalized: Check Capitalize if you want to charge items in this category to an asset account when you pay for them and if you want to depreciate items in this category. In physical inventory: Check In Physical Inventory if you want assets in this category to be included in physical inventory comparisons. Category type: Choose Lease, Leasehold Improvement, or Non-Lease from the Category Type Pop list.

Ownership: Choose Owned or Leased from the Ownership pop list. Property type and property class: Enter the Property Type and Class to which the assets in this category usually belong.

Note: You set up your Quick Code values for Property Type in the Quick Codes window. If you have assets in the United States, enter 1245 for personal property and 1250 for real property.

Book: enter the Book for which you want to set up this asset category.

Oracle applications assets category

assets category: Asset categories let you define information that is common to all assets in a category, such as depreciation method and prorate convention. Oracle Assets uses this information to provide default values to help speed asset entry. All assets are required to have an asset category. Asset categories group assets that share financial accounts and usually depreciate using the same rules. Oracle Assets uses this information to provide default values at the time an asset is entered into the system. You specify general ledger accounts and default depreciation rules for assets in a category and an asset book. You set up different default depreciation rules depending on the date placed in service. If an asset book is not attached to an asset category, you will not be able to add assets assigned to that category to that asset book.

(T) Natural accounts: Oracle applications R12-1.1 financial Assets

Account Generator Defaults: By default, Oracle Assets creates journal entries without cost center level detail for all accounts except the depreciation expense account. Using the default assignments, it creates journal entries using the balancing segment from the expense account in the Assignments window and the account segment from the asset category or book, depending on the account type. The default Subledger Accounting rules use the other segments from the default segment values you enter for the book in this field.

(T) Accounting rules: assets erp oracle r12

Capital gain threshold: The minimum time you must hold an asset for Oracle Assets to report it as a capital gain when you retire it. If you want Oracle Assets to report a capital gain for all assets when you retire them, enter zero for the threshold.

Allow amortized changes: This option does not affect group or member assets, or Individual assets that previously belonged to a group.

Allow cost sign changes: Check this check box if you want to allow the cost amount to change from a positive to a negative amount or from a negative to a positive amount.

Allow mass changes and allow amortized changes: If you want to allow amortized changes and mass changes in the asset book, make sure these check boxes are enabled. The default when defining a new asset book has these checkboxes disabled and it is often overlooked to enabled them when defining a new asset book.

Allow revaluations: Select Allow Revaluation, if necessary, and specify the applicable default revaluation rules. Allow group depreciation: You must check the Allow Group Depreciation check box before creating group assets in the book.
Capital gain threshold: The minimum time you must hold an asset for Oracle Assets to report it as a capital gain when you retire it. If you want Oracle Assets to report a capital gain for all assets when you retire them, enter zero for the threshold.

Allow amortized changes: This option does not affect group or member assets, or Individual assets that previously belonged to a group.

Allow cost sign changes: Check this check box if you want to allow the cost amount to change from a positive to a negative amount or from a negative to a positive amount.

Allow mass changes and allow amortized changes: If you want to allow amortized changes and mass changes in the asset book, make sure these check boxes are enabled. The default when defining a new asset book has these checkboxes disabled and it is often overlooked to enabled them when defining a new asset book.

Allow revaluations: Select Allow Revaluation, if necessary, and specify the applicable default revaluation rules. Allow group depreciation: You must check the Allow Group Depreciation check box before creating group assets in the book.

(T) Calendar: assets erp financial r12

Allow purge: You must check the Allow Purge checkbox in order to purge information from this asset book. It is recommended that you leave the checkbox unchecked until you are ready to purge data from the book. You can then enable the Allow Purge option, purge your data, and then again disable the checkbox. This helps to ensure against unwanted purges of data from this book. Ledger: Enter the ledger for which you want to create journal entries.

Allow GL posting: Enable if you want to create journal entries for this book. You cannot allow general ledger posting for your budget books.

Depreciation calendar: select your depreciation calendar. Fiscal year name: select your fiscal year. Prorate calendar: select your depreciation calendar.

Current period: The Oracle Assets system will update the current period field each time the current period is closed and the next period is opened. Keep in mind there can be only one open period at a time for each asset book. You must set up the depreciation calendar for at least one period before the current period.

Divide depreciation: Choose the method for dividing the annual depreciation amount over the periods in your fiscal year for this book.
All right reserved-2010 created by: Khalid youssry Page 33 of 122 Choose evenly to divide depreciation evenly to each period. Choose By Days to divide it proportionally based on the number of days in each period.

Depreciate if retired in first year: Choose whether to depreciate assets in this book that is retired in their first year of life.

Last run date: Initially defaults to the current date. Oracle Assets updates this date when you run depreciation.

4-book controls

Define asset books to store financial information for a group of assets. You can set up an unlimited number of independent depreciation books. Each book has its own set of accounting rules and accounts so you can organize and implement your fixed assets accounting policies. When you define a tax or budget book, you must specify an associated corporate book.

(N) Setup > asset system > book control
Book: book name. Class: In the Class field, select Corporate. You can only create group assets in a corporate book.

C-prorate conventions

Prorate and retirement conventions determine how much depreciation expense to take in the first and last year of life, based on when you place the asset in service. Oracle Assets lets you set up as many prorate and retirement conventions as you need.

(N) Setup > asset system > prorate conventions
Convention: Enter a Convention name. Description: enter description name. Fiscal year name: Enter the Fiscal Year Name for which you want to set up this convention. Depreciate when placed in service: Select the Depreciate When Placed in Service check box if you want to start taking depreciation in the accounting period that corresponds to the date placed in service, instead of the period that corresponds to the prorate date.

Note: For assets that use a calculated (straight-line) method, Oracle Assets ignores this option and always starts taking depreciation in the accounting period that corresponds to the prorate date. Another screen shoots down to explain.

Enter date ranges and corresponding prorate dates for assets where the date Placed in service is between the From Date and the To Date.

B-assets calendar

Set up as much depreciation and prorate calendars as you need. Calendars break down your fiscal year into accounting periods. Define your calendars with as many periods as you need.

(N) Setup > asset system > assets calendar

CalendarEnter the name for your Calendar. Description: enter a description.
Descriptions: enter a Description. Note: You can set up multiple fiscal years with different names and the name you enter appears in List of Values windows which allow no more than 30 spaces. You may want to limit your name to 30 characters.
Fiscal year name: Enter the Fiscal Year Name you want to use for this calendar. Period per year: Enter the number of periods in the fiscal year for this calendar. Enter the Name of this period and enter the start and end dates of this period. Note: The period name must match to the corresponding GL Calendar period name (this is case sensitive) or accounting will not transfer to the General Ledger.

3-aseets calendars

You must first define fiscal years then asset calendars based on those fiscal years

A-fiscal year calendar: Use the Fiscal Years window to define the beginning and end of each fiscal year since the start of your company. Your fiscal year groups your accounting periods. Create fiscal years from the oldest date placed in service through one fiscal year beyond the current fiscal year. You can set up multiple fiscal years in this window. You can assign different fiscal years to your different corporate books. The calendar for a tax book must use the same fiscal year name as the calendar for the associated tax book.1 (N) Setup > asset system > fiscal year

Fiscal year name: Enter a Fiscal Year Name.

Oracle applications R12-1.1 financial Assets

Note: you cannot place new assets in service before the new date you can only update the Oldest Date Placed in Service before you assign any calendars to depreciation books. Category flexfield: Enter the Category Flexfield structures you want to use.

Location flexfield: Enter the Location Flexfield structures you want to use.

Assets key flexfield: Enter Asset Key Flexfield structures you want to use.

Starting asset number: Enter the Starting Number at which you want Oracle Assets to begin automatically numbering your assets.

2-system controls

Set up your system controls. You specify your enterprise name, asset numbering scheme, and key flexfield structures in the System Controls window. You also specify the oldest date placed in service of your assets. (N) Setup > asset system > system controls

Enterprise name: Enter the enterprise name as you want it to appear on reports. Oldest date placed in service: Enter the Oldest Date Placed in Service, which controls what dates are valid to place assets in service and on what date to begin your calendars.

To add values to category flexfield

To add values to category flexfield: Select your applications-title-structure and segment to enter values Enter the values and descriptions Enter the information's then click (B) flexfield qualifiers Note the qualifiers then click (B) value set Note that major category has a validation type independent and minor category has a validations type dependent.

C-category flexfield

The asset category flexfield allows you to define asset categories and subcategories. For example, you can create an asset category for your computer equipment. You can then create subcategories for personal computers, terminals, printers, and software. The asset category flexfield groups assets by financial information.
Enter the segment names and select columns for this segment then click (B) open

B-locations flexfield

The location flexfield allows you to specify and track the exact location of your assets. You can report on your assets by location and also transfer assets that share location information as a group.

Assets setup in apps

Oracle Assets setup requires a series of steps categorized in the following manner: Required Steps: Must be completed in order to run the application. No pre-seeded defaults are provided.

Required Steps With Defaults: Setup functionality that comes with pre-seeded, default values in the database. You should however, review these defaults and decide whether to change them to suit your business needs. If you want or need to change them, you should perform that setup step.

Optional Steps: You need to perform Optional steps only if you plan to use the related feature or complete certain business functions.

Assets integrations

Oracle Assets integrates with Oracle Payables, Oracle Projects, and Oracle General Ledger to provide asset management information. Oracle Assets uses Supplier information from Oracle Purchasing, Units of Measure and Items from Oracle Inventory, and Employees from Oracle Human Resources. It also interfaces directly with the Application Desktop Integrator. You can use Mass Additions to load into Oracle Assets invoice and asset information from any feeder system, such as Oracle Payables or another payables system. You can also import CIP assets from Oracle Projects. Oracle Assets eases general ledger integration by automatically producing asset journal entries for the general ledger system.

Assets journals cycle

1-Payables: Invoice journal Cr. Liability Payment journal Dr. Liability Cr. Cash
2-Assets: Dr. F/A Cr. Assets clearing
3-Depreciations Dr. Depreciation expenses Cr. Accumulated depreciation
4-Retirment: Dr. Accumulated depreciation Cr. Cash
5-CIP: Dr.CIP building (CIP cost) Cr. CIP clearing Dr. F/A Cr. CIP building

Overview of oracle assets

Oracle Assets is a complete asset management solution that maintains property and equipment accurately to help you select the best accounting and tax strategies.
You can add, transfer, and retire assets. You can adjust for a single asset, groups of assets, or financial information. Oracle Assets adapts to various countries' tax and accounting laws to accommodate fluctuating economies, unplanned depreciation, and other unforeseen circumstances. Oracle Assets provides reports that you can use to inform the fixed asset manager of additions, transfers, retirements, or other unrecorded changes, ensuring that the asset inventory remains accurate. At any time, you can print these reports or you can view descriptive or financial information about the assets online.

Oracle applications R12-1.1 financial

Anyone who is interested to learn oracle financials can use this document for his/her as a basic document. Although the document will cover most of the features but this is not the whole oracle financials. So please consider it as a basic or reference document for the beginners

Oracle Financial 11i 10.2

General Ledger
o's only system to be dealt Maھa before the establishment of any system of Oracle. GL
You must first learn some Almھarat for the system to create the GL
First, access to the oracle
Operations and pass: Welcome You must enter a user name and password by

Sort systems more widely used?

ERP App
------------------
1 - sap
2 - Oracle
3 - Microsoft

If we say in the world remain (1. 2.3)
Sap and occupies the first on the world Alhan all EU Summit Bistkhaddm often sap system and I'm her village was the last statistical year 2005 was a private system sap rank first in use on the world.

In the Arab world (2. 3.1)
Oracle occupies the first place to spread in Egypt and the Arab world.

-------------------------------------------------- --------------

Databases of each system?
Sap: use Oracle databases
: Oracle Batabaa use Oracle databases
: Microsoft uses Sql Server databases

-------------------------------------------------- --------------

Order the regulations and in accordance with the technical support?
Oracle
Sap
Microsoft

-------------------------------------------------- --------------

Order systems for the most expensive in the price?
SAP
Oracle
Microsoft

What are the systems produced by these companies?

What are the systems produced by these companies?

Company name system name Oracle Oracle E-Business Suite


Company Name Sap MY SAP system name


Company Name Microsoft system name Microsoft Dynamics


-------------------------------------------------- --------------

What is the nationality of those regimes?

Oracle ........ U.S.
Microsoft .... U.S.
SAP ............ German

What is known about erp?

Means any ERP?
(Enterprice Resource Planning (ERP
Concerned with resource planning Amoossh .. Woody literal translation of the meaning.
ERP is an integrated system covering all the departments (Financial - Human Resources - Customer Service - Manufacturing ... etc), but these systems and departments are all linked together in an integrated database (Bamy One word like that means in some).

In other words you instead of buying software from a company and stores accounting program from another company can buy an integrated system of one company.


Remains the ERP is a concept of integrated systems that cover all departments in a single system linked to each other.

-------------------------------------------------- --------------

What are the top 3 companies producing system ERP?
Oracle - SAP-Microsoft