Cloud Computing

Cloud computing is an emerging computing technology that uses the internet and central remote servers to maintain data and applications. Cloud computing allows consumers and businesses to use applications without installation and access their personal files at any computer with internet access. This technology allows for much more efficient computing by centralizing storage, memory, processing and bandwidth. Cloud computing is broken down into three segments: “applications,” “platforms,” and “infrastructure.” Each segment serves a different purpose and offers different products for businesses and individuals around the world.

Oracle Fixed Assets Useful Tables

Hello Friends , here is some of quite commonly used FA (Fixed Assets) tables and their usage. There are many other tables also in FA but here i am putting only few commonly used tables. for other table if needed we can dig furthur. Let go through below article and let me know if it useful.





FA_DEPRN_PERIODS contains information about your depreciation periods. Oracle Assets uses this table to determine when each period in FA_CALENDARS was open for a depreciation book. PERIOD_OPEN_DATE and PERIOD_CLOSE_DATE are the dates when you opened and closed each book’s depreciation period. Each time you run the depreciation program, it closes the current period by setting PERIOD_CLOSE_DATE to the system date. It also opens the next period by inserting a new row into this table in which PERIOD_CLOSE_DATE is NULL and PERIOD_OPEN_DATE equals the PERIOD_CLOSE_DATE of the old row. CALENDAR_PERIOD_OPEN_DATE and CALENDAR_PERIOD_CLOSE_DATE correspond to your calendar as defined by the START_DATE and END_DATE columns in FA_CALENDAR_PERIODS.

FA_DEPRN_SUMMARY contains depreciation information for your assets. Each time you run the depreciation program, it inserts one row into thistable for each asset. PERIOD_COUNTER is the period for which you ran the depreciation program. DEPRN_AMOUNT is the depreciation expense for an asset in a depreciation period. It is the sum of DEPRN_AMOUNT in all the rows of FA_DEPRN_DETAIL for the asset and period. YTD_DEPRN is the accumulated depreciation of an asset for the current fiscal year as of the end of this period. DEPRN_RESERVE is the total accumulated depreciation for this asset. DEPRN_SOURCE_CODE tells you what program created the row BOOKS Created by the Depreciation Books form, Quick Additions form, or the post mass additions program when you enter a new asset. DEPRN Created by the depreciation program when you run depreciation. ADJUSTED_COST is the depreciable basis the depreciation program uses to calculate depreciation for an asset in a depreciation period. This value is the same as the asset’s recoverable cost, except for assets that use a diminishing value depreciation method, assets to which you have made an amortized adjustment, and assets you have revalued.

For assets that use a diminishing value method, the ADJUSTED_COST is the beginning of year net book value, which the depreciation program updates at the start of each fiscal year. When you perform an amortized adjustment on an asset or revalue it, the ADJUSTED_COST becomes the asset’s net book value at the time of the adjustment or revaluation. BONUS_RATE is the bonus rate that Oracle Assets adds to the adjusted rate to give you the flat rate for the fiscal year. The depreciation program uses this rate to calculate depreciation for an asset. This only applies to assets that use both a flat–rate depreciation method and bonus depreciation.

FA_ADDITIONS_B contains descriptive information to help you identify your assets. Oracle Assets does not use this table to calculate depreciation.When you add an asset, Oracle Assets inserts a row into this table and into FA_ASSET_HISTORY. When you change the asset information stored in this table, Oracle Assets updates it in this table. It also creates a new row in FA_ASSET_HISTORY. When you perform a unit retirement, Oracle Assets reduces the CURRENT_UNITS by the units retired. UNIT_ADJUSTMENT_FLAG is set to YES by the Additions form if you change the number of units for an asset. The Transfers form resets it to NO after you reassign the remaining units. FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions. The posting program creates journal entries for regular depreciation expense from information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in this table for the debit and credit sides of a financial transaction. All the rows for the same transaction have the same value in the TRANSACTION_HEADER_ID column. The SOURCE_TYPE_CODE column tells you which program created the adjustment:

– ADDITION Depreciation program
– ADJUSTMENT Expensed or Amortized Adjustment User Exit

– CIP ADDITION Depreciation program

– CIP ADJUSTMENT Expensed or Amortized Adjustment User Exit

– CIP RETIREMENT Gain/loss program

– DEPRECIATION Depreciation program (Retroactive transactions andexpensed depreciation adjustments)

– RETIREMENT Gain/loss program

– RECLASS Reclassification user exit

– TRANSFER Transfers form

– TAX Reserve Adjustments form

– REVALUATION Mass revaluation program

The ADJUSTMENT_TYPE column tells you which type of account Oracle Assets adjusts. DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the amount is a credit. ADJUSTMENT_AMOUNT is the amount debited or credited to the account. ANNUALIZED_ADJUSTMENT is the adjustment amount for a period times the number of periods in a fiscal year. The depreciation program uses it to calculate the depreciation adjustment for an asset when you perform multiple retroactive transactions on the asset. Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the ADJUSTMENT_AMOUNT for a retroactive transaction by the numberof periods between the period you entered the transaction and the period that it was effective. For current period transactions, this columnis zero. PERIOD_COUNTER_CREATED IS the period that you entered the adjustment into Oracle Assets. PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies. It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period of the fiscal year to which the adjustment applies. CODE_COMBINATION_ID indicates the Accounting Flexfield combination Oracle Assets debits or credits for all transactions except reclassifications and intercompany transfers. This CODE_COMBINATION_ID is generated using the Account Generator, and the posting program does not perform any further processing.

FA_BOOKS contains the information that Oracle Assets needs to calculate depreciation. When you initially add an asset, Oracle Assets inserts one row into the table. This becomes the ”active” row for the asset. Whenever you use the Depreciation Books form to change the asset’s depreciation information, or if you retire or reinstate it, Oracle Assets inserts another row into the table, which then becomes the new ”active” row, and marks the previous row as obsolete.

At any point in time, there is only one ”active” row in the table for an asset in any given depreciation book. Generally, Oracle Assets uses the active row, but if you run a report for a prior accounting period, Oracle Assets selects the row that was active during that period. You can identify the active row for anasset in a book because it is the only one whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL. When Oracle Assets terminates a row, the DATE_INEFFECTIVE and TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and TRANSACTION_HEADER_IN of the new row, respectively. This means that you can easily identify rows affected by the same transaction because they have the same DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs.When Oracle Assets creates the new row, the value used for the TRANSACTION_HEADER_ID_IN column is the same as the TRANSACTION_HEADER_ID in the row inserted into FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date. When you retire an asset, Oracle Assets inserts a new row to reduce the COST by the amount retired. When you reinstate an asset, Oracle Assets inserts a new row to increase the COST by the COST_RETIRED in the corresponding row in FA_RETIREMENTS.RATE_ADJUSTMENT_FACTOR is originally 1. It is used to spread depreciation over the remaining life of an asset after an amortization or revaluation. If you perform a revaluation or an amortized adjustment, Oracle Assets resets the Rate Adjustment Factor to prorate the remaining recoverable net book value over the remaining life. This fraction is calculated as [Recoverable Cost – what Depreciation Reserve would be]/Recoverable Cost. The depreciation program uses this value to adjust the depreciation rate for an asset.

FA_CATEGORIES_B stores information about your asset categories. This table provides default information when you add an asset. The depreciation program does not use this information to calculate depreciation.The Asset Categories form inserts one row in this table for each asset category you define. The Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment.

FA_DEPRN_DETAIL contains the depreciation amounts that the depreciation program charges to the depreciation expense account in each distribution line.

Oracle Assets uses this information to create depreciation expense journal entries for your general ledger.The depreciation program inserts one row per distribution line for an asset each time you run depreciation.
For example, if you assign an asset to two different cost centers, the depreciation program inserts two rows in this table for the asset. DEPRN_AMOUNT is the amount of depreciation expense calculated forthis distribution line.YTD_DEPRN is the year–to–date depreciation allocated to thisdistribution line.When you add an asset, Oracle Assets inserts a row into this table for the period before the current period. This row has the asset cost in the ADDITION_COST_TO_CLEAR column and a DEPRN_SOURCE_CODE of ’B’. This column is used for reporting on new assets. When you run depreciation, Oracle Assets transfers the cost to the COST column in the current period row, this row has a DEPRN_SOURCE_CODE of ’D’.

Thanks – Shivmohan Purohit

How companies get their name ! Interesting

I found some interesting material about how companies were named and what their names actually mean, take a look below..btw it is quite a long list!

ABN AMRO — In the 1960s, the Nederlandse Handelmaatschappij (Dutch Trading Society; 1824) and the Twentsche Bank merged to form the Algemene Bank Nederland ( ABN; General Bank of the Netherlands). In 1966, the Amsterdamsche Bank and the Rotterdamsche Bank merged to form the Amro Bank. In 1991, ABNand Amro Bank merged to form ABN AMRO.

Acccenture — Accent on the Future. Greater-than ‘accent’ over the logo’s t points forward towards the future. The name Accenture was proposed by a company employee in Norways part of a internal name finding process (BrandStorming). Prior to January 1, 2001 the company was called Andersen Consulting.

Adidas — from the name of the founder Adolf (Adi) Dassler.

Adobe — came from name of the river Adobe Creek that ran behind the houses of founders John Warnock and Chuck Geschke .

AltaVista — Spanish for “high view”. — Founder Jeff Bezos renamed the company to Amazon (from the earlier name of after the world’s most voluminous river, the Amazon. He saw the potential for a larger volume of sales in an online bookstore as opposed to the then prevalent bookstores. (Alternative: It is said that Jeff Bezos named his book store Amazon simply to cash in on the popularity of Yahoo at the time. Yahoo listed entries alphabetically, and thus Amazon would always appear above its competitors in the relevant categories it was listed in.)

Apple — for the favourite fruit of co-founder Steve Jobs and/or for the time he worked at an apple orchard. He was three months late in filing a name for the business, and he threatened to call his company Apple Computer if his colleagues didn’t suggest a better name by 5 p.m. Apple’s Macintosh is named after a popular variety of apple sold in the US. Apple also wanted to distance itself from the cold, unapproachable, complicated imagery created by the other computer companies at the time had names like IBM, NEC, DEC, ADPAC, Cincom, Dylakor, Input, Integral Systems, SAP, PSDI, Syncsort and Tesseract. The new company sought to reverse the entrenched view of computers in order to get people to use them at home. They looked for a name that was unlike the names of traditional computer companies, a name that also supported a brand positioning strategy that was to be perceived as simple, warm, human, approachable and different. Note: Apple had to get approval from the Beatle’s Apple Corps to use the name ‘Apple’ and paid a one-time royalty of $100,000 to McIntosh Laboratory, Inc., a maker of high-end audio equipment, to use the derivative name ‘Macintosh’, known now as just ‘Mac’.

Blaupunkt — Blaupunkt (Blue dot) was founded in 1923 under the name Ideal. Their core business was the manufacturing of headphones. If the headphones came through quality tests, the company would give the headphones a blue dot. The headphones quickly became known as the blue dots or blaue Punkte. The quality symbol would become a trademark, and the trademark would become the company name in 1938.

Cadillac — Cadillac was named after the 18th century French explorer Antoine Laumet de La Mothe , sieur de Cadillac, founder of Detroit, Michigan. Cadillac is a small town in the South of France.

Canon — Originally (1933) Precision Optical Instruments Laboratory the new name (1935) derived from the name of the company’s first camera, the Kwannon, in turn named after the Japanese name of the Buddhist bodhisattva of mercy.

Cisco — short for San Francisco. It has also been suggested that it was “CIS-co” — Computer Information Services was the department at Stanford University that the founders worked in.

Coca-Cola — Coca-Cola’s name is derived from the coca leaves and kola nuts used as flavouring. Coca-Cola creator John S. Pemberton changed the ‘K’ of kola to ‘C’ for the name to look better.

Colgate-Palmolive — formed from a merger of soap manufacturers Colgate & Company and Palmolive-Peet. Peet was dropped in 1953. Colgate was named after William Colgate, an English immigrant, who set up a starch, soap and candle business in New York Cityin 1806. Palmolive was named for the two oils (Palm and Olive) used in its manufacture.

Compaq — from “comp” for computer, and “pack” to denote a small integral object; or: Compatibility And Quality; or: from the company’s first product, the very compact Compaq Portable.

Daewoo — the company founder Kim Woo Chong called it Daewoo which means “Great Universe” in Korean.

Dell — named after its founder, Michael Dell. The company changed its name from Dell Computer in 2003.

DHL — the company was founded by Adrian Dalsey, Larry Hillblom , and Robert Lynn , whose last initials form the company’s moniker.

eBay — Pierre Omidyar, who had created the Auction Web trading website, had formed a web consulting concern called Echo Bay Technology Group. ” EchoBay” didn’t refer to the town in Nevada, the nature area close to Lake Mead, or any real place. “It just sounded cool,” Omidyar reportedly said. When he tried to register, though, he found that Echo Bay Mines, a gold mining company, had gotten it first. So, Omidyar registered what (at the time) he thought was the second best name:

Epson — Epson Seiko Corporation, the Japanese printer and peripheral manufacturer, was named from “Son of Electronic Printer”

Fanta — was originally invented by Max Keith in Germany in 1940 when World War II made it difficult to get the Coca-Cola syrup to Nazi Germany. Fanta was originally made from by products of cheese and jam production. The name comes from the German word for imagination (Fantasie or Phantasie), because the inventors thought that imagination was needed to taste oranges from the strange mix.

Fiat — acronym of Fabbrica Italiana Automobili Torino (Italian Factory of Cars of Turin).

Fuji — from the highest Japanese mountain Mount Fuji.

Google — the name is an intentional misspelling of the word googol, reflecting the company’s mission to organize the immense amount of information available online.

HP — Bill Hewlett and Dave Packard tossed a coin to decide whether the company they founded would be called Hewlett-Packard or Packard-Hewlett.

Hitachi — old place name, literally “sunrise”

Hotmail — Founder Jack Smith got the idea of accessing e-mail via the web from a computer anywhere in the world. When Sabeer Bhatia came up with the business plan for the mail service, he tried all kinds of names ending in ‘mail’ and finally settled for Hotmail as it included the letters “HTML” — the markup language used to write web pages. It was initially referred to as HoTMaiL with selective upper casing. (If you click on Hotmail’s ‘mail’ tab, you will still find “HoTMaiL” in the URL.)
Hyundai — connotes the sense of “the present age” or “modernity” in Korean.

IBM — named by Tom Watson, an ex-employee of National Cash Register. To one-up them in all respects, he called his company International Business Machines.

ICL — abbreviation for International Computers Ltd, once the UK’s largest computer company, but now a service arm of Fujitsu, of Japan.

IKON — copier company name derived from I Know One Name.